eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROFILE_ENGINE_PKG dependencies on FND_GLOBAL

Line 94: --user_id := fnd_global.user_id;

90:
91: BEGIN
92:
93: -- Default user and login IDs
94: --user_id := fnd_global.user_id;
95: --login_id := fnd_global.login_id;
96:
97: l_up_total := 0;
98: l_ip_total := 0;

Line 95: --login_id := fnd_global.login_id;

91: BEGIN
92:
93: -- Default user and login IDs
94: --user_id := fnd_global.user_id;
95: --login_id := fnd_global.login_id;
96:
97: l_up_total := 0;
98: l_ip_total := 0;
99: l_ua_total := 0;

Line 764: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '

760: || chk_id || ', party_id, account_id,party_site_id, ' -- Inlcuded 'party_site_id' by spamujul for ER#8473903
761: || c_fmt_mask ||', '
762: || c_curr_code || ', '
763: || c_grade
764: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
765: || c_threshold ||', '
766: || c_rating || ', '
767: || c_color
768: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999 and PARTY_SITE_ID IS NULL'; -- Inlcuded 'party_site_id' IS NULL FOR ER#8473903

Line 784: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '

780: || chk_id || ', party_id, account_id,party_site_id, ' -- Inlcuded 'party_site_id' by spamujul for ER#8473903
781: || c_fmt_mask ||', '
782: || c_curr_code || ', '
783: || c_grade
784: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
785: || c_threshold ||', '
786: || c_rating || ', '
787: || c_color
788: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(party_site_id, -999999) <> -999999 and account_id IS NULL';

Line 800: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '

796: || chk_id || ', party_id, account_id,party_site_id ,'
797: || c_fmt_mask ||', '
798: || c_curr_code || ', '
799: || c_grade
800: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
801: || c_threshold ||', '
802: || c_rating || ', '
803: || c_color
804: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL and PARTY_SITE_ID IS NULL'; -- Inlcuded 'party_site_id' IS NULL FOR ER#8473903';

Line 3971: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '

3967: || chk_id || ', party_id, account_id,party_site_id, '
3968: || c_fmt_mask ||', '
3969: || c_curr_code || ', '
3970: || c_grade
3971: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
3972: || c_threshold ||', '
3973: || c_rating || ', '
3974: || c_color
3975: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999 and party_site_id IS NULL'; -- Added 'AND PARTY_SITE_ID IS NULL' for ER#8473903

Line 3991: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '

3987: || chk_id || ', party_id, account_id,party_site_id, '
3988: || c_fmt_mask ||', '
3989: || c_curr_code || ', '
3990: || c_grade
3991: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
3992: || c_threshold ||', '
3993: || c_rating || ', '
3994: || c_color
3995: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(party_site_id, -999999) <> -999999 and account_id IS NULL';

Line 4011: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '

4007: || chk_id || ', party_id, account_id,party_site_id, '
4008: || c_fmt_mask ||', '
4009: || c_curr_code || ', '
4010: || c_grade
4011: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
4012: || c_threshold ||', '
4013: || c_rating || ', '
4014: || c_color
4015: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL and party_site_id IS NULL'; -- Added 'AND PARTY_SITE_ID IS NULL' for ER#8473903

Line 9004: --user_id := fnd_global.user_id;

9000: PRAGMA EXCEPTION_INIT(SNAPSHOT_TOO_OLD, -1555);
9001:
9002: Begin
9003: -- Default user and login IDs
9004: --user_id := fnd_global.user_id;
9005: --login_id := fnd_global.login_id;
9006: IF P_FOR_PSITE ='N' Then -- Added by spamujul for ER#8473903
9007: IF p_for_party = 'Y' THEN
9008: -- PARTY level insert or update of records

Line 9005: --login_id := fnd_global.login_id;

9001:
9002: Begin
9003: -- Default user and login IDs
9004: --user_id := fnd_global.user_id;
9005: --login_id := fnd_global.login_id;
9006: IF P_FOR_PSITE ='N' Then -- Added by spamujul for ER#8473903
9007: IF p_for_party = 'Y' THEN
9008: -- PARTY level insert or update of records
9009: IF p_for_insert = 'Y' THEN

Line 9033: , FND_GLOBAL.USER_ID

9029: , ip_account_id(i)
9030: , ip_psite_id(i) -- Added by spamujul for ER#8473903
9031: , ip_value(i)
9032: , ip_currency(i)
9033: , FND_GLOBAL.USER_ID
9034: , Sysdate
9035: , FND_GLOBAL.USER_ID
9036: , Sysdate
9037: , FND_GLOBAL.CONC_LOGIN_ID );

