58: 'Beginning of procedure');
59: END IF;
60:
61:
62: if (not fa_xla_extract_util_pkg.G_secondary_special) then
63:
64:
65:
66: insert into fa_xla_ext_headers_b_gt (
129:
130:
131: end if;
132:
133: if (fa_xla_extract_util_pkg.G_secondary_special) then
134:
135:
136:
137: insert into fa_xla_ext_headers_b_gt (
244: 'Beginning of procedure');
245: END IF;
246:
247:
248: if (not fa_xla_extract_util_pkg.G_secondary_special) then
249:
250:
251:
252: insert into fa_xla_ext_headers_b_gt (
294:
295:
296: end if;
297:
298: if (fa_xla_extract_util_pkg.G_secondary_special) then
299:
300:
301:
302: insert into fa_xla_ext_headers_b_gt (
388: G_MODULE_NAME||l_procedure_name||'.begin',
389: 'Beginning of procedure');
390: END IF;
391:
392: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
393: l_secondary := 1;
394: END IF;
395:
396:
495: END IF;
496:
497:
498:
499: if (fa_xla_extract_util_pkg.G_group_enabled) then
500:
501:
502:
503: insert into fa_xla_ext_lines_stg_gt (
643: G_MODULE_NAME||l_procedure_name||'.begin',
644: 'Beginning of procedure');
645: END IF;
646:
647: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
648: l_secondary := 1;
649: END IF;
650:
651:
752: END IF;
753:
754:
755:
756: if (fa_xla_extract_util_pkg.G_group_enabled) then
757:
758:
759:
760: insert into fa_xla_ext_lines_stg_gt (
966: END IF;
967:
968:
969:
970: if (fa_xla_extract_util_pkg.G_group_enabled) then
971:
972:
973:
974: insert into fa_xla_ext_lines_stg_gt (
1116: G_MODULE_NAME||l_procedure_name||'.begin',
1117: 'Beginning of procedure');
1118: END IF;
1119:
1120: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
1121: l_secondary := 1;
1122: END IF;
1123:
1124:
1121: l_secondary := 1;
1122: END IF;
1123:
1124:
1125: if (not fa_xla_extract_util_pkg.G_secondary_special) then
1126:
1127:
1128:
1129: insert into fa_xla_ext_lines_b_gt (
1341:
1342:
1343: end if;
1344:
1345: if (fa_xla_extract_util_pkg.G_alc_enabled or
1346: fa_xla_extract_util_pkg.G_secondary_special) then
1347:
1348:
1349:
1342:
1343: end if;
1344:
1345: if (fa_xla_extract_util_pkg.G_alc_enabled or
1346: fa_xla_extract_util_pkg.G_secondary_special) then
1347:
1348:
1349:
1350: insert into fa_xla_ext_lines_b_gt (
1611: G_MODULE_NAME||l_procedure_name||'.begin',
1612: 'Beginning of procedure');
1613: END IF;
1614:
1615: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
1616: l_secondary := 1;
1617: END IF;
1618:
1619:
1616: l_secondary := 1;
1617: END IF;
1618:
1619:
1620: if (not fa_xla_extract_util_pkg.G_secondary_special) then
1621:
1622:
1623:
1624: insert into fa_xla_ext_lines_b_gt (
1800:
1801:
1802: end if;
1803:
1804: if (fa_xla_extract_util_pkg.G_alc_enabled or
1805: fa_xla_extract_util_pkg.G_secondary_special) then
1806:
1807:
1808:
1801:
1802: end if;
1803:
1804: if (fa_xla_extract_util_pkg.G_alc_enabled or
1805: fa_xla_extract_util_pkg.G_secondary_special) then
1806:
1807:
1808:
1809: insert into fa_xla_ext_lines_b_gt (
2034: G_MODULE_NAME||l_procedure_name||'.begin',
2035: 'Beginning of procedure');
2036: END IF;
2037:
2038: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
2039: l_secondary := 1;
2040: END IF;
2041:
2042:
2039: l_secondary := 1;
2040: END IF;
2041:
2042:
2043: if (not fa_xla_extract_util_pkg.G_secondary_special) then
2044:
2045:
2046:
2047: insert into fa_xla_ext_lines_b_gt (
2213:
2214:
2215: end if;
2216:
2217: if (fa_xla_extract_util_pkg.G_alc_enabled or
2218: fa_xla_extract_util_pkg.G_secondary_special) then
2219:
2220:
2221:
2214:
2215: end if;
2216:
2217: if (fa_xla_extract_util_pkg.G_alc_enabled or
2218: fa_xla_extract_util_pkg.G_secondary_special) then
2219:
2220:
2221:
2222: insert into fa_xla_ext_lines_b_gt (
2436: G_MODULE_NAME||l_procedure_name||'.begin',
2437: 'Beginning of procedure');
2438: END IF;
2439:
2440: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
2441: l_secondary := 1;
2442: END IF;
2443:
2444:
2441: l_secondary := 1;
2442: END IF;
2443:
2444:
2445: if (not fa_xla_extract_util_pkg.G_secondary_special) then
2446:
2447:
2448:
2449: insert into fa_xla_ext_lines_b_gt (
2593:
2594:
2595: end if;
2596:
2597: if (fa_xla_extract_util_pkg.G_alc_enabled or
2598: fa_xla_extract_util_pkg.G_secondary_special) then
2599:
2600:
2601:
2594:
2595: end if;
2596:
2597: if (fa_xla_extract_util_pkg.G_alc_enabled or
2598: fa_xla_extract_util_pkg.G_secondary_special) then
2599:
2600:
2601:
2602: insert into fa_xla_ext_lines_b_gt (
2754:
2755:
2756: end if;
2757:
2758: if (not fa_xla_extract_util_pkg.G_secondary_special) then
2759:
2760:
2761:
2762: insert into fa_xla_ext_lines_b_gt (
2900:
2901:
2902: end if;
2903:
2904: if (fa_xla_extract_util_pkg.G_alc_enabled or
2905: fa_xla_extract_util_pkg.G_secondary_special) then
2906:
2907:
2908:
2901:
2902: end if;
2903:
2904: if (fa_xla_extract_util_pkg.G_alc_enabled or
2905: fa_xla_extract_util_pkg.G_secondary_special) then
2906:
2907:
2908:
2909: insert into fa_xla_ext_lines_b_gt (
3095: G_MODULE_NAME||l_procedure_name||'.begin',
3096: 'Beginning of procedure');
3097: END IF;
3098:
3099: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
3100: l_secondary := 1;
3101: END IF;
3102:
3103:
3100: l_secondary := 1;
3101: END IF;
3102:
3103:
3104: if (not fa_xla_extract_util_pkg.G_secondary_special) then
3105:
3106:
3107:
3108: insert into fa_xla_ext_lines_b_gt (
3258:
3259:
3260: end if;
3261:
3262: if (fa_xla_extract_util_pkg.G_alc_enabled or
3263: fa_xla_extract_util_pkg.G_secondary_special) then
3264:
3265:
3266:
3259:
3260: end if;
3261:
3262: if (fa_xla_extract_util_pkg.G_alc_enabled or
3263: fa_xla_extract_util_pkg.G_secondary_special) then
3264:
3265:
3266:
3267: insert into fa_xla_ext_lines_b_gt (
3466: G_MODULE_NAME||l_procedure_name||'.begin',
3467: 'Beginning of procedure');
3468: END IF;
3469:
3470: IF (fa_xla_extract_util_pkg.G_secondary_special) THEN
3471: l_secondary := 1;
3472: END IF;
3473:
3474:
3471: l_secondary := 1;
3472: END IF;
3473:
3474:
3475: if (not fa_xla_extract_util_pkg.G_secondary_special) then
3476:
3477:
3478:
3479: insert into fa_xla_ext_lines_b_gt (
3629:
3630:
3631: end if;
3632:
3633: if (fa_xla_extract_util_pkg.G_alc_enabled or
3634: fa_xla_extract_util_pkg.G_secondary_special) then
3635:
3636:
3637:
3630:
3631: end if;
3632:
3633: if (fa_xla_extract_util_pkg.G_alc_enabled or
3634: fa_xla_extract_util_pkg.G_secondary_special) then
3635:
3636:
3637:
3638: insert into fa_xla_ext_lines_b_gt (
4360:
4361:
4362:
4363: Lock_Data;
4364: if (fa_xla_extract_util_pkg.G_trx_exists) then
4365: load_header_data_stg1;
4366: Load_line_data_stg1;
4367: end if;
4368:
4365: load_header_data_stg1;
4366: Load_line_data_stg1;
4367: end if;
4368:
4369: if (fa_xla_extract_util_pkg.G_inter_trx_exists) then
4370: load_header_data_stg2;
4371: Load_line_data_stg2;
4372: end if;
4373:
4370: load_header_data_stg2;
4371: Load_line_data_stg2;
4372: end if;
4373:
4374: if (fa_xla_extract_util_pkg.G_fin_trx_exists) then
4375: Load_line_data_fin1;
4376: end if;
4377:
4378: if (fa_xla_extract_util_pkg.G_inter_trx_exists) then
4374: if (fa_xla_extract_util_pkg.G_fin_trx_exists) then
4375: Load_line_data_fin1;
4376: end if;
4377:
4378: if (fa_xla_extract_util_pkg.G_inter_trx_exists) then
4379: Load_line_data_fin2;
4380: end if;
4381:
4382: if (fa_xla_extract_util_pkg.G_xfr_trx_exists) then
4378: if (fa_xla_extract_util_pkg.G_inter_trx_exists) then
4379: Load_line_data_fin2;
4380: end if;
4381:
4382: if (fa_xla_extract_util_pkg.G_xfr_trx_exists) then
4383: Load_line_data_xfr;
4384: end if;
4385:
4386: if (fa_xla_extract_util_pkg.G_dist_trx_exists) then
4382: if (fa_xla_extract_util_pkg.G_xfr_trx_exists) then
4383: Load_line_data_xfr;
4384: end if;
4385:
4386: if (fa_xla_extract_util_pkg.G_dist_trx_exists) then
4387: Load_line_data_dist;
4388: end if;
4389:
4390: if (fa_xla_extract_util_pkg.G_ret_trx_exists) then
4386: if (fa_xla_extract_util_pkg.G_dist_trx_exists) then
4387: Load_line_data_dist;
4388: end if;
4389:
4390: if (fa_xla_extract_util_pkg.G_ret_trx_exists) then
4391: Load_line_data_ret;
4392: end if;
4393:
4394: if (fa_xla_extract_util_pkg.G_res_trx_exists) then
4390: if (fa_xla_extract_util_pkg.G_ret_trx_exists) then
4391: Load_line_data_ret;
4392: end if;
4393:
4394: if (fa_xla_extract_util_pkg.G_res_trx_exists) then
4395: Load_line_data_res;
4396: end if;
4397:
4398: Load_mls_data;