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.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on FND_GLOBAL

Line 384: , FND_GLOBAL.user_id

380:
381: (
382: l_party_mkt_seg_id
383: , SYSDATE
384: , FND_GLOBAL.user_id
385: , SYSDATE
386: , FND_GLOBAL.user_id
387: , FND_GLOBAL.conc_login_id
388: , 1

Line 386: , FND_GLOBAL.user_id

382: l_party_mkt_seg_id
383: , SYSDATE
384: , FND_GLOBAL.user_id
385: , SYSDATE
386: , FND_GLOBAL.user_id
387: , FND_GLOBAL.conc_login_id
388: , 1
389: , p_mkt_seg_id
390: , p_mkt_seg_flag

Line 387: , FND_GLOBAL.conc_login_id

383: , SYSDATE
384: , FND_GLOBAL.user_id
385: , SYSDATE
386: , FND_GLOBAL.user_id
387: , FND_GLOBAL.conc_login_id
388: , 1
389: , p_mkt_seg_id
390: , p_mkt_seg_flag
391: , l_party_id

Line 408: , last_updated_by = FND_GLOBAL.user_id

404: IF l_expire_party_count > 0 THEN -- party expired
405:
406: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
407: last_update_date = SYSDATE
408: , last_updated_by = FND_GLOBAL.user_id
409: , last_update_login = FND_GLOBAL.conc_login_id
410: , object_version_number = object_version_number + 1
411: , market_segment_id = p_mkt_seg_id
412: , market_segment_flag = p_mkt_seg_flag

Line 409: , last_update_login = FND_GLOBAL.conc_login_id

405:
406: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
407: last_update_date = SYSDATE
408: , last_updated_by = FND_GLOBAL.user_id
409: , last_update_login = FND_GLOBAL.conc_login_id
410: , object_version_number = object_version_number + 1
411: , market_segment_id = p_mkt_seg_id
412: , market_segment_flag = p_mkt_seg_flag
413: , party_id = l_party_id

Line 758: , FND_GLOBAL.user_id

754: VALUES
755: (
756: l_party_mkt_seg_id
757: , SYSDATE
758: , FND_GLOBAL.user_id
759: , SYSDATE
760: , FND_GLOBAL.user_id
761: , FND_GLOBAL.conc_login_id
762: , 1

Line 760: , FND_GLOBAL.user_id

756: l_party_mkt_seg_id
757: , SYSDATE
758: , FND_GLOBAL.user_id
759: , SYSDATE
760: , FND_GLOBAL.user_id
761: , FND_GLOBAL.conc_login_id
762: , 1
763: , p_mkt_seg_id
764: , p_mkt_seg_flag

Line 761: , FND_GLOBAL.conc_login_id

757: , SYSDATE
758: , FND_GLOBAL.user_id
759: , SYSDATE
760: , FND_GLOBAL.user_id
761: , FND_GLOBAL.conc_login_id
762: , 1
763: , p_mkt_seg_id
764: , p_mkt_seg_flag
765: , l_party_id

Line 782: , last_updated_by = FND_GLOBAL.user_id

778: IF l_expire_party_count > 0 THEN -- party expired
779:
780: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
781: last_update_date = SYSDATE
782: , last_updated_by = FND_GLOBAL.user_id
783: , last_update_login = FND_GLOBAL.conc_login_id
784: , object_version_number = object_version_number + 1
785: , market_segment_id = p_mkt_seg_id
786: , market_segment_flag = p_mkt_seg_flag

Line 783: , last_update_login = FND_GLOBAL.conc_login_id

779:
780: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
781: last_update_date = SYSDATE
782: , last_updated_by = FND_GLOBAL.user_id
783: , last_update_login = FND_GLOBAL.conc_login_id
784: , object_version_number = object_version_number + 1
785: , market_segment_id = p_mkt_seg_id
786: , market_segment_flag = p_mkt_seg_flag
787: , party_id = l_party_id

Line 2866: l_final_sql := l_final_sql || ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, SYSDATE, FND_GLOBAL.user_id';

2862: l_final_sql := 'INSERT INTO AMS_PARTY_MARKET_SEGMENTS(ams_party_market_segment_id, last_update_date, last_updated_by';
2863: l_final_sql := l_final_sql || ', creation_date, created_by, last_update_login, object_version_number, market_segment_id';
2864: l_final_sql := l_final_sql || ', market_segment_flag, party_id, start_date_active, end_date_active, org_id';
2865: l_final_sql := l_final_sql || ', market_qualifier_type, market_qualifier_reference, cust_account_id, cust_acct_site_id, site_use_code)';
2866: l_final_sql := l_final_sql || ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, SYSDATE, FND_GLOBAL.user_id';
2867: l_final_sql := l_final_sql || ', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.conc_login_id, 1, 0';
2868: l_final_sql := l_final_sql || ', ''N'', party_id, SYSDATE, NULL, :org_id org_id';
2869: l_final_sql := l_final_sql || ', ''TERRITORY'', :terr_id market_qualifier_reference, cust_account_id, cust_acct_site_id, site_use_code FROM (';
2870: l_final_sql := l_final_sql || l_party_select_sql || substr(l_party_where_sql, 1, length(l_party_where_sql)-4) || ')';

Line 2867: l_final_sql := l_final_sql || ', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.conc_login_id, 1, 0';

2863: l_final_sql := l_final_sql || ', creation_date, created_by, last_update_login, object_version_number, market_segment_id';
2864: l_final_sql := l_final_sql || ', market_segment_flag, party_id, start_date_active, end_date_active, org_id';
2865: l_final_sql := l_final_sql || ', market_qualifier_type, market_qualifier_reference, cust_account_id, cust_acct_site_id, site_use_code)';
2866: l_final_sql := l_final_sql || ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, SYSDATE, FND_GLOBAL.user_id';
2867: l_final_sql := l_final_sql || ', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.conc_login_id, 1, 0';
2868: l_final_sql := l_final_sql || ', ''N'', party_id, SYSDATE, NULL, :org_id org_id';
2869: l_final_sql := l_final_sql || ', ''TERRITORY'', :terr_id market_qualifier_reference, cust_account_id, cust_acct_site_id, site_use_code FROM (';
2870: l_final_sql := l_final_sql || l_party_select_sql || substr(l_party_where_sql, 1, length(l_party_where_sql)-4) || ')';
2871: l_denorm_csr := DBMS_SQL.open_cursor;

Line 2930: , FND_GLOBAL.user_id

2926: VALUES
2927: (
2928: l_party_mkt_seg_id
2929: , SYSDATE
2930: , FND_GLOBAL.user_id
2931: , SYSDATE
2932: , FND_GLOBAL.user_id
2933: , FND_GLOBAL.conc_login_id
2934: , 1

Line 2932: , FND_GLOBAL.user_id

2928: l_party_mkt_seg_id
2929: , SYSDATE
2930: , FND_GLOBAL.user_id
2931: , SYSDATE
2932: , FND_GLOBAL.user_id
2933: , FND_GLOBAL.conc_login_id
2934: , 1
2935: , 0
2936: , 'N'

Line 2933: , FND_GLOBAL.conc_login_id

2929: , SYSDATE
2930: , FND_GLOBAL.user_id
2931: , SYSDATE
2932: , FND_GLOBAL.user_id
2933: , FND_GLOBAL.conc_login_id
2934: , 1
2935: , 0
2936: , 'N'
2937: , l_party_id

Line 3079: , FND_GLOBAL.user_id

3075: VALUES
3076: (
3077: l_index
3078: , SYSDATE
3079: , FND_GLOBAL.user_id
3080: , SYSDATE
3081: , FND_GLOBAL.user_id
3082: , FND_GLOBAL.conc_login_id
3083: , 1

Line 3081: , FND_GLOBAL.user_id

3077: l_index
3078: , SYSDATE
3079: , FND_GLOBAL.user_id
3080: , SYSDATE
3081: , FND_GLOBAL.user_id
3082: , FND_GLOBAL.conc_login_id
3083: , 1
3084: , 0
3085: , 'N'

Line 3082: , FND_GLOBAL.conc_login_id

3078: , SYSDATE
3079: , FND_GLOBAL.user_id
3080: , SYSDATE
3081: , FND_GLOBAL.user_id
3082: , FND_GLOBAL.conc_login_id
3083: , 1
3084: , 0
3085: , 'N'
3086: , p_bg_id

Line 3162: , FND_GLOBAL.user_id

3158: VALUES
3159: (
3160: l_party_mkt_seg_id(I)
3161: , SYSDATE
3162: , FND_GLOBAL.user_id
3163: , SYSDATE
3164: , FND_GLOBAL.user_id
3165: , FND_GLOBAL.conc_login_id
3166: , 1

Line 3164: , FND_GLOBAL.user_id

3160: l_party_mkt_seg_id(I)
3161: , SYSDATE
3162: , FND_GLOBAL.user_id
3163: , SYSDATE
3164: , FND_GLOBAL.user_id
3165: , FND_GLOBAL.conc_login_id
3166: , 1
3167: , 0
3168: , 'N'

Line 3165: , FND_GLOBAL.conc_login_id

3161: , SYSDATE
3162: , FND_GLOBAL.user_id
3163: , SYSDATE
3164: , FND_GLOBAL.user_id
3165: , FND_GLOBAL.conc_login_id
3166: , 1
3167: , 0
3168: , 'N'
3169: , l_all_obj_list(I)

Line 3210: , FND_GLOBAL.user_id

3206: VALUES
3207: (
3208: l_party_mkt_seg_id(I)
3209: , SYSDATE
3210: , FND_GLOBAL.user_id
3211: , SYSDATE
3212: , FND_GLOBAL.user_id
3213: , FND_GLOBAL.conc_login_id
3214: , 1

Line 3212: , FND_GLOBAL.user_id

3208: l_party_mkt_seg_id(I)
3209: , SYSDATE
3210: , FND_GLOBAL.user_id
3211: , SYSDATE
3212: , FND_GLOBAL.user_id
3213: , FND_GLOBAL.conc_login_id
3214: , 1
3215: , 0
3216: , 'N'

Line 3213: , FND_GLOBAL.conc_login_id

3209: , SYSDATE
3210: , FND_GLOBAL.user_id
3211: , SYSDATE
3212: , FND_GLOBAL.user_id
3213: , FND_GLOBAL.conc_login_id
3214: , 1
3215: , 0
3216: , 'N'
3217: , p_bg_id