Line 9035: , FND_GLOBAL.USER_ID

9031: , ip_value(i)
9032: , ip_currency(i)
9033: , FND_GLOBAL.USER_ID
9034: , Sysdate
9035: , FND_GLOBAL.USER_ID
9036: , Sysdate
9037: , FND_GLOBAL.CONC_LOGIN_ID );
9038:
9039: ip_block_id.DELETE;

Line 9037: , FND_GLOBAL.CONC_LOGIN_ID );

9033: , FND_GLOBAL.USER_ID
9034: , Sysdate
9035: , FND_GLOBAL.USER_ID
9036: , Sysdate
9037: , FND_GLOBAL.CONC_LOGIN_ID );
9038:
9039: ip_block_id.DELETE;
9040: ip_party_id.DELETE;
9041: ip_account_id.DELETE;

Line 9050: , last_updated_by = FND_GLOBAL.USER_ID

9046: FORALL i IN 1..p_count
9047: UPDATE Csc_Prof_Block_Results
9048: Set value = up_value(i)
9049: , currency_code = up_currency(i)
9050: , last_updated_by = FND_GLOBAL.USER_ID
9051: , last_update_date = sysdate
9052: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9053: Where block_id = up_block_id(i)
9054: And party_id = up_party_id(i)

Line 9052: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9048: Set value = up_value(i)
9049: , currency_code = up_currency(i)
9050: , last_updated_by = FND_GLOBAL.USER_ID
9051: , last_update_date = sysdate
9052: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9053: Where block_id = up_block_id(i)
9054: And party_id = up_party_id(i)
9055: AND cust_account_id IS NULL AND party_site_id IS NULL -- Added by spamujul for ER#8473903
9056: ;

Line 9090: , FND_GLOBAL.USER_ID

9086: , ia_account_id(i)
9087: , ia_psite_id(i) -- Added by spamujul for ER#8473903
9088: , ia_value(i)
9089: , ia_currency(i)
9090: , FND_GLOBAL.USER_ID
9091: , Sysdate
9092: , FND_GLOBAL.USER_ID
9093: , Sysdate
9094: , FND_GLOBAL.CONC_LOGIN_ID );

Line 9092: , FND_GLOBAL.USER_ID

9088: , ia_value(i)
9089: , ia_currency(i)
9090: , FND_GLOBAL.USER_ID
9091: , Sysdate
9092: , FND_GLOBAL.USER_ID
9093: , Sysdate
9094: , FND_GLOBAL.CONC_LOGIN_ID );
9095:
9096: ia_block_id.DELETE;

Line 9094: , FND_GLOBAL.CONC_LOGIN_ID );

9090: , FND_GLOBAL.USER_ID
9091: , Sysdate
9092: , FND_GLOBAL.USER_ID
9093: , Sysdate
9094: , FND_GLOBAL.CONC_LOGIN_ID );
9095:
9096: ia_block_id.DELETE;
9097: ia_party_id.DELETE;
9098: ia_account_id.DELETE;

Line 9107: , last_updated_by = FND_GLOBAL.USER_ID

9103: FORALL i IN 1..p_count
9104: UPDATE Csc_Prof_Block_Results
9105: Set value = ua_value(i)
9106: , currency_code = ua_currency(i)
9107: , last_updated_by = FND_GLOBAL.USER_ID
9108: , last_update_date = sysdate
9109: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9110: Where block_id = ua_block_id(i)
9111: And party_id = ua_party_id(i)

Line 9109: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9105: Set value = ua_value(i)
9106: , currency_code = ua_currency(i)
9107: , last_updated_by = FND_GLOBAL.USER_ID
9108: , last_update_date = sysdate
9109: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9110: Where block_id = ua_block_id(i)
9111: And party_id = ua_party_id(i)
9112: And cust_account_id = ua_account_id(i)
9113: And party_site_id IS NULL -- Added by spamujul for ER#8473903

Line 9150: , FND_GLOBAL.USER_ID

9146: , is_party_id(i)
9147: , is_account_id(i)
9148: , is_value(i)
9149: , is_currency(i)
9150: , FND_GLOBAL.USER_ID
9151: , Sysdate
9152: , FND_GLOBAL.USER_ID
9153: , Sysdate
9154: , FND_GLOBAL.CONC_LOGIN_ID

Line 9152: , FND_GLOBAL.USER_ID

