DBA Data[Home] [Help]

APPS.INV_MGD_MVT_VALIDATE_PROC dependencies on INV_MGD_MVT_DATA_STR

Line 41: g_final_excp_list INV_MGD_MVT_DATA_STR.excp_list ;

37: -- GLOBALS
38: --===================
39:
40: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_MGD_MVT_VALIDATE_PROC';
41: g_final_excp_list INV_MGD_MVT_DATA_STR.excp_list ;
42: G_rpt_page_col CONSTANT INTEGER := 78 ;
43: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'inv.plsql.INV_MGD_MVT_VALIDATE_PROC.';
44: --========================================================================
45: --PROCEDURE : Populate_temp_table PRIVATE

Line 54: ( p_excp_list IN INV_MGD_MVT_DATA_STR.EXCP_LIST

50: -- COMMENT : Procedure populates temp table INV_MVT_EXCEP_REP_TEMP with
51: -- data, that is printed in Exception Report
52: --=======================================================================
53: PROCEDURE Populate_temp_table
54: ( p_excp_list IN INV_MGD_MVT_DATA_STR.EXCP_LIST
55: , p_mtl_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
56: )
57: IS
58: l_num_of_exceptions NUMBER;

Line 55: , p_mtl_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

51: -- data, that is printed in Exception Report
52: --=======================================================================
53: PROCEDURE Populate_temp_table
54: ( p_excp_list IN INV_MGD_MVT_DATA_STR.EXCP_LIST
55: , p_mtl_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
56: )
57: IS
58: l_num_of_exceptions NUMBER;
59: l_item_code VARCHAR2(40);

Line 1021: val_crsr INV_MGD_MVT_DATA_STR.valCurTyp;

1017: )
1018: IS
1019:
1020: -- Cursor For Fetching Movement Statistics Records
1021: val_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
1022: l_excp_list INV_MGD_MVT_DATA_STR.excp_list;
1023: l_record_status VARCHAR2(1);
1024: l_return_status VARCHAR2(1);
1025: x_updated_flag VARCHAR2(1);

Line 1022: l_excp_list INV_MGD_MVT_DATA_STR.excp_list;

1018: IS
1019:
1020: -- Cursor For Fetching Movement Statistics Records
1021: val_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
1022: l_excp_list INV_MGD_MVT_DATA_STR.excp_list;
1023: l_record_status VARCHAR2(1);
1024: l_return_status VARCHAR2(1);
1025: x_updated_flag VARCHAR2(1);
1026: l_msg_count NUMBER;

Line 1029: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1025: x_updated_flag VARCHAR2(1);
1026: l_msg_count NUMBER;
1027: l_msg_data VARCHAR2(100);
1028: l_mtl_movement_statistics
1029: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1030: l_init_movement_statistics
1031: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1032: l_ret_movement_statistics
1033: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 1031: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1027: l_msg_data VARCHAR2(100);
1028: l_mtl_movement_statistics
1029: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1030: l_init_movement_statistics
1031: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1032: l_ret_movement_statistics
1033: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1034: l_movement_stat_usages_rec
1035: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 1033: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1029: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1030: l_init_movement_statistics
1031: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1032: l_ret_movement_statistics
1033: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1034: l_movement_stat_usages_rec
1035: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1036:
1037: l_procedure_name CONSTANT VARCHAR2(30) := 'Validate_Transaction';

Line 1035: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1031: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1032: l_ret_movement_statistics
1033: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1034: l_movement_stat_usages_rec
1035: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1036:
1037: l_procedure_name CONSTANT VARCHAR2(30) := 'Validate_Transaction';
1038:
1039: l_api_version_number NUMBER;