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

Line 34: fnd_global.user_id,

30: p_source_key,
31: p_source_key_type,
32: p_source_key_column_name,
33: p_source_key_column_type,
34: fnd_global.user_id,
35: SYSDATE,
36: fnd_global.user_id,
37: sysdate,
38: fnd_global.login_id);

Line 36: fnd_global.user_id,

32: p_source_key_column_name,
33: p_source_key_column_type,
34: fnd_global.user_id,
35: SYSDATE,
36: fnd_global.user_id,
37: sysdate,
38: fnd_global.login_id);
39: EXCEPTION
40: WHEN OTHERS THEN

Line 38: fnd_global.login_id);

34: fnd_global.user_id,
35: SYSDATE,
36: fnd_global.user_id,
37: sysdate,
38: fnd_global.login_id);
39: EXCEPTION
40: WHEN OTHERS THEN
41: p_errmsg := 'Error while inserting into ar_cmgt_cf_dnb_dtls '||sqlerrm;
42: p_resultout := 1;

Line 109: fnd_global.user_id,

105: p_data_point_value,
106: p_score,
107: p_included_in_checklist,
108: p_data_point_value_id,
109: fnd_global.user_id,
110: fnd_global.user_id,
111: sysdate,
112: fnd_global.login_id,
113: sysdate);

Line 110: fnd_global.user_id,

106: p_score,
107: p_included_in_checklist,
108: p_data_point_value_id,
109: fnd_global.user_id,
110: fnd_global.user_id,
111: sysdate,
112: fnd_global.login_id,
113: sysdate);
114: return ;

Line 112: fnd_global.login_id,

108: p_data_point_value_id,
109: fnd_global.user_id,
110: fnd_global.user_id,
111: sysdate,
112: fnd_global.login_id,
113: sysdate);
114: return ;
115:
116: EXCEPTION

Line 198: fnd_global.user_id,

194: p_type,
195: p_limit_currency,
196: p_exchange_rate_type,
197: SYSDATE,
198: fnd_global.user_id,
199: SYSDATE,
200: fnd_global.user_id,
201: SYSDATE,
202: fnd_global.login_id,

Line 200: fnd_global.user_id,

196: p_exchange_rate_type,
197: SYSDATE,
198: fnd_global.user_id,
199: SYSDATE,
200: fnd_global.user_id,
201: SYSDATE,
202: fnd_global.login_id,
203: SYSDATE);
204: EXCEPTION

Line 202: fnd_global.login_id,

198: fnd_global.user_id,
199: SYSDATE,
200: fnd_global.user_id,
201: SYSDATE,
202: fnd_global.login_id,
203: SYSDATE);
204: EXCEPTION
205: WHEN OTHERS
206: THEN

Line 258: last_updated_by = fnd_global.user_id,

254:
255: UPDATE ar_cmgt_cf_dtls
256: SET score = nvl(p_score,score),
257: data_point_value = nvl(p_data_point_value, data_point_value),
258: last_updated_by = fnd_global.user_id,
259: last_update_date = sysdate,
260: last_update_login = fnd_global.login_id
261: WHERE case_folder_id = p_case_folder_id
262: AND data_point_id = p_data_point_id;

Line 260: last_update_login = fnd_global.login_id

256: SET score = nvl(p_score,score),
257: data_point_value = nvl(p_data_point_value, data_point_value),
258: last_updated_by = fnd_global.user_id,
259: last_update_date = sysdate,
260: last_update_login = fnd_global.login_id
261: WHERE case_folder_id = p_case_folder_id
262: AND data_point_id = p_data_point_id;
263:
264: IF sql%NOTFOUND

Line 333: last_updated_by = fnd_global.user_id,

329:
330: UPDATE ar_cmgt_cf_dtls
331: SET score = nvl(p_score,score),
332: data_point_value = nvl(p_data_point_value, data_point_value),
333: last_updated_by = fnd_global.user_id,
334: last_update_date = sysdate,
335: last_update_login = fnd_global.login_id
336: WHERE case_folder_detail_id = p_case_folder_detail_id
337: AND data_point_id = p_data_point_id;

Line 335: last_update_login = fnd_global.login_id

331: SET score = nvl(p_score,score),
332: data_point_value = nvl(p_data_point_value, data_point_value),
333: last_updated_by = fnd_global.user_id,
334: last_update_date = sysdate,
335: last_update_login = fnd_global.login_id
336: WHERE case_folder_detail_id = p_case_folder_detail_id
337: AND data_point_id = p_data_point_id;
338:
339: IF sql%NOTFOUND

Line 425: fnd_global.user_id,

421: p_credit_recommendation,
422: p_recommendation_value1,
423: p_recommendation_value2,
424: p_status,
425: fnd_global.user_id,
426: sysdate,
427: fnd_global.login_id,
428: sysdate,
429: fnd_global.user_id,

Line 427: fnd_global.login_id,

423: p_recommendation_value2,
424: p_status,
425: fnd_global.user_id,
426: sysdate,
427: fnd_global.login_id,
428: sysdate,
429: fnd_global.user_id,
430: p_credit_type,
431: l_recommendation_name,

Line 429: fnd_global.user_id,

425: fnd_global.user_id,
426: sysdate,
427: fnd_global.login_id,
428: sysdate,
429: fnd_global.user_id,
430: p_credit_type,
431: l_recommendation_name,
432: l_appl_id);
433: EXCEPTION

Line 461: p_created_by => fnd_global.user_id,

457: p_data_point_category => p_data_point_category,
458: p_user_defined_flag => p_user_defined_flag,
459: p_scorable_flag => p_scorable_flag,
460: p_display_on_checklist => p_display_on_checklist,
461: p_created_by => fnd_global.user_id,
462: p_last_updated_by => fnd_global.user_id,
463: p_last_update_login => fnd_global.login_id,
464: p_data_point_id => p_data_point_id,
465: p_return_data_type => 'C',

Line 462: p_last_updated_by => fnd_global.user_id,

458: p_user_defined_flag => p_user_defined_flag,
459: p_scorable_flag => p_scorable_flag,
460: p_display_on_checklist => p_display_on_checklist,
461: p_created_by => fnd_global.user_id,
462: p_last_updated_by => fnd_global.user_id,
463: p_last_update_login => fnd_global.login_id,
464: p_data_point_id => p_data_point_id,
465: p_return_data_type => 'C',
466: p_return_date_format => null,

Line 463: p_last_update_login => fnd_global.login_id,

459: p_scorable_flag => p_scorable_flag,
460: p_display_on_checklist => p_display_on_checklist,
461: p_created_by => fnd_global.user_id,
462: p_last_updated_by => fnd_global.user_id,
463: p_last_update_login => fnd_global.login_id,
464: p_data_point_id => p_data_point_id,
465: p_return_data_type => 'C',
466: p_return_date_format => null,
467: p_application_id => 222,

Line 516: p_created_by => fnd_global.user_id,

512: p_data_point_category => p_data_point_category,
513: p_user_defined_flag => p_user_defined_flag,
514: p_scorable_flag => p_scorable_flag,
515: p_display_on_checklist => p_display_on_checklist,
516: p_created_by => fnd_global.user_id,
517: p_last_updated_by => fnd_global.user_id,
518: p_last_update_login => fnd_global.login_id,
519: p_data_point_id => l_dp_id,
520: p_application_id => p_application_id,

Line 517: p_last_updated_by => fnd_global.user_id,

513: p_user_defined_flag => p_user_defined_flag,
514: p_scorable_flag => p_scorable_flag,
515: p_display_on_checklist => p_display_on_checklist,
516: p_created_by => fnd_global.user_id,
517: p_last_updated_by => fnd_global.user_id,
518: p_last_update_login => fnd_global.login_id,
519: p_data_point_id => l_dp_id,
520: p_application_id => p_application_id,
521: p_parent_data_point_id => p_parent_data_point_id,

