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 89: --user_id := fnd_global.user_id;

85:
86: BEGIN
87:
88: -- Default user and login IDs
89: --user_id := fnd_global.user_id;
90: --login_id := fnd_global.login_id;
91:
92: l_up_total := 0;
93: l_ip_total := 0;

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

86: BEGIN
87:
88: -- Default user and login IDs
89: --user_id := fnd_global.user_id;
90: --login_id := fnd_global.login_id;
91:
92: l_up_total := 0;
93: l_ip_total := 0;
94: l_ua_total := 0;

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

658: || chk_id || ', party_id, account_id, '
659: || c_fmt_mask ||', '
660: || c_curr_code || ', '
661: || c_grade
662: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
663: || c_threshold ||', '
664: || c_rating || ', '
665: || c_color
666: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';

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

673: || chk_id || ', party_id, account_id, '
674: || c_fmt_mask ||', '
675: || c_curr_code || ', '
676: || c_grade
677: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
678: || c_threshold ||', '
679: || c_rating || ', '
680: || c_color
681: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL';

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

2840: || chk_id || ', party_id, account_id, '
2841: || c_fmt_mask ||', '
2842: || c_curr_code || ', '
2843: || c_grade
2844: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
2845: || c_threshold ||', '
2846: || c_rating || ', '
2847: || c_color
2848: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';

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

2855: || chk_id || ', party_id, account_id, '
2856: || c_fmt_mask ||', '
2857: || c_curr_code || ', '
2858: || c_grade
2859: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
2860: || c_threshold ||', '
2861: || c_rating || ', '
2862: || c_color
2863: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL';

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

6435: PRAGMA EXCEPTION_INIT(SNAPSHOT_TOO_OLD, -1555);
6436:
6437: Begin
6438: -- Default user and login IDs
6439: --user_id := fnd_global.user_id;
6440: --login_id := fnd_global.login_id;
6441:
6442: IF p_for_party = 'Y' THEN
6443: -- PARTY level insert or update of records

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

6436:
6437: Begin
6438: -- Default user and login IDs
6439: --user_id := fnd_global.user_id;
6440: --login_id := fnd_global.login_id;
6441:
6442: IF p_for_party = 'Y' THEN
6443: -- PARTY level insert or update of records
6444: IF p_for_insert = 'Y' THEN

Line 6466: , FND_GLOBAL.USER_ID

6462: , ip_party_id(i)
6463: , ip_account_id(i)
6464: , ip_value(i)
6465: , ip_currency(i)
6466: , FND_GLOBAL.USER_ID
6467: , Sysdate
6468: , FND_GLOBAL.USER_ID
6469: , Sysdate
6470: , FND_GLOBAL.CONC_LOGIN_ID );

Line 6468: , FND_GLOBAL.USER_ID

6464: , ip_value(i)
6465: , ip_currency(i)
6466: , FND_GLOBAL.USER_ID
6467: , Sysdate
6468: , FND_GLOBAL.USER_ID
6469: , Sysdate
6470: , FND_GLOBAL.CONC_LOGIN_ID );
6471:
6472: ip_block_id.DELETE;

Line 6470: , FND_GLOBAL.CONC_LOGIN_ID );

6466: , FND_GLOBAL.USER_ID
6467: , Sysdate
6468: , FND_GLOBAL.USER_ID
6469: , Sysdate
6470: , FND_GLOBAL.CONC_LOGIN_ID );
6471:
6472: ip_block_id.DELETE;
6473: ip_party_id.DELETE;
6474: ip_account_id.DELETE;

Line 6482: , last_updated_by = FND_GLOBAL.USER_ID

6478: FORALL i IN 1..p_count
6479: UPDATE Csc_Prof_Block_Results
6480: Set value = up_value(i)
6481: , currency_code = up_currency(i)
6482: , last_updated_by = FND_GLOBAL.USER_ID
6483: , last_update_date = sysdate
6484: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6485: Where block_id = up_block_id(i)
6486: And party_id = up_party_id(i);

Line 6484: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6480: Set value = up_value(i)
6481: , currency_code = up_currency(i)
6482: , last_updated_by = FND_GLOBAL.USER_ID
6483: , last_update_date = sysdate
6484: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6485: Where block_id = up_block_id(i)
6486: And party_id = up_party_id(i);
6487:
6488: up_block_id.DELETE;

Line 6518: , FND_GLOBAL.USER_ID

6514: , ia_party_id(i)
6515: , ia_account_id(i)
6516: , ia_value(i)
6517: , ia_currency(i)
6518: , FND_GLOBAL.USER_ID
6519: , Sysdate
6520: , FND_GLOBAL.USER_ID
6521: , Sysdate
6522: , FND_GLOBAL.CONC_LOGIN_ID );

Line 6520: , FND_GLOBAL.USER_ID

6516: , ia_value(i)
6517: , ia_currency(i)
6518: , FND_GLOBAL.USER_ID
6519: , Sysdate
6520: , FND_GLOBAL.USER_ID
6521: , Sysdate
6522: , FND_GLOBAL.CONC_LOGIN_ID );
6523:
6524: ia_block_id.DELETE;

Line 6522: , FND_GLOBAL.CONC_LOGIN_ID );

6518: , FND_GLOBAL.USER_ID
6519: , Sysdate
6520: , FND_GLOBAL.USER_ID
6521: , Sysdate
6522: , FND_GLOBAL.CONC_LOGIN_ID );
6523:
6524: ia_block_id.DELETE;
6525: ia_party_id.DELETE;
6526: ia_account_id.DELETE;

Line 6534: , last_updated_by = FND_GLOBAL.USER_ID

