APPS.JA_CN_FSG_XML_BANK_PKG dependencies on RG_REPORT_CONTENT_SETS

Line 128: rep_run_type rg_report_content_sets.report_run_type%TYPE;

124:
125: report_rec RepTyp;
126:
127: req_id NUMBER;
128: rep_run_type rg_report_content_sets.report_run_type%TYPE;
129: L_COMPANY_NAME VARCHAR2(100) :=X_BSV;
130: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
131: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
132: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;

Line 163: FROM rg_report_content_sets

159: --
160: IF (X_content_set_id IS NOT NULL) THEN
161: SELECT report_run_type
162: INTO rep_run_type
163: FROM rg_report_content_sets
164: WHERE content_set_id = X_content_set_id;
165: ELSE
166: rep_run_type := 'S';
167: END IF;

Line 1025: FROM rg_report_content_sets cs, rg_reports rp

1021: --CONTENT_SET_ID
1022: BEGIN
1023: SELECT cs.content_set_id
1024: INTO ln_content_set_id
1025: FROM rg_report_content_sets cs, rg_reports rp
1026: WHERE rp.report_id = pn_balance_sheet_id
1027: AND rp.content_set_id = cs.content_set_id(+);
1028: EXCEPTION
1029: WHEN NO_DATA_FOUND THEN

Line 1178: FROM rg_report_content_sets cs, rg_reports rp

1174: --CONTENT_SET_ID
1175: BEGIN
1176: SELECT cs.content_set_id
1177: INTO ln_content_set_id
1178: FROM rg_report_content_sets cs, rg_reports rp
1179: WHERE rp.report_id = pn_profit_statement_id
1180: AND rp.content_set_id = cs.content_set_id(+);
1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN

Line 1333: FROM rg_report_content_sets cs, rg_reports rp

1329: --CONTENT_SET_ID
1330: BEGIN
1331: SELECT cs.content_set_id
1332: INTO ln_content_set_id
1333: FROM rg_report_content_sets cs, rg_reports rp
1334: WHERE rp.report_id = pn_csf_report_id
1335: AND rp.content_set_id = cs.content_set_id(+);
1336: EXCEPTION
1337: WHEN NO_DATA_FOUND THEN

Line 1488: FROM rg_report_content_sets cs, rg_reports rp

1484: --CONTENT_SET_ID
1485: BEGIN
1486: SELECT cs.content_set_id
1487: INTO ln_content_set_id
1488: FROM rg_report_content_sets cs, rg_reports rp
1489: WHERE rp.report_id = pn_owners_equity_id
1490: AND rp.content_set_id = cs.content_set_id(+);
1491: EXCEPTION
1492: WHEN NO_DATA_FOUND THEN