APPS.CST_SLA_UPDATE_PKG dependencies on AD_PARALLEL_UPDATES_PKG

Line 1458: ad_parallel_updates_pkg.initialize_id_range(

1454: l_update_name := X_Argument6 || 'I' || X_Argument4 || '-' || X_Argument5;
1455:
1456: l_retstatus := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_table_owner);
1457:
1458: ad_parallel_updates_pkg.initialize_id_range(
1459: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1460: X_owner=>l_table_owner,
1461: X_table=>l_table_name,
1462: X_script=>l_update_name,

Line 1459: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,

1455:
1456: l_retstatus := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_table_owner);
1457:
1458: ad_parallel_updates_pkg.initialize_id_range(
1459: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1460: X_owner=>l_table_owner,
1461: X_table=>l_table_name,
1462: X_script=>l_update_name,
1463: X_ID_column=>l_id_column,

Line 1470: ad_parallel_updates_pkg.get_id_range(

1466: X_batch_size=>X_batch_size,
1467: X_debug_level=>0);
1468:
1469: l_stmt_num :=20;
1470: ad_parallel_updates_pkg.get_id_range(
1471: l_start_id,
1472: l_end_id,
1473: l_any_rows_to_process,
1474: X_batch_size,

Line 1518: ad_parallel_updates_pkg.processed_id_range(

1514: /*l_rows_processed := SQL%ROWCOUNT;*/
1515: l_rows_processed := l_end_id - l_start_id + 1;
1516:
1517: l_stmt_num :=40;
1518: ad_parallel_updates_pkg.processed_id_range(
1519: l_rows_processed,
1520: l_end_id);
1521:
1522: COMMIT;

Line 1525: ad_parallel_updates_pkg.get_id_range(

1521:
1522: COMMIT;
1523:
1524: l_stmt_num :=50;
1525: ad_parallel_updates_pkg.get_id_range(
1526: l_start_id,
1527: l_end_id,
1528: l_any_rows_to_process,
1529: X_batch_size,

Line 1685: ad_parallel_updates_pkg.initialize_id_range(

1681: l_update_name := X_Argument6 || 'W' || X_Argument4 || '-' || X_Argument5;
1682:
1683: l_retstatus := FND_INSTALLATION.GET_APP_INFO('WIP', l_status, l_industry, l_table_owner);
1684:
1685: ad_parallel_updates_pkg.initialize_id_range(
1686: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1687: X_owner=>l_table_owner,
1688: X_table=>l_table_name,
1689: X_script=>l_update_name,

Line 1686: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,

1682:
1683: l_retstatus := FND_INSTALLATION.GET_APP_INFO('WIP', l_status, l_industry, l_table_owner);
1684:
1685: ad_parallel_updates_pkg.initialize_id_range(
1686: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1687: X_owner=>l_table_owner,
1688: X_table=>l_table_name,
1689: X_script=>l_update_name,
1690: X_ID_column=>l_id_column,

Line 1697: ad_parallel_updates_pkg.get_id_range(

1693: X_batch_size=>X_batch_size,
1694: X_debug_level=>0);
1695:
1696: l_stmt_num :=20;
1697: ad_parallel_updates_pkg.get_id_range(
1698: l_start_id,
1699: l_end_id,
1700: l_any_rows_to_process,
1701: X_batch_size,

Line 1745: ad_parallel_updates_pkg.processed_id_range(

1741: /*l_rows_processed := SQL%ROWCOUNT;*/
1742: l_rows_processed := l_end_id - l_start_id + 1;
1743:
1744: l_stmt_num :=40;
1745: ad_parallel_updates_pkg.processed_id_range(
1746: l_rows_processed,
1747: l_end_id);
1748:
1749: COMMIT;

Line 1752: ad_parallel_updates_pkg.get_id_range(

1748:
1749: COMMIT;
1750:
1751: l_stmt_num :=50;
1752: ad_parallel_updates_pkg.get_id_range(
1753: l_start_id,
1754: l_end_id,
1755: l_any_rows_to_process,
1756: X_batch_size,

Line 1934: ad_parallel_updates_pkg.initialize_id_range(

1930: l_update_name := X_Argument6 || 'R' || X_Argument4 || '-' || X_Argument5;
1931:
1932: l_retstatus := FND_INSTALLATION.GET_APP_INFO('PO', l_status, l_industry, l_table_owner);
1933:
1934: ad_parallel_updates_pkg.initialize_id_range(
1935: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1936: X_owner=>l_table_owner,
1937: X_table=>l_table_name,
1938: X_script=>l_update_name,

Line 1935: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,

1931:
1932: l_retstatus := FND_INSTALLATION.GET_APP_INFO('PO', l_status, l_industry, l_table_owner);
1933:
1934: ad_parallel_updates_pkg.initialize_id_range(
1935: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1936: X_owner=>l_table_owner,
1937: X_table=>l_table_name,
1938: X_script=>l_update_name,
1939: X_ID_column=>l_id_column,

Line 1946: ad_parallel_updates_pkg.get_id_range(

1942: X_batch_size=>X_batch_size,
1943: X_debug_level=>0);
1944:
1945: l_stmt_num :=20;
1946: ad_parallel_updates_pkg.get_id_range(
1947: l_start_id,
1948: l_end_id,
1949: l_any_rows_to_process,
1950: X_batch_size,

Line 1994: ad_parallel_updates_pkg.processed_id_range(

1990: /*l_rows_processed := SQL%ROWCOUNT;*/
1991: l_rows_processed := l_end_id - l_start_id + 1;
1992:
1993: l_stmt_num :=40;
1994: ad_parallel_updates_pkg.processed_id_range(
1995: l_rows_processed,
1996: l_end_id);
1997:
1998: COMMIT;

Line 2001: ad_parallel_updates_pkg.get_id_range(

1997:
1998: COMMIT;
1999:
2000: l_stmt_num :=50;
2001: ad_parallel_updates_pkg.get_id_range(
2002: l_start_id,
2003: l_end_id,
2004: l_any_rows_to_process,
2005: X_batch_size,