APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on RG_REPORT_CONTENT_SETS

Line 127: rep_run_type rg_report_content_sets.report_run_type%TYPE;

123:
124: report_rec RepTyp;
125:
126: req_id NUMBER;
127: rep_run_type rg_report_content_sets.report_run_type%TYPE;
128: L_COMPANY_NAME VARCHAR2(100);--show the company name
129: L_LEGAL_ENTITY NUMBER(15);
130: BEGIN
131: --get legal_entity id

Line 162: FROM rg_report_content_sets

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

Line 857: FROM rg_report_content_sets cs, rg_reports rp

853: --CONTENT_SET_ID
854: BEGIN
855: SELECT cs.content_set_id
856: INTO ln_content_set_id
857: FROM rg_report_content_sets cs, rg_reports rp
858: WHERE rp.report_id = pn_balance_sheet_id
859: AND rp.content_set_id = cs.content_set_id(+);
860: EXCEPTION
861: WHEN NO_DATA_FOUND THEN

Line 990: FROM rg_report_content_sets cs, rg_reports rp

986: --CONTENT_SET_ID
987: BEGIN
988: SELECT cs.content_set_id
989: INTO ln_content_set_id
990: FROM rg_report_content_sets cs, rg_reports rp
991: WHERE rp.report_id = pn_profit_statement_id
992: AND rp.content_set_id = cs.content_set_id(+);
993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN

Line 1124: FROM rg_report_content_sets cs, rg_reports rp

1120: --CONTENT_SET_ID
1121: BEGIN
1122: SELECT cs.content_set_id
1123: INTO ln_content_set_id
1124: FROM rg_report_content_sets cs, rg_reports rp
1125: WHERE rp.report_id = pn_owners_equity_id
1126: AND rp.content_set_id = cs.content_set_id(+);
1127: EXCEPTION
1128: WHEN NO_DATA_FOUND THEN

Line 1259: FROM rg_report_content_sets cs, rg_reports rp

1255: --CONTENT_SET_ID
1256: BEGIN
1257: SELECT cs.content_set_id
1258: INTO ln_content_set_id
1259: FROM rg_report_content_sets cs, rg_reports rp
1260: WHERE rp.report_id = pn_csf_report_id
1261: AND rp.content_set_id = cs.content_set_id(+);
1262: EXCEPTION
1263: WHEN NO_DATA_FOUND THEN

Line 1855: FROM rg_report_content_sets cs, rg_reports rp

1851: --CONTENT_SET_ID
1852: BEGIN
1853: SELECT cs.content_set_id
1854: INTO ln_content_set_id
1855: FROM rg_report_content_sets cs, rg_reports rp
1856: WHERE rp.report_id = pn_balance_sheet_id
1857: AND rp.content_set_id = cs.content_set_id(+);
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND THEN

Line 1988: FROM rg_report_content_sets cs, rg_reports rp

1984: --CONTENT_SET_ID
1985: BEGIN
1986: SELECT cs.content_set_id
1987: INTO ln_content_set_id
1988: FROM rg_report_content_sets cs, rg_reports rp
1989: WHERE rp.report_id = pn_profit_statement_id
1990: AND rp.content_set_id = cs.content_set_id(+);
1991: EXCEPTION
1992: WHEN NO_DATA_FOUND THEN

Line 2122: FROM rg_report_content_sets cs, rg_reports rp

2118: --CONTENT_SET_ID
2119: BEGIN
2120: SELECT cs.content_set_id
2121: INTO ln_content_set_id
2122: FROM rg_report_content_sets cs, rg_reports rp
2123: WHERE rp.report_id = pn_owners_equity_id
2124: AND rp.content_set_id = cs.content_set_id(+);
2125: EXCEPTION
2126: WHEN NO_DATA_FOUND THEN

Line 2257: FROM rg_report_content_sets cs, rg_reports rp

2253: --CONTENT_SET_ID
2254: BEGIN
2255: SELECT cs.content_set_id
2256: INTO ln_content_set_id
2257: FROM rg_report_content_sets cs, rg_reports rp
2258: WHERE rp.report_id = pn_csf_report_id
2259: AND rp.content_set_id = cs.content_set_id(+);
2260: EXCEPTION
2261: WHEN NO_DATA_FOUND THEN