APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on RG_REPORT_AXIS_SETS

Line 810: FROM rg_report_axis_sets rs, rg_reports rp

806: --(1) Submit Balance Sheet Report and get this program request ID.
807: --ROW_SET_ID
808: SELECT rs.axis_set_id
809: INTO ln_row_set_id
810: FROM rg_report_axis_sets rs, rg_reports rp
811: WHERE rp.report_id = pn_balance_sheet_id
812: AND rp.row_set_id = rs.axis_set_id;
813: --COLUMN_SET_ID
814: SELECT cs.axis_set_id

Line 816: FROM rg_report_axis_sets cs, rg_reports rp

812: AND rp.row_set_id = rs.axis_set_id;
813: --COLUMN_SET_ID
814: SELECT cs.axis_set_id
815: INTO ln_clolumn_set_id
816: FROM rg_report_axis_sets cs, rg_reports rp
817: WHERE rp.report_id = pn_balance_sheet_id
818: AND rp.column_set_id = cs.axis_set_id;
819: --Unit of Measure ID/currency
820: BEGIN

Line 943: FROM rg_report_axis_sets rs, rg_reports rp

939: --(2) Submit Profit Statement Report and get this program request ID.
940: --ROW_SET_ID
941: SELECT rs.axis_set_id
942: INTO ln_row_set_id
943: FROM rg_report_axis_sets rs, rg_reports rp
944: WHERE rp.report_id = pn_profit_statement_id
945: AND rp.row_set_id = rs.axis_set_id;
946: --COLUMN_SET_ID
947: SELECT cs.axis_set_id

Line 949: FROM rg_report_axis_sets cs, rg_reports rp

945: AND rp.row_set_id = rs.axis_set_id;
946: --COLUMN_SET_ID
947: SELECT cs.axis_set_id
948: INTO ln_clolumn_set_id
949: FROM rg_report_axis_sets cs, rg_reports rp
950: WHERE rp.report_id = pn_profit_statement_id
951: AND rp.column_set_id = cs.axis_set_id;
952: --Unit of Measure ID/currency
953: BEGIN

Line 1077: FROM rg_report_axis_sets rs, rg_reports rp

1073: --(3) Submit Profit Statement Report and get this program request ID.
1074: --ROW_SET_ID
1075: SELECT rs.axis_set_id
1076: INTO ln_row_set_id
1077: FROM rg_report_axis_sets rs, rg_reports rp
1078: WHERE rp.report_id = pn_owners_equity_id
1079: AND rp.row_set_id = rs.axis_set_id;
1080: --COLUMN_SET_ID
1081: SELECT cs.axis_set_id

Line 1083: FROM rg_report_axis_sets cs, rg_reports rp

1079: AND rp.row_set_id = rs.axis_set_id;
1080: --COLUMN_SET_ID
1081: SELECT cs.axis_set_id
1082: INTO ln_clolumn_set_id
1083: FROM rg_report_axis_sets cs, rg_reports rp
1084: WHERE rp.report_id = pn_owners_equity_id
1085: AND rp.column_set_id = cs.axis_set_id;
1086: --Unit of Measure ID/currency
1087: BEGIN

Line 1212: FROM rg_report_axis_sets rs, rg_reports rp

1208: -- then get the Combination Program request ID.
1209: --ROW_SET_ID
1210: SELECT rs.axis_set_id
1211: INTO ln_row_set_id
1212: FROM rg_report_axis_sets rs, rg_reports rp
1213: WHERE rp.report_id = pn_csf_report_id
1214: AND rp.row_set_id = rs.axis_set_id;
1215: --COLUMN_SET_ID
1216: SELECT cs.axis_set_id

Line 1218: FROM rg_report_axis_sets cs, rg_reports rp

1214: AND rp.row_set_id = rs.axis_set_id;
1215: --COLUMN_SET_ID
1216: SELECT cs.axis_set_id
1217: INTO ln_clolumn_set_id
1218: FROM rg_report_axis_sets cs, rg_reports rp
1219: WHERE rp.report_id = pn_csf_report_id
1220: AND rp.column_set_id = cs.axis_set_id;
1221: --Unit of Measure ID/currency
1222: BEGIN

