APPS.CSD_MIGRATE_FROM_12X_PKG9 dependencies on CSD_AHL_W_CONTRACT_XREF

Line 5: /* Procedure Name: CSD_AHL_W_CONTRACT_XREF_MIG9 */

1: PACKAGE BODY CSD_MIGRATE_FROM_12X_PKG9 AS
2: /* $Header: csdmig9b.pls 120.0 2011/07/21 18:37:03 yvchen noship $ */
3:
4:
5: /* Procedure Name: CSD_AHL_W_CONTRACT_XREF_MIG9 */
6: /* This procedure updates the existing CSD_AHL_W_CONTRACT_XREF table to */
7: /* support the supplier warranty enhancement. The instance_id for the */
8: /* existing records will be added to the new column INSTANCE_ID. */
9: /* @param. None */

Line 6: /* This procedure updates the existing CSD_AHL_W_CONTRACT_XREF table to */

2: /* $Header: csdmig9b.pls 120.0 2011/07/21 18:37:03 yvchen noship $ */
3:
4:
5: /* Procedure Name: CSD_AHL_W_CONTRACT_XREF_MIG9 */
6: /* This procedure updates the existing CSD_AHL_W_CONTRACT_XREF table to */
7: /* support the supplier warranty enhancement. The instance_id for the */
8: /* existing records will be added to the new column INSTANCE_ID. */
9: /* @param. None */
10:

Line 12: PROCEDURE CSD_AHL_W_CONTRACT_XREF_MIG9 IS

8: /* existing records will be added to the new column INSTANCE_ID. */
9: /* @param. None */
10:
11:
12: PROCEDURE CSD_AHL_W_CONTRACT_XREF_MIG9 IS
13:
14: -- Definitions --
15: TYPE W_CONTRACT_XREF_ID_ARRAY_TYPE IS VARRAY (1000)
16: OF CSD_AHL_W_CONTRACT_XREF.WARRANTY_CONTRACT_XREF_ID%TYPE;

Line 16: OF CSD_AHL_W_CONTRACT_XREF.WARRANTY_CONTRACT_XREF_ID%TYPE;

12: PROCEDURE CSD_AHL_W_CONTRACT_XREF_MIG9 IS
13:
14: -- Definitions --
15: TYPE W_CONTRACT_XREF_ID_ARRAY_TYPE IS VARRAY (1000)
16: OF CSD_AHL_W_CONTRACT_XREF.WARRANTY_CONTRACT_XREF_ID%TYPE;
17: TYPE INSTANCE_ID_ARRAY_TYPE IS VARRAY (1000)
18: OF CSD_REPAIRS.CUSTOMER_PRODUCT_ID%TYPE;
19:
20: -- Variables --

Line 38: CSD_AHL_W_CONTRACT_XREF wc,

34: IS
35: SELECT DISTINCT
36: wc.warranty_contract_xref_id, rep.customer_product_id
37: FROM
38: CSD_AHL_W_CONTRACT_XREF wc,
39: CSD_REPAIRS rep
40: WHERE wc.instance_id IS NULL
41: AND rep.repair_line_id = wc.repair_line_id;
42:

Line 57: CSD_AHL_W_CONTRACT_XREF

53:
54: FOR i IN 1..w_contract_xref_id_arr.COUNT LOOP
55:
56: UPDATE
57: CSD_AHL_W_CONTRACT_XREF
58: SET
59: instance_id = instance_id_arr(i)
60: WHERE warranty_contract_xref_id = w_contract_xref_id_arr(i);
61:

Line 76: END CSD_AHL_W_CONTRACT_XREF_MIG9;

72: END IF;
73:
74: COMMIT;
75:
76: END CSD_AHL_W_CONTRACT_XREF_MIG9;
77:
78: END CSD_MIGRATE_FROM_12X_PKG9;