6530: FORALL i IN 1..p_count
6531: UPDATE Csc_Prof_Block_Results
6532: Set value = ua_value(i)
6533: , currency_code = ua_currency(i)
6534: , last_updated_by = FND_GLOBAL.USER_ID
6535: , last_update_date = sysdate
6536: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6537: Where block_id = ua_block_id(i)
6538: And party_id = ua_party_id(i)

Line 6536: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6532: Set value = ua_value(i)
6533: , currency_code = ua_currency(i)
6534: , last_updated_by = FND_GLOBAL.USER_ID
6535: , last_update_date = sysdate
6536: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6537: Where block_id = ua_block_id(i)
6538: And party_id = ua_party_id(i)
6539: And cust_account_id = ua_account_id(i);
6540:

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

6591: PRAGMA EXCEPTION_INIT(INDEXSEGMENT_FULL, -1654);
6592: PRAGMA EXCEPTION_INIT(SNAPSHOT_TOO_OLD, -1555);
6593: Begin
6594: -- Default user and login IDs
6595: --user_id := fnd_global.user_id;
6596: --login_id := fnd_global.login_id;
6597:
6598:
6599: IF p_for_party = 'Y' THEN

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

6592: PRAGMA EXCEPTION_INIT(SNAPSHOT_TOO_OLD, -1555);
6593: Begin
6594: -- Default user and login IDs
6595: --user_id := fnd_global.user_id;
6596: --login_id := fnd_global.login_id;
6597:
6598:
6599: IF p_for_party = 'Y' THEN
6600: -- PARTY level insert or update of records

Line 6632: , FND_GLOBAL.USER_ID

6628: , ip_currency(i)
6629: , ip_grade(i)
6630: , ip_rating_code(i)
6631: , ip_color_code(i)
6632: , FND_GLOBAL.USER_ID
6633: , Sysdate
6634: , FND_GLOBAL.USER_ID
6635: , Sysdate
6636: , FND_GLOBAL.CONC_LOGIN_ID );

Line 6634: , FND_GLOBAL.USER_ID

6630: , ip_rating_code(i)
6631: , ip_color_code(i)
6632: , FND_GLOBAL.USER_ID
6633: , Sysdate
6634: , FND_GLOBAL.USER_ID
6635: , Sysdate
6636: , FND_GLOBAL.CONC_LOGIN_ID );
6637:
6638: ip_check_id.DELETE;

Line 6636: , FND_GLOBAL.CONC_LOGIN_ID );

6632: , FND_GLOBAL.USER_ID
6633: , Sysdate
6634: , FND_GLOBAL.USER_ID
6635: , Sysdate
6636: , FND_GLOBAL.CONC_LOGIN_ID );
6637:
6638: ip_check_id.DELETE;
6639: ip_party_id.DELETE;
6640: ip_account_id.DELETE;

Line 6657: , last_updated_by = FND_GLOBAL.USER_ID

6653: , currency_code = up_currency(i)
6654: , grade = up_grade(i)
6655: , rating_code = up_rating_code(i)
6656: , color_code = up_color_code(i)
6657: , last_updated_by = FND_GLOBAL.USER_ID
6658: , last_update_date = sysdate
6659: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6660: Where check_id = up_check_id(i)
6661: And party_id = up_party_id(i)

Line 6659: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6655: , rating_code = up_rating_code(i)
6656: , color_code = up_color_code(i)
6657: , last_updated_by = FND_GLOBAL.USER_ID
6658: , last_update_date = sysdate
6659: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6660: Where check_id = up_check_id(i)
6661: And party_id = up_party_id(i)
6662: And cust_account_id IS NULL;
6663:

Line 6708: , FND_GLOBAL.USER_ID

6704: , ia_currency(i)
6705: , ia_grade(i)
6706: , ia_rating_code(i)
6707: , ia_color_code(i)
6708: , FND_GLOBAL.USER_ID
6709: , Sysdate
6710: , FND_GLOBAL.USER_ID
6711: , Sysdate
6712: , FND_GLOBAL.CONC_LOGIN_ID );

Line 6710: , FND_GLOBAL.USER_ID

6706: , ia_rating_code(i)
6707: , ia_color_code(i)
6708: , FND_GLOBAL.USER_ID
6709: , Sysdate
6710: , FND_GLOBAL.USER_ID
6711: , Sysdate
6712: , FND_GLOBAL.CONC_LOGIN_ID );
6713:
6714: ia_check_id.DELETE;

Line 6712: , FND_GLOBAL.CONC_LOGIN_ID );

6708: , FND_GLOBAL.USER_ID
6709: , Sysdate
6710: , FND_GLOBAL.USER_ID
6711: , Sysdate
6712: , FND_GLOBAL.CONC_LOGIN_ID );
6713:
6714: ia_check_id.DELETE;
6715: ia_party_id.DELETE;
6716: ia_account_id.DELETE;

Line 6733: , last_updated_by = FND_GLOBAL.USER_ID

6729: , currency_code = ua_currency(i)
6730: , grade = ua_grade(i)
6731: , rating_code = ua_rating_code(i)
6732: , color_code = ua_color_code(i)
6733: , last_updated_by = FND_GLOBAL.USER_ID
6734: , last_update_date = sysdate
6735: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6736: Where check_id = ua_check_id(i)
6737: And party_id = ua_party_id(i)

Line 6735: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

6731: , rating_code = ua_rating_code(i)
6732: , color_code = ua_color_code(i)
6733: , last_updated_by = FND_GLOBAL.USER_ID
6734: , last_update_date = sysdate
6735: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6736: Where check_id = ua_check_id(i)
6737: And party_id = ua_party_id(i)
6738: And cust_account_id = ua_account_id(i);
6739: