APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on CSD_REPAIR_ACTUALS

Line 9: /* purpose : Create Repair Actual header record in CSD_REPAIR_ACTUALS */

5: /*-------------------------------------------------------------------------------*/
6: /* procedure name: CSD_REPAIR_ACT_HDR_MIG3 */
7: /* description : procedure for migrating ACTUALS Headers data */
8: /* from 11.5.9 to 11.5.10 */
9: /* purpose : Create Repair Actual header record in CSD_REPAIR_ACTUALS */
10: /*-------------------------------------------------------------------------------*/
11:
12: PROCEDURE csd_repair_act_hdr_mig3(p_slab_number IN NUMBER DEFAULT 1)
13: IS

Line 39: FROM csd_repair_actuals cra

35: WHERE cre.repair_estimate_id = crel.repair_estimate_id
36: AND crel.estimate_detail_id = ced.estimate_detail_id
37: AND ced.order_line_id is not null)
38: AND NOT EXISTS ( SELECT 'x'
39: FROM csd_repair_actuals cra
40: WHERE cr.repair_line_id = cra.repair_line_id)
41: AND cr.repair_line_id >= p_start_rep_line_id
42: AND cr.repair_line_id <= p_end_rep_line_id;
43:

Line 75: APPS.CSD_REPAIR_ACTUALS_PKG.INSERT_ROW( px_REPAIR_ACTUAL_ID => l_repair_actual_id

71: BEGIN
72: -- gilam: clearing out repair actual id for creaing new header
73: l_repair_actual_id := null;
74:
75: APPS.CSD_REPAIR_ACTUALS_PKG.INSERT_ROW( px_REPAIR_ACTUAL_ID => l_repair_actual_id
76: ,p_OBJECT_VERSION_NUMBER => 1
77: ,p_REPAIR_LINE_ID => act_hdr_arr(j)
78: ,P_CREATED_BY => fnd_global.user_id
79: ,P_CREATION_DATE => sysdate

Line 121: VALUES ('CSD_REPAIR_ACTUALS',

117: ORIG_SYSTEM_REFERENCE_ID,
118: UPGRADE_DATETIME,
119: ERROR_MESSAGE,
120: MIGRATION_PHASE)
121: VALUES ('CSD_REPAIR_ACTUALS',
122: 'CSD_REPAIR_ACTUALS',
123: act_hdr_arr(j),
124: sysdate,
125: v_error_text,

Line 122: 'CSD_REPAIR_ACTUALS',

118: UPGRADE_DATETIME,
119: ERROR_MESSAGE,
120: MIGRATION_PHASE)
121: VALUES ('CSD_REPAIR_ACTUALS',
122: 'CSD_REPAIR_ACTUALS',
123: act_hdr_arr(j),
124: sysdate,
125: v_error_text,
126: '11.5.10');

Line 130: raise_application_error( -20000, 'Error while migrating ACTUALS Headers data: Error while inserting into CSD_REPAIR_ACTUALS. '|| v_error_text);

126: '11.5.10');
127:
128: commit;
129:
130: raise_application_error( -20000, 'Error while migrating ACTUALS Headers data: Error while inserting into CSD_REPAIR_ACTUALS. '|| v_error_text);
131:
132: END;
133: END LOOP;
134: COMMIT;

Line 1506: FROM CSD_REPAIR_ACTUALS

1502:
1503: -- get the actual header id : only one actual header for each repair line
1504: SELECT repair_actual_id
1505: INTO l_actual_id
1506: FROM CSD_REPAIR_ACTUALS
1507: WHERE repair_line_id = v_ORIGINAL_SOURCE_ID(j);
1508:
1509: -- gilam: add this query to get repair estimate line id for creating actual line
1510: -- get the repair estimate line id : to set as the source id of the new actual line

Line 1733: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to

1729: END;
1730:
1731: BEGIN
1732:
1733: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
1734: -- insert the record into CSD_REPAIR_ACTUAL_LINES
1735: -- this is Depot Actual line created from the Estimate line
1736:
1737: -- gilam: clear out actual line id when creating new row

Line 1890: FROM CSD_REPAIR_ACTUALS

1886:
1887: -- get the actual header id : only one actual header for each repair line
1888: SELECT repair_actual_id
1889: INTO l_actual_id
1890: FROM CSD_REPAIR_ACTUALS
1891: WHERE repair_line_id = est_det_arr(j).original_source_id;
1892:
1893: -- gilam: add this query to get repair estimate line id for creating actual line
1894: -- get the repair estimate line id : to set as the source id of the new actual line

Line 2111: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to

2107: END;
2108:
2109: BEGIN
2110:
2111: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
2112: -- insert the record into CSD_REPAIR_ACTUAL_LINES
2113: -- this is Depot Actual line created from the Estimate line
2114:
2115: -- gilam: clear out actual line id when creating new row