Line 518: p_last_update_login => fnd_global.login_id,

514: p_scorable_flag => p_scorable_flag,
515: p_display_on_checklist => p_display_on_checklist,
516: p_created_by => fnd_global.user_id,
517: p_last_updated_by => fnd_global.user_id,
518: p_last_update_login => fnd_global.login_id,
519: p_data_point_id => l_dp_id,
520: p_application_id => p_application_id,
521: p_parent_data_point_id => p_parent_data_point_id,
522: p_enabled_flag => p_enabled_flag,

Line 552: fnd_global.user_id,

548: amount
549: )
550: values
551: (p_case_folder_id,
552: fnd_global.user_id,
553: sysdate,
554: fnd_global.user_id,
555: sysdate,
556: fnd_global.user_id,

Line 554: fnd_global.user_id,

550: values
551: (p_case_folder_id,
552: fnd_global.user_id,
553: sysdate,
554: fnd_global.user_id,
555: sysdate,
556: fnd_global.user_id,
557: p_aging_bucket_id,
558: p_aging_bucket_line_id,

Line 556: fnd_global.user_id,

552: fnd_global.user_id,
553: sysdate,
554: fnd_global.user_id,
555: sysdate,
556: fnd_global.user_id,
557: p_aging_bucket_id,
558: p_aging_bucket_line_id,
559: p_amount
560: );

Line 577: SET last_updated_by = fnd_global.user_id,

573: p_error_msg OUT NOCOPY VARCHAR2,
574: p_resultout OUT NOCOPY VARCHAR2) IS
575: BEGIN
576: UPDATE AR_CMGT_CF_AGING_DTLS
577: SET last_updated_by = fnd_global.user_id,
578: last_update_date = sysdate,
579: last_update_login = fnd_global.login_id,
580: amount = p_amount
581: WHERE case_folder_id = p_case_folder_id

Line 579: last_update_login = fnd_global.login_id,

575: BEGIN
576: UPDATE AR_CMGT_CF_AGING_DTLS
577: SET last_updated_by = fnd_global.user_id,
578: last_update_date = sysdate,
579: last_update_login = fnd_global.login_id,
580: amount = p_amount
581: WHERE case_folder_id = p_case_folder_id
582: AND aging_bucket_id = p_aging_bucket_id
583: AND aging_bucket_line_id = p_aging_bucket_line_id;

Line 637: fnd_global.user_id,

