APPS.WIP_MOVE_ALLOC_CLEANUP dependencies on WIP_MOVE_TXN_ALLOCATIONS

Line 5: WIP_MOVE_TXN_ALLOCATIONS.TRANSACTION_ID%TYPE

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

Line 9: WIP_MOVE_TXN_ALLOCATIONS.REPETITIVE_SCHEDULE_ID%TYPE

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

Line 13: WIP_MOVE_TXN_ALLOCATIONS.ORGANIZATION_ID%TYPE

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

Line 17: WIP_MOVE_TXN_ALLOCATIONS.LAST_UPDATE_DATE%TYPE

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

Line 21: WIP_MOVE_TXN_ALLOCATIONS.LAST_UPDATED_BY%TYPE

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

Line 25: WIP_MOVE_TXN_ALLOCATIONS.CREATION_DATE%TYPE

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

Line 29: WIP_MOVE_TXN_ALLOCATIONS.CREATED_BY%TYPE

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

Line 33: WIP_MOVE_TXN_ALLOCATIONS.LAST_UPDATE_LOGIN%TYPE

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

Line 37: WIP_MOVE_TXN_ALLOCATIONS.REQUEST_ID%TYPE

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

Line 41: WIP_MOVE_TXN_ALLOCATIONS.PROGRAM_APPLICATION_ID%TYPE

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

Line 45: WIP_MOVE_TXN_ALLOCATIONS.PROGRAM_ID%TYPE

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

Line 49: WIP_MOVE_TXN_ALLOCATIONS.PROGRAM_UPDATE_DATE%TYPE

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

Line 53: WIP_MOVE_TXN_ALLOCATIONS.TRANSACTION_QUANTITY%TYPE

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

Line 57: WIP_MOVE_TXN_ALLOCATIONS.PRIMARY_QUANTITY%TYPE

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,

Line 60: TYPE WIP_MOVE_TXN_ALLOCATIONS_REC IS RECORD (

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,

Line 80: p_mov_allocs in out nocopy wip_move_txn_allocations_rec);

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:

Line 83: p_mov_allocs in wip_move_txn_allocations_rec);

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;