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.ARCM_EXTRACT_XML_CF dependencies on AR_CMGT_CREDIT_REQUESTS

Line 115: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;

111: l_key VARCHAR2(240);
112: l_event_name VARCHAR2(240) := 'oracle.apps.ar.cmgt.CaseFolder.extract';
113: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
114: l_credit_request_id NUMBER;
115: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;

Line 116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;

112: l_event_name VARCHAR2(240) := 'oracle.apps.ar.cmgt.CaseFolder.extract';
113: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
114: l_credit_request_id NUMBER;
115: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;

Line 117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;

113: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
114: l_credit_request_id NUMBER;
115: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;

Line 118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;

114: l_credit_request_id NUMBER;
115: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
122: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;

Line 119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;

115: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
122: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
123: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;

Line 120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;

116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
122: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
123: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
124: l_cf_not_found EXCEPTION;

Line 121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;

117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
122: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
123: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
124: l_cf_not_found EXCEPTION;
125: CURSOR get_case_folder_info IS

Line 122: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;

118: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
122: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
123: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
124: l_cf_not_found EXCEPTION;
125: CURSOR get_case_folder_info IS
126: SELECT cr.credit_request_id,

Line 123: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;

119: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
120: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
121: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
122: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
123: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
124: l_cf_not_found EXCEPTION;
125: CURSOR get_case_folder_info IS
126: SELECT cr.credit_request_id,
127: cr.source_name, cr.source_column1,

Line 134: FROM ar_cmgt_credit_requests cr,

130: cr.source_resp_id,
131: cr.source_resp_appln_id,
132: cr.source_security_group_id,
133: cr.source_org_id
134: FROM ar_cmgt_credit_requests cr,
135: ar_cmgt_case_folders cf
136: WHERE case_folder_id = P_CASE_FOLDER_ID
137: AND cr.credit_request_id = cf.credit_request_id;
138: