PACKAGE: APPS.WIP_MOVE_ALLOC_CLEANUP

Source

1 PACKAGE WIP_MOVE_ALLOC_CLEANUP AUTHID CURRENT_USER AS
2 /* $Header: wipmacls.pls 115.6 2002/11/28 13:23:39 rmahidha ship $ */
3 
4   TYPE TRANSACTION_ID_T IS TABLE OF
5   WIP_MOVE_TXN_ALLOCATIONS.TRANSACTION_ID%TYPE
6   INDEX BY BINARY_INTEGER;
7 
8   TYPE REPETITIVE_SCHEDULE_ID_T IS TABLE OF
9   WIP_MOVE_TXN_ALLOCATIONS.REPETITIVE_SCHEDULE_ID%TYPE
10   INDEX BY BINARY_INTEGER;
11 
12   TYPE ORGANIZATION_ID_T IS TABLE OF
13   WIP_MOVE_TXN_ALLOCATIONS.ORGANIZATION_ID%TYPE
14   INDEX BY BINARY_INTEGER;
15 
16   TYPE LAST_UPDATE_DATE_T IS TABLE OF
17   WIP_MOVE_TXN_ALLOCATIONS.LAST_UPDATE_DATE%TYPE
18   INDEX BY BINARY_INTEGER;
19 
20   TYPE LAST_UPDATED_BY_T IS TABLE OF
21   WIP_MOVE_TXN_ALLOCATIONS.LAST_UPDATED_BY%TYPE
22   INDEX BY BINARY_INTEGER;
23 
24   TYPE CREATION_DATE_T IS TABLE OF
25   WIP_MOVE_TXN_ALLOCATIONS.CREATION_DATE%TYPE
26   INDEX BY BINARY_INTEGER;
27 
28   TYPE CREATED_BY_T IS TABLE OF
29   WIP_MOVE_TXN_ALLOCATIONS.CREATED_BY%TYPE
30   INDEX BY BINARY_INTEGER;
31 
32   TYPE LAST_UPDATE_LOGIN_T IS TABLE OF
33   WIP_MOVE_TXN_ALLOCATIONS.LAST_UPDATE_LOGIN%TYPE
34   INDEX BY BINARY_INTEGER;
35 
36   TYPE REQUEST_ID_T IS TABLE OF
37   WIP_MOVE_TXN_ALLOCATIONS.REQUEST_ID%TYPE
38   INDEX BY BINARY_INTEGER;
39 
40   TYPE PROGRAM_APPLICATION_ID_T IS TABLE OF
41   WIP_MOVE_TXN_ALLOCATIONS.PROGRAM_APPLICATION_ID%TYPE
42   INDEX BY BINARY_INTEGER;
43 
44   TYPE PROGRAM_ID_T IS TABLE OF
45   WIP_MOVE_TXN_ALLOCATIONS.PROGRAM_ID%TYPE
46   INDEX BY BINARY_INTEGER;
47 
48   TYPE PROGRAM_UPDATE_DATE_T IS TABLE OF
49   WIP_MOVE_TXN_ALLOCATIONS.PROGRAM_UPDATE_DATE%TYPE
50   INDEX BY BINARY_INTEGER;
51 
52   TYPE TRANSACTION_QUANTITY_T IS TABLE OF
53   WIP_MOVE_TXN_ALLOCATIONS.TRANSACTION_QUANTITY%TYPE
54   INDEX BY BINARY_INTEGER;
55 
56   TYPE PRIMARY_QUANTITY_T IS TABLE OF
57   WIP_MOVE_TXN_ALLOCATIONS.PRIMARY_QUANTITY%TYPE
58   INDEX BY BINARY_INTEGER;
59 
60   TYPE WIP_MOVE_TXN_ALLOCATIONS_REC IS RECORD (
61     NUMRECS NUMBER,
62     TRANSACTION_ID TRANSACTION_ID_T,
63     REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID_T,
64     ORGANIZATION_ID ORGANIZATION_ID_T,
65     LAST_UPDATE_DATE LAST_UPDATE_DATE_T,
66     LAST_UPDATED_BY LAST_UPDATED_BY_T,
67     CREATION_DATE CREATION_DATE_T,
68     CREATED_BY CREATED_BY_T,
69     LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_T,
70     REQUEST_ID REQUEST_ID_T,
71     PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID_T,
72     PROGRAM_ID PROGRAM_ID_T,
73     PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE_T,
74     TRANSACTION_QUANTITY TRANSACTION_QUANTITY_T,
75     PRIMARY_QUANTITY PRIMARY_QUANTITY_T
76   );
77 
78   procedure fetch_and_delete(
79     p_mov_grp_id in     number,
80     p_mov_allocs in out nocopy wip_move_txn_allocations_rec);
81 
82   procedure insert_rows(
83     p_mov_allocs in wip_move_txn_allocations_rec);
84 
85 END WIP_MOVE_ALLOC_CLEANUP;