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
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;
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);
999: )
1000: IS
1001:
1002: -- Cursor For Fetching Movement Statistics Records
1003: val_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
1004: l_excp_list INV_MGD_MVT_DATA_STR.excp_list;
1005: l_record_status VARCHAR2(1);
1006: l_return_status VARCHAR2(1);
1007: x_updated_flag VARCHAR2(1);
1000: IS
1001:
1002: -- Cursor For Fetching Movement Statistics Records
1003: val_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
1004: l_excp_list INV_MGD_MVT_DATA_STR.excp_list;
1005: l_record_status VARCHAR2(1);
1006: l_return_status VARCHAR2(1);
1007: x_updated_flag VARCHAR2(1);
1008: l_msg_count NUMBER;
1007: x_updated_flag VARCHAR2(1);
1008: l_msg_count NUMBER;
1009: l_msg_data VARCHAR2(100);
1010: l_mtl_movement_statistics
1011: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1012: l_init_movement_statistics
1013: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1014: l_ret_movement_statistics
1015: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1009: l_msg_data VARCHAR2(100);
1010: l_mtl_movement_statistics
1011: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1012: l_init_movement_statistics
1013: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1014: l_ret_movement_statistics
1015: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1016: l_movement_stat_usages_rec
1017: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1011: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1012: l_init_movement_statistics
1013: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1014: l_ret_movement_statistics
1015: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1016: l_movement_stat_usages_rec
1017: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1018:
1019: l_procedure_name CONSTANT VARCHAR2(30) := 'Validate_Transaction';
1013: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1014: l_ret_movement_statistics
1015: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1016: l_movement_stat_usages_rec
1017: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1018:
1019: l_procedure_name CONSTANT VARCHAR2(30) := 'Validate_Transaction';
1020:
1021: l_api_version_number NUMBER;