APPS.CST_SLA_UPDATE_PKG dependencies on AD_PARALLEL_UPDATES_PKG

Line 1139: ad_parallel_updates_pkg.initialize_id_range(

1135: l_update_name := 'I' || X_Argument4 || '-' || X_Argument5;
1136:
1137: l_retstatus := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_table_owner);
1138:
1139: ad_parallel_updates_pkg.initialize_id_range(
1140: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1141: X_owner=>l_table_owner,
1142: X_table=>l_table_name,
1143: X_script=>l_update_name,

Line 1140: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,

1136:
1137: l_retstatus := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_table_owner);
1138:
1139: ad_parallel_updates_pkg.initialize_id_range(
1140: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1141: X_owner=>l_table_owner,
1142: X_table=>l_table_name,
1143: X_script=>l_update_name,
1144: X_ID_column=>l_id_column,

Line 1151: ad_parallel_updates_pkg.get_id_range(

1147: X_batch_size=>X_batch_size,
1148: X_debug_level=>0);
1149:
1150: l_stmt_num :=20;
1151: ad_parallel_updates_pkg.get_id_range(
1152: l_start_id,
1153: l_end_id,
1154: l_any_rows_to_process,
1155: X_batch_size,

Line 1177: ad_parallel_updates_pkg.processed_id_range(

1173: /*l_rows_processed := SQL%ROWCOUNT;*/
1174: l_rows_processed := l_end_id - l_start_id + 1;
1175:
1176: l_stmt_num :=40;
1177: ad_parallel_updates_pkg.processed_id_range(
1178: l_rows_processed,
1179: l_end_id);
1180:
1181: commit;

Line 1184: ad_parallel_updates_pkg.get_id_range(

1180:
1181: commit;
1182:
1183: l_stmt_num :=50;
1184: ad_parallel_updates_pkg.get_id_range(
1185: l_start_id,
1186: l_end_id,
1187: l_any_rows_to_process,
1188: X_batch_size,

Line 1390: ad_parallel_updates_pkg.initialize_id_range(

1386: l_update_name := 'W' || X_Argument4 || '-' || X_Argument5;
1387:
1388: l_retstatus := FND_INSTALLATION.GET_APP_INFO('WIP', l_status, l_industry, l_table_owner);
1389:
1390: ad_parallel_updates_pkg.initialize_id_range(
1391: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1392: X_owner=>l_table_owner,
1393: X_table=>l_table_name,
1394: X_script=>l_update_name,

Line 1391: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,

1387:
1388: l_retstatus := FND_INSTALLATION.GET_APP_INFO('WIP', l_status, l_industry, l_table_owner);
1389:
1390: ad_parallel_updates_pkg.initialize_id_range(
1391: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1392: X_owner=>l_table_owner,
1393: X_table=>l_table_name,
1394: X_script=>l_update_name,
1395: X_ID_column=>l_id_column,

Line 1402: ad_parallel_updates_pkg.get_id_range(

1398: X_batch_size=>X_batch_size,
1399: X_debug_level=>0);
1400:
1401: l_stmt_num :=20;
1402: ad_parallel_updates_pkg.get_id_range(
1403: l_start_id,
1404: l_end_id,
1405: l_any_rows_to_process,
1406: X_batch_size,

Line 1428: ad_parallel_updates_pkg.processed_id_range(

1424: /*l_rows_processed := SQL%ROWCOUNT;*/
1425: l_rows_processed := l_end_id - l_start_id + 1;
1426:
1427: l_stmt_num :=40;
1428: ad_parallel_updates_pkg.processed_id_range(
1429: l_rows_processed,
1430: l_end_id);
1431:
1432: commit;

Line 1435: ad_parallel_updates_pkg.get_id_range(

1431:
1432: commit;
1433:
1434: l_stmt_num :=50;
1435: ad_parallel_updates_pkg.get_id_range(
1436: l_start_id,
1437: l_end_id,
1438: l_any_rows_to_process,
1439: X_batch_size,

Line 1663: ad_parallel_updates_pkg.initialize_id_range(

1659: l_update_name := 'R' || X_Argument4 || '-' || X_Argument5;
1660:
1661: l_retstatus := FND_INSTALLATION.GET_APP_INFO('PO', l_status, l_industry, l_table_owner);
1662:
1663: ad_parallel_updates_pkg.initialize_id_range(
1664: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1665: X_owner=>l_table_owner,
1666: X_table=>l_table_name,
1667: X_script=>l_update_name,

Line 1664: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,

1660:
1661: l_retstatus := FND_INSTALLATION.GET_APP_INFO('PO', l_status, l_industry, l_table_owner);
1662:
1663: ad_parallel_updates_pkg.initialize_id_range(
1664: X_update_type=>ad_parallel_updates_pkg.ID_RANGE,
1665: X_owner=>l_table_owner,
1666: X_table=>l_table_name,
1667: X_script=>l_update_name,
1668: X_ID_column=>l_id_column,

Line 1675: ad_parallel_updates_pkg.get_id_range(

1671: X_batch_size=>X_batch_size,
1672: X_debug_level=>0);
1673:
1674: l_stmt_num :=20;
1675: ad_parallel_updates_pkg.get_id_range(
1676: l_start_id,
1677: l_end_id,
1678: l_any_rows_to_process,
1679: X_batch_size,

Line 1701: ad_parallel_updates_pkg.processed_id_range(

1697: /*l_rows_processed := SQL%ROWCOUNT;*/
1698: l_rows_processed := l_end_id - l_start_id + 1;
1699:
1700: l_stmt_num :=40;
1701: ad_parallel_updates_pkg.processed_id_range(
1702: l_rows_processed,
1703: l_end_id);
1704:
1705: commit;

Line 1708: ad_parallel_updates_pkg.get_id_range(

1704:
1705: commit;
1706:
1707: l_stmt_num :=50;
1708: ad_parallel_updates_pkg.get_id_range(
1709: l_start_id,
1710: l_end_id,
1711: l_any_rows_to_process,
1712: X_batch_size,