DBA Data[Home] [Help]

APPS.INV_MGD_MVT_SETUP_MDTR dependencies on INV_MGD_MVT_DATA_STR

Line 56: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

52: ( p_legal_entity_id IN NUMBER
53: , p_start_date IN DATE
54: , p_end_date IN DATE
55: , p_transaction_type IN VARCHAR2
56: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
57: , x_return_status OUT NOCOPY VARCHAR2
58: , ref_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
59: )
60: IS

Line 58: , ref_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp

54: , p_end_date IN DATE
55: , p_transaction_type IN VARCHAR2
56: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
57: , x_return_status OUT NOCOPY VARCHAR2
58: , ref_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
59: )
60: IS
61: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
62: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 61: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

57: , x_return_status OUT NOCOPY VARCHAR2
58: , ref_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
59: )
60: IS
61: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
62: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
63: l_return_status VARCHAR2(1);
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(100);

Line 62: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

58: , ref_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
59: )
60: IS
61: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
62: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
63: l_return_status VARCHAR2(1);
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(100);
66: l_transaction_date DATE;

Line 197: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

193: --========================================================================
194:
195: PROCEDURE Get_Setup_Context
196: ( p_legal_entity_id IN NUMBER
197: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
198: , x_return_status OUT NOCOPY VARCHAR2
199: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
200: )
201: IS

Line 199: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp

195: PROCEDURE Get_Setup_Context
196: ( p_legal_entity_id IN NUMBER
197: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
198: , x_return_status OUT NOCOPY VARCHAR2
199: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
200: )
201: IS
202: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
203: l_return_status VARCHAR2(1);

Line 202: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

198: , x_return_status OUT NOCOPY VARCHAR2
199: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
200: )
201: IS
202: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
203: l_return_status VARCHAR2(1);
204: l_msg_count NUMBER;
205: l_msg_data VARCHAR2(100);
206: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Setup_Context';

Line 293: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

289: ( p_legal_entity_id IN NUMBER
290: , p_start_date IN DATE
291: , p_end_date IN DATE
292: , p_transaction_type IN VARCHAR2
293: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
294: , x_return_status OUT NOCOPY VARCHAR2
295: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
296: )
297: IS

Line 295: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp

291: , p_end_date IN DATE
292: , p_transaction_type IN VARCHAR2
293: , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
294: , x_return_status OUT NOCOPY VARCHAR2
295: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
296: )
297: IS
298: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
299: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 298: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

294: , x_return_status OUT NOCOPY VARCHAR2
295: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
296: )
297: IS
298: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
299: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
300: l_return_status VARCHAR2(1);
301: l_msg_count NUMBER;
302: l_msg_data VARCHAR2(100);

Line 299: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

295: , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
296: )
297: IS
298: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
299: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
300: l_return_status VARCHAR2(1);
301: l_msg_count NUMBER;
302: l_msg_data VARCHAR2(100);
303: l_transaction_date DATE;

Line 423: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

419: -- is to be inserted into the mvt stats table
420: --========================================================================
421:
422: FUNCTION Process_Setup_Context
423: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
424: )RETURN VARCHAR2
425: IS
426: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
427: l_insert_flag VARCHAR2(1);

Line 426: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

422: FUNCTION Process_Setup_Context
423: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
424: )RETURN VARCHAR2
425: IS
426: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
427: l_insert_flag VARCHAR2(1);
428: l_ship_from_loc VARCHAR2(10);
429: l_ship_to_loc VARCHAR2(10);
430: l_procedure_name CONSTANT VARCHAR2(30) := 'Process_Setup_Context';

Line 554: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

550: , p_economic_zone_code IN VARCHAR2
551: , p_usage_type IN VARCHAR2
552: , p_stat_type IN VARCHAR2
553: , x_movement_stat_usages_rec OUT NOCOPY
554: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
555: )
556: IS
557: l_api_version_number CONSTANT NUMBER := 1.0;
558: l_procedure_name CONSTANT VARCHAR2(30):= 'Get_Movement_Stat_Usages';