APPS.OKS_IMPORT_VALIDATE dependencies on FND_GLOBAL

Line 35: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;

31: --========================================================================
32: -- PRIVATE CONSTANTS AND VARIABLES
33: --========================================================================
34: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
35: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
36: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
37: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
38: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
39: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);

Line 884: ,(CASE WHEN (CGI.PUBLIC_YN = 'Y' OR CGI.USER_ID = FND_GLOBAL.USER_ID)

880: ,COUNT(DISTINCT PTTLN.ROWID) OVER (PARTITION BY HDI.ROWID) PTN_COUNT
881: ,MAX(PTTLN.TERM_ID) OVER (PARTITION BY HDI.ROWID) PTN_ID -- Payment Terms ID based on Name
882: ,COUNT(DISTINCT CGI.ROWID) OVER (PARTITION BY HDI.ROWID) CGI_COUNT
883: ,MAX(HDI.CONTRACT_GROUP_ID) OVER (PARTITION BY HDI.ROWID) CGI_ID -- Contracts Group ID based on Id
884: ,(CASE WHEN (CGI.PUBLIC_YN = 'Y' OR CGI.USER_ID = FND_GLOBAL.USER_ID)
885: THEN 'Y'
886: ELSE 'N'
887: END) CGI_ID_VAL_FLAG
888: ,COUNT(DISTINCT CGBN.ROWID) OVER (PARTITION BY HDI.ROWID) CGN_COUNT

Line 890: ,(CASE WHEN ((HDI.CONTRACT_GROUP_ID IS NULL) AND (CGBN.PUBLIC_YN = 'Y' OR CGBN.USER_ID = FND_GLOBAL.USER_ID))THEN 'Y'

886: ELSE 'N'
887: END) CGI_ID_VAL_FLAG
888: ,COUNT(DISTINCT CGBN.ROWID) OVER (PARTITION BY HDI.ROWID) CGN_COUNT
889: ,MAX(CGBN.ID) OVER (PARTITION BY HDI.ROWID) CGN_ID -- Contracts Group ID based on Name /*modified for Bug:6839334*/
890: ,(CASE WHEN ((HDI.CONTRACT_GROUP_ID IS NULL) AND (CGBN.PUBLIC_YN = 'Y' OR CGBN.USER_ID = FND_GLOBAL.USER_ID))THEN 'Y'
891: WHEN ((HDI.CONTRACT_GROUP_ID IS NOT NULL) AND (CGI.PUBLIC_YN = 'Y' OR CGI.USER_ID = FND_GLOBAL.USER_ID))THEN 'Y'
892: ELSE 'N'
893: END) CGN_ID_VAL_FLAG
894: ,COUNT(DISTINCT CCAI.ROWID) OVER (PARTITION BY HDI.ROWID) CCAI_COUNT

Line 891: WHEN ((HDI.CONTRACT_GROUP_ID IS NOT NULL) AND (CGI.PUBLIC_YN = 'Y' OR CGI.USER_ID = FND_GLOBAL.USER_ID))THEN 'Y'

887: END) CGI_ID_VAL_FLAG
888: ,COUNT(DISTINCT CGBN.ROWID) OVER (PARTITION BY HDI.ROWID) CGN_COUNT
889: ,MAX(CGBN.ID) OVER (PARTITION BY HDI.ROWID) CGN_ID -- Contracts Group ID based on Name /*modified for Bug:6839334*/
890: ,(CASE WHEN ((HDI.CONTRACT_GROUP_ID IS NULL) AND (CGBN.PUBLIC_YN = 'Y' OR CGBN.USER_ID = FND_GLOBAL.USER_ID))THEN 'Y'
891: WHEN ((HDI.CONTRACT_GROUP_ID IS NOT NULL) AND (CGI.PUBLIC_YN = 'Y' OR CGI.USER_ID = FND_GLOBAL.USER_ID))THEN 'Y'
892: ELSE 'N'
893: END) CGN_ID_VAL_FLAG
894: ,COUNT(DISTINCT CCAI.ROWID) OVER (PARTITION BY HDI.ROWID) CCAI_COUNT
895: ,MAX(HDI.CUSTOMER_CONTRACT_ADMIN_ID) OVER (PARTITION BY HDI.ROWID) CCAI_ID -- Customer Contracts Admin ID based on Id

Line 975: AND ((CGBN.PUBLIC_YN = 'Y' OR CGBN.USER_ID = FND_GLOBAL.USER_ID) OR (CGI.PUBLIC_YN = 'Y' OR CGI.USER_ID = FND_GLOBAL.USER_ID)) /*modified for bug:6839334*/

971: AND HDI.CONTRACT_GROUP_ID = CGI.ID (+)
972: AND HDI.CONTRACT_GROUP_NAME = CGTLN.NAME (+)
973: AND CGTLN.LANGUAGE(+) = USERENV('LANG')
974: AND CGTLN.ID = CGBN.ID(+)
975: AND ((CGBN.PUBLIC_YN = 'Y' OR CGBN.USER_ID = FND_GLOBAL.USER_ID) OR (CGI.PUBLIC_YN = 'Y' OR CGI.USER_ID = FND_GLOBAL.USER_ID)) /*modified for bug:6839334*/
976: AND HDI.CUSTOMER_PARTY_ID = CCAI.PARTY_ID (+)
977: AND HDI.CUSTOMER_CONTRACT_ADMIN_ID = CCAI.ID1 (+)
978: AND HDI.CUSTOMER_PARTY_ID = CCAN.PARTY_ID (+)
979: AND HDI.CUSTOMER_CONTRACT_ADMIN_NAME = CCAN.NAME (+)