35: -- This opens the cursor for SO and returns the cursor.
36: --========================================================================
37:
38: PROCEDURE Get_SO_Transactions
39: ( so_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
40: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
41: , p_start_date IN DATE
42: , p_end_date IN DATE
43: , x_return_status OUT NOCOPY VARCHAR2
36: --========================================================================
37:
38: PROCEDURE Get_SO_Transactions
39: ( so_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
40: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
41: , p_start_date IN DATE
42: , p_end_date IN DATE
43: , x_return_status OUT NOCOPY VARCHAR2
44: );
53: -- This opens the cursor for SO and returns the cursor.
54: --========================================================================
55:
56: PROCEDURE Get_TwoLeOneCntry_Txns
57: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
58: , p_movement_transaction IN
59: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
60: , p_start_date IN DATE
61: , p_end_date IN DATE
55:
56: PROCEDURE Get_TwoLeOneCntry_Txns
57: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
58: , p_movement_transaction IN
59: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
60: , p_start_date IN DATE
61: , p_end_date IN DATE
62: , x_return_status OUT NOCOPY VARCHAR2
63: );
73: -- This opens the cursor for SO and returns the cursor.
74: --========================================================================
75:
76: PROCEDURE Get_Triangulation_Txns
77: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
78: , p_movement_transaction IN
79: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
80: , p_start_date IN DATE
81: , p_end_date IN DATE
75:
76: PROCEDURE Get_Triangulation_Txns
77: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
78: , p_movement_transaction IN
79: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
80: , p_start_date IN DATE
81: , p_end_date IN DATE
82: , x_return_status OUT NOCOPY VARCHAR2
83: );
90: --========================================================================
91:
92: PROCEDURE Update_SO_Transactions
93: ( p_movement_transaction IN
94: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
95: , p_status IN VARCHAR2
96: , x_return_status OUT NOCOPY VARCHAR2
97: );
98:
121: --========================================================================
122:
123: PROCEDURE Get_SO_Details
124: ( x_movement_transaction IN OUT NOCOPY
125: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
126: , x_return_status OUT NOCOPY VARCHAR2
127: );
128:
129: --========================================================================
134: --========================================================================
135: PROCEDURE Get_KIT_SO_Details
136: ( p_link_to_line_id IN VARCHAR2
137: , x_movement_transaction IN OUT NOCOPY
138: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
139: );
140:
141: --========================================================================
142: -- PROCEDURE : Get_IO_Details PRIVATE
146: --========================================================================
147:
148: PROCEDURE Get_IO_Details
149: ( x_movement_transaction IN OUT NOCOPY
150: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
151: , x_return_status OUT NOCOPY VARCHAR2
152: );
153:
154: --========================================================================