9148: , is_value(i)
9149: , is_currency(i)
9150: , FND_GLOBAL.USER_ID
9151: , Sysdate
9152: , FND_GLOBAL.USER_ID
9153: , Sysdate
9154: , FND_GLOBAL.CONC_LOGIN_ID
9155: , is_psite_id(i)
9156: );

Line 9154: , FND_GLOBAL.CONC_LOGIN_ID

9150: , FND_GLOBAL.USER_ID
9151: , Sysdate
9152: , FND_GLOBAL.USER_ID
9153: , Sysdate
9154: , FND_GLOBAL.CONC_LOGIN_ID
9155: , is_psite_id(i)
9156: );
9157: is_block_id.DELETE;
9158: is_party_id.DELETE;

Line 9168: , last_updated_by = FND_GLOBAL.USER_ID

9164: FORALL i IN 1..p_count
9165: UPDATE Csc_Prof_Block_Results
9166: Set value = us_value(i)
9167: , currency_code = us_currency(i)
9168: , last_updated_by = FND_GLOBAL.USER_ID
9169: , last_update_date = sysdate
9170: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9171: Where block_id = us_block_id(i)
9172: And party_id = us_party_id(i)

Line 9170: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9166: Set value = us_value(i)
9167: , currency_code = us_currency(i)
9168: , last_updated_by = FND_GLOBAL.USER_ID
9169: , last_update_date = sysdate
9170: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9171: Where block_id = us_block_id(i)
9172: And party_id = us_party_id(i)
9173: And cust_account_id IS NULL
9174: And party_site_id = us_psite_id(i)

Line 9231: --user_id := fnd_global.user_id;

9227: PRAGMA EXCEPTION_INIT(INDEXSEGMENT_FULL, -1654);
9228: PRAGMA EXCEPTION_INIT(SNAPSHOT_TOO_OLD, -1555);
9229: BEGIN
9230: -- Default user and login IDs
9231: --user_id := fnd_global.user_id;
9232: --login_id := fnd_global.login_id;
9233: IF p_for_psite ='N' THEN -- Added by spamujul for ER#8473903
9234: IF p_for_party = 'Y' THEN
9235: -- PARTY level insert or update of records

Line 9232: --login_id := fnd_global.login_id;

9228: PRAGMA EXCEPTION_INIT(SNAPSHOT_TOO_OLD, -1555);
9229: BEGIN
9230: -- Default user and login IDs
9231: --user_id := fnd_global.user_id;
9232: --login_id := fnd_global.login_id;
9233: IF p_for_psite ='N' THEN -- Added by spamujul for ER#8473903
9234: IF p_for_party = 'Y' THEN
9235: -- PARTY level insert or update of records
9236: IF p_for_insert = 'Y' THEN

Line 9272: FND_GLOBAL.USER_ID ,

9268: ip_currency(i) ,
9269: ip_grade(i) ,
9270: ip_rating_code(i) ,
9271: ip_color_code(i) ,
9272: FND_GLOBAL.USER_ID ,
9273: SYSDATE ,
9274: FND_GLOBAL.USER_ID ,
9275: SYSDATE ,
9276: FND_GLOBAL.CONC_LOGIN_ID

Line 9274: FND_GLOBAL.USER_ID ,

9270: ip_rating_code(i) ,
9271: ip_color_code(i) ,
9272: FND_GLOBAL.USER_ID ,
9273: SYSDATE ,
9274: FND_GLOBAL.USER_ID ,
9275: SYSDATE ,
9276: FND_GLOBAL.CONC_LOGIN_ID
9277: );
9278:

Line 9276: FND_GLOBAL.CONC_LOGIN_ID

9272: FND_GLOBAL.USER_ID ,
9273: SYSDATE ,
9274: FND_GLOBAL.USER_ID ,
9275: SYSDATE ,
9276: FND_GLOBAL.CONC_LOGIN_ID
9277: );
9278:
9279: ip_check_id.DELETE;
9280: ip_party_id.DELETE;

Line 9298: last_updated_by = FND_GLOBAL.USER_ID ,

9294: currency_code = up_currency(i) ,
9295: grade = up_grade(i) ,
9296: rating_code = up_rating_code(i) ,
9297: color_code = up_color_code(i) ,
9298: last_updated_by = FND_GLOBAL.USER_ID ,
9299: last_update_date = SYSDATE ,
9300: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9301: WHERE check_id = up_check_id(i)
9302: AND party_id = up_party_id(i)

Line 9300: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9296: rating_code = up_rating_code(i) ,
9297: color_code = up_color_code(i) ,
9298: last_updated_by = FND_GLOBAL.USER_ID ,
9299: last_update_date = SYSDATE ,
9300: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9301: WHERE check_id = up_check_id(i)
9302: AND party_id = up_party_id(i)
9303: AND cust_account_id IS NULL
9304: AND party_site_id IS NULL -- Added by spamujul for ER#8473903

