APPS.CS_CHG_LINENO_UPG_PKG dependencies on CS_ESTIMATE_DETAILS

Line 38: l_table_name VARCHAR2(30) := 'CS_ESTIMATE_DETAILS';

34: IS
35:
36: l_worker_id NUMBER;
37: l_product VARCHAR2(30) := 'CS';
38: l_table_name VARCHAR2(30) := 'CS_ESTIMATE_DETAILS';
39: l_id_column VARCHAR2(30) := 'INCIDENT_ID';
40: l_update_name VARCHAR2(30) := 'csxelnub.120.1';
41: l_status VARCHAR2(30);
42: l_industry VARCHAR2(30);

Line 58: FROM CS_ESTIMATE_DETAILS

54: Line_Number,
55: Row_Number() over (PARTITION BY Incident_Id
56: ORDER BY Creation_Date asc,
57: Estimate_Detail_Id ) rn
58: FROM CS_ESTIMATE_DETAILS
59: WHERE Incident_id between v_start_incident and v_end_incident )
60: WHERE nvl(Line_Number,-1) <> Rn;
61:
62: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 105: FROM CS_ESTIMATE_DETAILS ed ', --> X_SQL_Stmt

101: x_num_workers,
102: x_batch_size,
103: 0,
104: ' SELECT ed.incident_id id_value
105: FROM CS_ESTIMATE_DETAILS ed ', --> X_SQL_Stmt
106: null, --> X_Begin_ID
107: null --> X_End_ID
108: );
109:

Line 118: FROM CS_ESTIMATE_DETAILS ed )

114: MIN(incident_id) AS start_id_value,
115: MAX(incident_id) AS end_id_value
116: FROM ( SELECT ed.incident_id,
117: FLOOR( RANK() OVER (ORDER BY ed.incident_id)/:batchsize ) unit_id
118: FROM CS_ESTIMATE_DETAILS ed )
119: GROUP BY unit_id
120: */
121:
122:

Line 146: UPDATE CS_ESTIMATE_DETAILS

142:
143: l_rows_processed := v_row_id.COUNT;
144:
145: FORALL i in 1..l_rows_processed
146: UPDATE CS_ESTIMATE_DETAILS
147: SET line_number = v_row_number(i)
148: WHERE rowid = v_row_id(i);
149:
150: AD_PARALLEL_UPDATES_PKG.processed_id_range(