APPS.PA_BILL_REV_XLA_UPGRADE dependencies on AD_PARALLEL_UPDATES_PKG

Line 31: ad_parallel_updates_pkg.initialize_id_range(

27: ' and hd.PERIOD_NAME = per.PERIOD_NAME ' ||
28: ' and hd.je_source = ''Project Accounting'' ' ||
29: ' and per.batch_id = ' || p_batch_id ;
30:
31: ad_parallel_updates_pkg.initialize_id_range(
32: ad_parallel_updates_pkg.ID_RANGE_SCAN_EQUI_ROWSETS,
33: p_table_owner,
34: p_table_name,
35: p_script_name,

Line 32: ad_parallel_updates_pkg.ID_RANGE_SCAN_EQUI_ROWSETS,

28: ' and hd.je_source = ''Project Accounting'' ' ||
29: ' and per.batch_id = ' || p_batch_id ;
30:
31: ad_parallel_updates_pkg.initialize_id_range(
32: ad_parallel_updates_pkg.ID_RANGE_SCAN_EQUI_ROWSETS,
33: p_table_owner,
34: p_table_name,
35: p_script_name,
36: 'JE_HEADER_ID',

Line 46: ad_parallel_updates_pkg.get_id_range(

42: null,
43: null);
44:
45: ------ Get rowid ranges ------
46: ad_parallel_updates_pkg.get_id_range(
47: l_start_jeid,
48: l_end_jeid,
49: l_any_rows_to_process,
50: p_batch_size,

Line 83: ad_parallel_updates_pkg.processed_id_range(

79: and hd.JE_HEADER_ID = gl.JE_HEADER_ID);
80:
81: l_rows_processed := SQL%ROWCOUNT;
82:
83: ad_parallel_updates_pkg.processed_id_range(
84: l_rows_processed,
85: l_end_jeid);
86:
87: COMMIT;

Line 89: ad_parallel_updates_pkg.get_id_range(

85: l_end_jeid);
86:
87: COMMIT;
88:
89: ad_parallel_updates_pkg.get_id_range(
90: l_start_jeid,
91: l_end_jeid,
92: l_any_rows_to_process,
93: p_batch_size,

Line 121: ad_parallel_updates_pkg.initialize_rowid_range(

117: l_any_rows_to_process BOOLEAN;
118: l_rows_processed NUMBER;
119: BEGIN
120:
121: ad_parallel_updates_pkg.initialize_rowid_range(
122: ad_parallel_updates_pkg.ROWID_RANGE,
123: p_table_owner,
124: p_table_name,
125: p_script_name,

Line 122: ad_parallel_updates_pkg.ROWID_RANGE,

118: l_rows_processed NUMBER;
119: BEGIN
120:
121: ad_parallel_updates_pkg.initialize_rowid_range(
122: ad_parallel_updates_pkg.ROWID_RANGE,
123: p_table_owner,
124: p_table_name,
125: p_script_name,
126: p_worker_id,

Line 131: ad_parallel_updates_pkg.get_rowid_range(

127: p_num_workers,
128: p_batch_size, 0);
129:
130: ------ Get rowid ranges ------
131: ad_parallel_updates_pkg.get_rowid_range(
132: l_start_rowid,
133: l_end_rowid,
134: l_any_rows_to_process,
135: p_batch_size,

Line 147: ad_parallel_updates_pkg.processed_rowid_range(

143: p_end_rowid => l_end_rowid,
144: p_batch_id => p_batch_id,
145: p_rows_process => l_rows_processed);
146:
147: ad_parallel_updates_pkg.processed_rowid_range(
148: l_rows_processed,
149: l_end_rowid);
150:
151: COMMIT;

Line 153: ad_parallel_updates_pkg.get_rowid_range(

149: l_end_rowid);
150:
151: COMMIT;
152:
153: ad_parallel_updates_pkg.get_rowid_range(
154: l_start_rowid,
155: l_end_rowid,
156: l_any_rows_to_process,
157: p_batch_size,

Line 860: ad_parallel_updates_pkg.initialize_rowid_range(

856: l_any_rows_to_process BOOLEAN;
857: l_rows_processed NUMBER;
858: BEGIN
859:
860: ad_parallel_updates_pkg.initialize_rowid_range(
861: ad_parallel_updates_pkg.ROWID_RANGE,
862: p_table_owner,
863: p_table_name,
864: p_script_name,

Line 861: ad_parallel_updates_pkg.ROWID_RANGE,

857: l_rows_processed NUMBER;
858: BEGIN
859:
860: ad_parallel_updates_pkg.initialize_rowid_range(
861: ad_parallel_updates_pkg.ROWID_RANGE,
862: p_table_owner,
863: p_table_name,
864: p_script_name,
865: p_worker_id,

Line 870: ad_parallel_updates_pkg.get_rowid_range(

866: p_num_workers,
867: p_batch_size, 0);
868:
869: ------ Get rowid ranges ------
870: ad_parallel_updates_pkg.get_rowid_range(
871: l_start_rowid,
872: l_end_rowid,
873: l_any_rows_to_process,
874: p_batch_size,

Line 886: ad_parallel_updates_pkg.processed_rowid_range(

882: p_end_rowid => l_end_rowid,
883: p_batch_id => p_batch_id,
884: p_rows_process => l_rows_processed);
885:
886: ad_parallel_updates_pkg.processed_rowid_range(
887: l_rows_processed,
888: l_end_rowid);
889:
890: COMMIT;

Line 892: ad_parallel_updates_pkg.get_rowid_range(

888: l_end_rowid);
889:
890: COMMIT;
891:
892: ad_parallel_updates_pkg.get_rowid_range(
893: l_start_rowid,
894: l_end_rowid,
895: l_any_rows_to_process,
896: p_batch_size,