Line 1808: FROM rg_report_axis_sets rs, rg_reports rp

1804: --(1) Submit Balance Sheet Report and get this program request ID.
1805: --ROW_SET_ID
1806: SELECT rs.axis_set_id
1807: INTO ln_row_set_id
1808: FROM rg_report_axis_sets rs, rg_reports rp
1809: WHERE rp.report_id = pn_balance_sheet_id
1810: AND rp.row_set_id = rs.axis_set_id;
1811: --COLUMN_SET_ID
1812: SELECT cs.axis_set_id

Line 1814: FROM rg_report_axis_sets cs, rg_reports rp

1810: AND rp.row_set_id = rs.axis_set_id;
1811: --COLUMN_SET_ID
1812: SELECT cs.axis_set_id
1813: INTO ln_clolumn_set_id
1814: FROM rg_report_axis_sets cs, rg_reports rp
1815: WHERE rp.report_id = pn_balance_sheet_id
1816: AND rp.column_set_id = cs.axis_set_id;
1817: --Unit of Measure ID/currency
1818: BEGIN

Line 1941: FROM rg_report_axis_sets rs, rg_reports rp

1937: --(2) Submit Profit Statement Report and get this program request ID.
1938: --ROW_SET_ID
1939: SELECT rs.axis_set_id
1940: INTO ln_row_set_id
1941: FROM rg_report_axis_sets rs, rg_reports rp
1942: WHERE rp.report_id = pn_profit_statement_id
1943: AND rp.row_set_id = rs.axis_set_id;
1944: --COLUMN_SET_ID
1945: SELECT cs.axis_set_id

Line 1947: FROM rg_report_axis_sets cs, rg_reports rp

1943: AND rp.row_set_id = rs.axis_set_id;
1944: --COLUMN_SET_ID
1945: SELECT cs.axis_set_id
1946: INTO ln_clolumn_set_id
1947: FROM rg_report_axis_sets cs, rg_reports rp
1948: WHERE rp.report_id = pn_profit_statement_id
1949: AND rp.column_set_id = cs.axis_set_id;
1950: --Unit of Measure ID/currency
1951: BEGIN

Line 2075: FROM rg_report_axis_sets rs, rg_reports rp

2071: --(3) Submit Profit Statement Report and get this program request ID.
2072: --ROW_SET_ID
2073: SELECT rs.axis_set_id
2074: INTO ln_row_set_id
2075: FROM rg_report_axis_sets rs, rg_reports rp
2076: WHERE rp.report_id = pn_owners_equity_id
2077: AND rp.row_set_id = rs.axis_set_id;
2078: --COLUMN_SET_ID
2079: SELECT cs.axis_set_id

Line 2081: FROM rg_report_axis_sets cs, rg_reports rp

2077: AND rp.row_set_id = rs.axis_set_id;
2078: --COLUMN_SET_ID
2079: SELECT cs.axis_set_id
2080: INTO ln_clolumn_set_id
2081: FROM rg_report_axis_sets cs, rg_reports rp
2082: WHERE rp.report_id = pn_owners_equity_id
2083: AND rp.column_set_id = cs.axis_set_id;
2084: --Unit of Measure ID/currency
2085: BEGIN

Line 2210: FROM rg_report_axis_sets rs, rg_reports rp

2206: -- then get the Combination Program request ID.
2207: --ROW_SET_ID
2208: SELECT rs.axis_set_id
2209: INTO ln_row_set_id
2210: FROM rg_report_axis_sets rs, rg_reports rp
2211: WHERE rp.report_id = pn_csf_report_id
2212: AND rp.row_set_id = rs.axis_set_id;
2213: --COLUMN_SET_ID
2214: SELECT cs.axis_set_id

Line 2216: FROM rg_report_axis_sets cs, rg_reports rp

2212: AND rp.row_set_id = rs.axis_set_id;
2213: --COLUMN_SET_ID
2214: SELECT cs.axis_set_id
2215: INTO ln_clolumn_set_id
2216: FROM rg_report_axis_sets cs, rg_reports rp
2217: WHERE rp.report_id = pn_csf_report_id
2218: AND rp.column_set_id = cs.axis_set_id;
2219: --Unit of Measure ID/currency
2220: BEGIN