Getting Snapshot Labels Common to All Tables in a BA Instance for a Given Blinding Access Type

You can allow the user, on login, to choose to view current data or data based on a snapshot label.

A snapshot label is available for selection only if all source Table instances have the same label applied. Table instances that are pass-through views can display only current data, so if one or more Table instance is a view, only current data will be available for the Business Area.

Use public API CDR_PUB_API_GVA.GETSNAPSHOTLABELS to get the snapshot labels common to all Table instances mapped to Table Descriptors in a single Business Area instance. The API has an input parameter for blinding access type because snapshot labels may be different for dummy and real data.

If you do not use the API or the user does not provide a snapshot label selection, the system displays the data currency specified for the Business Area; see Default Currency.

Signature

FUNCTION GETSNAPSHOTLABELS(
															PI_COMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE,
															PI_OBJID     IN CDR_NAMINGS.OBJ_ID%TYPE,
															PI_OBJVER    IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE,
															PI_VBLINDINGACCESSTYPE IN VARCHAR2) 
RETURN CURRENCYCOLL PIPELINED;

Return

A collection (CURRENCYCOLL) of the snapshot labels for a particular blinding access type in the Business Area instance common to all Tables within a Business Area Instance.

Parameters

This API has the following parameters.

PI_COMPANYID. Enter the Business Area instance's company ID.

PI_OBJID. Enter the Business Area instance's object ID.

PI_OBJVER. Enter the Business Area instance's object version.

PI_VBLINDINGACCESSTYPE. Enter the blinding access type. The allowed values are: NA/Dummy , Real(Unblinded), or Real(BlindBreak). Note that there is no space between Real and the parentheses/brackets.