633: EXCHANGE_RATE_TYPE,
634: REVIEW_CYCLE)
635: ( SELECT AR_CMGT_CASE_FOLDERS_s.NEXTVAL,
636: ar_cmgt_case_folder_number_s.nextval,
637: fnd_global.user_id,
638: SYSDATE,
639: fnd_global.user_id,
640: SYSDATE,
641: fnd_global.login_id,

Line 639: fnd_global.user_id,

635: ( SELECT AR_CMGT_CASE_FOLDERS_s.NEXTVAL,
636: ar_cmgt_case_folder_number_s.nextval,
637: fnd_global.user_id,
638: SYSDATE,
639: fnd_global.user_id,
640: SYSDATE,
641: fnd_global.login_id,
642: l_credit_request_id,
643: CHECK_LIST_ID,

Line 641: fnd_global.login_id,

637: fnd_global.user_id,
638: SYSDATE,
639: fnd_global.user_id,
640: SYSDATE,
641: fnd_global.login_id,
642: l_credit_request_id,
643: CHECK_LIST_ID,
644: 'CREATED',
645: CUST_ACCOUNT_ID,

Line 773: fnd_global.user_id,

769: PARENT_DATA_POINT_ID,
770: PARENT_CF_DETAIL_ID)
771: (select l_case_folders_id,
772: DATA_POINT_ID,
773: fnd_global.user_id,
774: SYSDATE,
775: fnd_global.login_id,
776: SYSDATE,
777: fnd_global.user_id,

Line 775: fnd_global.login_id,

771: (select l_case_folders_id,
772: DATA_POINT_ID,
773: fnd_global.user_id,
774: SYSDATE,
775: fnd_global.login_id,
776: SYSDATE,
777: fnd_global.user_id,
778: DATA_POINT_VALUE,
779: INCLUDED_IN_CHECKLIST,

Line 777: fnd_global.user_id,

773: fnd_global.user_id,
774: SYSDATE,
775: fnd_global.login_id,
776: SYSDATE,
777: fnd_global.user_id,
778: DATA_POINT_VALUE,
779: INCLUDED_IN_CHECKLIST,
780: SCORE,
781: l_seq_num,

Line 895: fnd_global.user_id,

891: AGING_BUCKET_LINE_ID,
892: AMOUNT,
893: COUNT)
894: (SELECT l_case_folders_id,
895: fnd_global.user_id,
896: SYSDATE,
897: fnd_global.login_id,
898: SYSDATE,
899: fnd_global.user_id,

Line 897: fnd_global.login_id,

893: COUNT)
894: (SELECT l_case_folders_id,
895: fnd_global.user_id,
896: SYSDATE,
897: fnd_global.login_id,
898: SYSDATE,
899: fnd_global.user_id,
900: AGING_BUCKET_ID,
901: AGING_BUCKET_LINE_ID,

Line 899: fnd_global.user_id,

895: fnd_global.user_id,
896: SYSDATE,
897: fnd_global.login_id,
898: SYSDATE,
899: fnd_global.user_id,
900: AGING_BUCKET_ID,
901: AGING_BUCKET_LINE_ID,
902: AMOUNT,
903: COUNT

Line 969: fnd_global.user_id,

965: SOURCE_KEY,
966: SOURCE_KEY_TYPE,
967: SOURCE_KEY_COLUMN_NAME,
968: SOURCE_KEY_COLUMN_TYPE_NAME,
969: fnd_global.user_id,
970: sysdate,
971: fnd_global.login_id,
972: sysdate,
973: fnd_global.user_id

Line 971: fnd_global.login_id,

967: SOURCE_KEY_COLUMN_NAME,
968: SOURCE_KEY_COLUMN_TYPE_NAME,
969: fnd_global.user_id,
970: sysdate,
971: fnd_global.login_id,
972: sysdate,
973: fnd_global.user_id
974: FROM AR_CMGT_CF_DNB_DTLS
975: WHERE CASE_FOLDER_ID=p_parnt_case_folder_id);

Line 973: fnd_global.user_id

969: fnd_global.user_id,
970: sysdate,
971: fnd_global.login_id,
972: sysdate,
973: fnd_global.user_id
974: FROM AR_CMGT_CF_DNB_DTLS
975: WHERE CASE_FOLDER_ID=p_parnt_case_folder_id);
976: EXCEPTION
977: WHEN OTHERS

Line 1067: fnd_global.user_id,

1063: SITE_USE_ID)
1064: (SELECT AR_CMGT_FINANCIAL_DATA_S.nextval,
1065: l_credit_request_id,
1066: SYSDATE,
1067: fnd_global.user_id,
1068: SYSDATE,
1069: fnd_global.user_id,
1070: fnd_global.login_id,
1071: REPORTING_CURRENCY,

Line 1069: fnd_global.user_id,

1065: l_credit_request_id,
1066: SYSDATE,
1067: fnd_global.user_id,
1068: SYSDATE,
1069: fnd_global.user_id,
1070: fnd_global.login_id,
1071: REPORTING_CURRENCY,
1072: MONETARY_UNIT,
1073: CURR_FIN_ST_DATE,

Line 1070: fnd_global.login_id,

1066: SYSDATE,
1067: fnd_global.user_id,
1068: SYSDATE,
1069: fnd_global.user_id,
1070: fnd_global.login_id,
1071: REPORTING_CURRENCY,
1072: MONETARY_UNIT,
1073: CURR_FIN_ST_DATE,
1074: REPORTING_PERIOD,

Line 1192: fnd_global.user_id,

1188: NOTES)
1189: (SELECT AR_CMGT_TRADE_REF_DATA_S.NEXTVAL,
1190: l_credit_request_id,
1191: SYSDATE,
1192: fnd_global.user_id,
1193: SYSDATE,
1194: fnd_global.user_id,
1195: fnd_global.login_id,
1196: COUNTRY,

Line 1194: fnd_global.user_id,

1190: l_credit_request_id,
1191: SYSDATE,
1192: fnd_global.user_id,
1193: SYSDATE,
1194: fnd_global.user_id,
1195: fnd_global.login_id,
1196: COUNTRY,
1197: TAX_NUMBER,
1198: REFERENCE_NAME,

Line 1195: fnd_global.login_id,

1191: SYSDATE,
1192: fnd_global.user_id,
1193: SYSDATE,
1194: fnd_global.user_id,
1195: fnd_global.login_id,
1196: COUNTRY,
1197: TAX_NUMBER,
1198: REFERENCE_NAME,
1199: CONTACT_NAME,

Line 1314: fnd_global.user_id,

1310: NOTES)
1311: (SELECT l_next_val,
1312: l_credit_request_id,
1313: SYSDATE,
1314: fnd_global.user_id,
1315: SYSDATE,
1316: fnd_global.user_id,
1317: fnd_global.login_id,
1318: BANK_NAME,

Line 1316: fnd_global.user_id,

1312: l_credit_request_id,
1313: SYSDATE,
1314: fnd_global.user_id,
1315: SYSDATE,
1316: fnd_global.user_id,
1317: fnd_global.login_id,
1318: BANK_NAME,
1319: ADDRESS,
1320: CITY,

Line 1317: fnd_global.login_id,

1313: SYSDATE,
1314: fnd_global.user_id,
1315: SYSDATE,
1316: fnd_global.user_id,
1317: fnd_global.login_id,
1318: BANK_NAME,
1319: ADDRESS,
1320: CITY,
1321: STATE,

Line 1360: fnd_global.user_id,

1356: ( SELECT AR_CMGT_BANK_REF_ACCTS_S.NEXTVAL,
1357: l_next_val,
1358: l_credit_request_id,
1359: SYSDATE,
1360: fnd_global.user_id,
1361: SYSDATE,
1362: fnd_global.user_id,
1363: fnd_global.login_id,
1364: ACCOUNT_NUMBER,

Line 1362: fnd_global.user_id,

1358: l_credit_request_id,
1359: SYSDATE,
1360: fnd_global.user_id,
1361: SYSDATE,
1362: fnd_global.user_id,
1363: fnd_global.login_id,
1364: ACCOUNT_NUMBER,
1365: ACCOUNT_TYPE,
1366: DATE_OPENED,

Line 1363: fnd_global.login_id,

1359: SYSDATE,
1360: fnd_global.user_id,
1361: SYSDATE,
1362: fnd_global.user_id,
1363: fnd_global.login_id,
1364: ACCOUNT_NUMBER,
1365: ACCOUNT_TYPE,
1366: DATE_OPENED,
1367: CURRENCY,

Line 1448: fnd_global.user_id,

1444: NOTES)
1445: ( SELECT AR_CMGT_COLLATERAL_DATA_S.NEXTVAL,
1446: l_credit_request_id,
1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,
1450: fnd_global.user_id,
1451: fnd_global.login_id,
1452: COLLATERAL_DESCRIPTION,

Line 1450: fnd_global.user_id,

1446: l_credit_request_id,
1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,
1450: fnd_global.user_id,
1451: fnd_global.login_id,
1452: COLLATERAL_DESCRIPTION,
1453: COLLATERAL_CATEGORY,
1454: COLLATERAL_VALUE,

Line 1451: fnd_global.login_id,

1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,
1450: fnd_global.user_id,
1451: fnd_global.login_id,
1452: COLLATERAL_DESCRIPTION,
1453: COLLATERAL_CATEGORY,
1454: COLLATERAL_VALUE,
1455: COLLATERAL_CURRENCY,

Line 1545: fnd_global.user_id,

1541: CASE_FOLDER_ID)
1542: ( SELECT AR_CMGT_OTHER_DATA_S.NEXTVAL,
1543: l_credit_request_id,
1544: SYSDATE,
1545: fnd_global.user_id,
1546: SYSDATE,
1547: fnd_global.user_id,
1548: fnd_global.login_id,
1549: COUNTRY,

Line 1547: fnd_global.user_id,

1543: l_credit_request_id,
1544: SYSDATE,
1545: fnd_global.user_id,
1546: SYSDATE,
1547: fnd_global.user_id,
1548: fnd_global.login_id,
1549: COUNTRY,
1550: KEY_EXECUTIVE,
1551: VENTURE_CAPITAL_NAME,

Line 1548: fnd_global.login_id,

1544: SYSDATE,
1545: fnd_global.user_id,
1546: SYSDATE,
1547: fnd_global.user_id,
1548: fnd_global.login_id,
1549: COUNTRY,
1550: KEY_EXECUTIVE,
1551: VENTURE_CAPITAL_NAME,
1552: VC_CONTACT_NAME,

Line 1636: fnd_global.user_id,

1632: CREDIT_TYPE,
1633: RECOMMENDATION_NAME,
1634: APPLICATION_ID)
1635: (SELECT AR_CMGT_CF_RECOMMENDS_S.NEXTVAL,
1636: fnd_global.user_id,
1637: SYSDATE,
1638: fnd_global.login_id,
1639: SYSDATE,
1640: fnd_global.user_id,

Line 1638: fnd_global.login_id,

1634: APPLICATION_ID)
1635: (SELECT AR_CMGT_CF_RECOMMENDS_S.NEXTVAL,
1636: fnd_global.user_id,
1637: SYSDATE,
1638: fnd_global.login_id,
1639: SYSDATE,
1640: fnd_global.user_id,
1641: l_case_folders_id,
1642: l_credit_request_id,

Line 1640: fnd_global.user_id,

1636: fnd_global.user_id,
1637: SYSDATE,
1638: fnd_global.login_id,
1639: SYSDATE,
1640: fnd_global.user_id,
1641: l_case_folders_id,
1642: l_credit_request_id,
1643: CREDIT_REVIEW_DATE,
1644: CREDIT_RECOMMENDATION,

Line 1714: fnd_global.user_id,

1710: NOTES,
1711: DATE_OPENED)
1712: (SELECT AR_CMGT_CF_ANL_NOTES_S.NEXTVAL,
1713: l_case_folders_id,
1714: fnd_global.user_id,
1715: sysdate,
1716: fnd_global.login_id,
1717: sysdate,
1718: fnd_global.user_id,

Line 1716: fnd_global.login_id,

1712: (SELECT AR_CMGT_CF_ANL_NOTES_S.NEXTVAL,
1713: l_case_folders_id,
1714: fnd_global.user_id,
1715: sysdate,
1716: fnd_global.login_id,
1717: sysdate,
1718: fnd_global.user_id,
1719: TOPIC,
1720: DISPLAY,

Line 1718: fnd_global.user_id,

1714: fnd_global.user_id,
1715: sysdate,
1716: fnd_global.login_id,
1717: sysdate,
1718: fnd_global.user_id,
1719: TOPIC,
1720: DISPLAY,
1721: IMPORTANCE,
1722: NOTES,