DBA Data[Home] [Help]

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 861: ad_parallel_updates_pkg.initialize_rowid_range(

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

Line 862: ad_parallel_updates_pkg.ROWID_RANGE,

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

Line 871: ad_parallel_updates_pkg.get_rowid_range(

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

Line 887: ad_parallel_updates_pkg.processed_rowid_range(

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

Line 893: ad_parallel_updates_pkg.get_rowid_range(

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