1: package body ad_morg as
2: /* $Header: admorgb.pls 120.25.12020000.6 2013/02/27 09:13:06 rahulshr ship $ */
3:
4: --
5: -- Private Cursors
503: exception
504: when table_not_found then
505: null;
506: when others then
507: raise_application_error(-20000, sqlerrm || ':ad_morg.replicate_table_data(' ||
508: X_table_name || ',' || X_target_org_id || '):' || statement);
509:
510: end replicate_table_data;
511:
636: when table_not_found then
637: null;
638: when others then
639: raise_application_error(-20000, sqlerrm ||
640: ':ad_morg.replicate_table_data_bulk(' ||
641: X_table_name || ',' || X_source_org_id || '):' || statement);
642:
643: end replicate_table_data_bulk;
644:
1798: l_num_org := 1;
1799: l_multi_org := FALSE;
1800: end if;
1801:
1802: ad_morg.load_table_list('N');
1803:
1804: if (X_table is null) then
1805:
1806: i := 1;
1805:
1806: i := 1;
1807:
1808: loop
1809: if (ad_morg.table_list(i) is not null
1810: and
1811: ad_morg.seed_data(i) = 'Y'
1812: and
1813: ad_morg.appl_list(i) = nvl(upper(X_appl_short_name),
1807:
1808: loop
1809: if (ad_morg.table_list(i) is not null
1810: and
1811: ad_morg.seed_data(i) = 'Y'
1812: and
1813: ad_morg.appl_list(i) = nvl(upper(X_appl_short_name),
1814: ad_morg.appl_list(i))
1815: )
1809: if (ad_morg.table_list(i) is not null
1810: and
1811: ad_morg.seed_data(i) = 'Y'
1812: and
1813: ad_morg.appl_list(i) = nvl(upper(X_appl_short_name),
1814: ad_morg.appl_list(i))
1815: )
1816: then
1817:
1810: and
1811: ad_morg.seed_data(i) = 'Y'
1812: and
1813: ad_morg.appl_list(i) = nvl(upper(X_appl_short_name),
1814: ad_morg.appl_list(i))
1815: )
1816: then
1817:
1818: verify_table_seed_data(ad_morg.table_list(i), l_num_org,
1814: ad_morg.appl_list(i))
1815: )
1816: then
1817:
1818: verify_table_seed_data(ad_morg.table_list(i), l_num_org,
1819: X_debug_level);
1820:
1821: end if;
1822:
1819: X_debug_level);
1820:
1821: end if;
1822:
1823: if (ad_morg.table_list(i) is null) then
1824: exit;
1825: end if;
1826:
1827: i := i + 1;
1876: g_prev_product := '$#$#';
1877: g_oracle_schema := '$#$#';
1878: g_load_table_stats := 'Y';
1879:
1880: end ad_morg;