Line 9356: FND_GLOBAL.USER_ID ,

9352: ia_currency(i) ,
9353: ia_grade(i) ,
9354: ia_rating_code(i) ,
9355: ia_color_code(i) ,
9356: FND_GLOBAL.USER_ID ,
9357: SYSDATE ,
9358: FND_GLOBAL.USER_ID ,
9359: SYSDATE ,
9360: FND_GLOBAL.CONC_LOGIN_ID

Line 9358: FND_GLOBAL.USER_ID ,

9354: ia_rating_code(i) ,
9355: ia_color_code(i) ,
9356: FND_GLOBAL.USER_ID ,
9357: SYSDATE ,
9358: FND_GLOBAL.USER_ID ,
9359: SYSDATE ,
9360: FND_GLOBAL.CONC_LOGIN_ID
9361: );
9362:

Line 9360: FND_GLOBAL.CONC_LOGIN_ID

9356: FND_GLOBAL.USER_ID ,
9357: SYSDATE ,
9358: FND_GLOBAL.USER_ID ,
9359: SYSDATE ,
9360: FND_GLOBAL.CONC_LOGIN_ID
9361: );
9362:
9363: ia_check_id.DELETE;
9364: ia_party_id.DELETE;

Line 9382: last_updated_by = FND_GLOBAL.USER_ID ,

9378: currency_code = ua_currency(i) ,
9379: grade = ua_grade(i) ,
9380: rating_code = ua_rating_code(i) ,
9381: color_code = ua_color_code(i) ,
9382: last_updated_by = FND_GLOBAL.USER_ID ,
9383: last_update_date = SYSDATE ,
9384: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9385: WHERE check_id = ua_check_id(i)
9386: AND party_id = ua_party_id(i)

Line 9384: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9380: rating_code = ua_rating_code(i) ,
9381: color_code = ua_color_code(i) ,
9382: last_updated_by = FND_GLOBAL.USER_ID ,
9383: last_update_date = SYSDATE ,
9384: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9385: WHERE check_id = ua_check_id(i)
9386: AND party_id = ua_party_id(i)
9387: AND cust_account_id = ua_account_id(i)
9388: AND party_site_id IS NULL -- Added by spamujul for ER#8473903

Line 9440: FND_GLOBAL.USER_ID ,

9436: is_currency(i) ,
9437: is_grade(i) ,
9438: is_rating_code(i) ,
9439: is_color_code(i) ,
9440: FND_GLOBAL.USER_ID ,
9441: SYSDATE ,
9442: FND_GLOBAL.USER_ID ,
9443: SYSDATE ,
9444: FND_GLOBAL.CONC_LOGIN_ID

Line 9442: FND_GLOBAL.USER_ID ,

9438: is_rating_code(i) ,
9439: is_color_code(i) ,
9440: FND_GLOBAL.USER_ID ,
9441: SYSDATE ,
9442: FND_GLOBAL.USER_ID ,
9443: SYSDATE ,
9444: FND_GLOBAL.CONC_LOGIN_ID
9445: );
9446:

Line 9444: FND_GLOBAL.CONC_LOGIN_ID

9440: FND_GLOBAL.USER_ID ,
9441: SYSDATE ,
9442: FND_GLOBAL.USER_ID ,
9443: SYSDATE ,
9444: FND_GLOBAL.CONC_LOGIN_ID
9445: );
9446:
9447: is_check_id.DELETE;
9448: is_party_id.DELETE;

Line 9466: last_updated_by = FND_GLOBAL.USER_ID ,

9462: currency_code = us_currency(i) ,
9463: grade = us_grade(i) ,
9464: rating_code = us_rating_code(i) ,
9465: color_code = us_color_code(i) ,
9466: last_updated_by = FND_GLOBAL.USER_ID ,
9467: last_update_date = SYSDATE ,
9468: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9469: WHERE check_id = us_check_id(i)
9470: AND party_id = us_party_id(i)

Line 9468: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

9464: rating_code = us_rating_code(i) ,
9465: color_code = us_color_code(i) ,
9466: last_updated_by = FND_GLOBAL.USER_ID ,
9467: last_update_date = SYSDATE ,
9468: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
9469: WHERE check_id = us_check_id(i)
9470: AND party_id = us_party_id(i)
9471: AND cust_account_id IS NULL
9472: AND party_site_id = us_psite_id(i);