74: --=========================================================================
75:
76: PROCEDURE Mvt_Stats_Util_Info
77: ( p_stat_typ_transaction IN
78: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
79: , x_movement_transaction IN OUT NOCOPY
80: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
81: , x_return_status OUT NOCOPY VARCHAR2
82: )
76: PROCEDURE Mvt_Stats_Util_Info
77: ( p_stat_typ_transaction IN
78: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
79: , x_movement_transaction IN OUT NOCOPY
80: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
81: , x_return_status OUT NOCOPY VARCHAR2
82: )
83: IS
84: l_api_version_number CONSTANT NUMBER := 1.0;
82: )
83: IS
84: l_api_version_number CONSTANT NUMBER := 1.0;
85: l_api_name CONSTANT VARCHAR2(30) := 'Mvt_Stats_Util_Info';
86: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
87: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
88: l_uom_code VARCHAR2(15);
89: l_procedure_name CONSTANT VARCHAR2(30) := 'Mvt_Stats_Util_Info';
90: l_weight_precision NUMBER;
83: IS
84: l_api_version_number CONSTANT NUMBER := 1.0;
85: l_api_name CONSTANT VARCHAR2(30) := 'Mvt_Stats_Util_Info';
86: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
87: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
88: l_uom_code VARCHAR2(15);
89: l_procedure_name CONSTANT VARCHAR2(30) := 'Mvt_Stats_Util_Info';
90: l_weight_precision NUMBER;
91: l_rounding_method VARCHAR2(30);
930: --=========================================================================
931:
932: FUNCTION Get_Category_Id
933: ( p_movement_transaction IN
934: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
935: , p_stat_typ_transaction IN
936: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
937: )
938: RETURN NUMBER
932: FUNCTION Get_Category_Id
933: ( p_movement_transaction IN
934: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
935: , p_stat_typ_transaction IN
936: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
937: )
938: RETURN NUMBER
939: IS
940: l_category_id NUMBER;
1030: --=========================================================================
1031:
1032: PROCEDURE Get_Commodity_Info
1033: ( x_movement_transaction IN OUT NOCOPY
1034: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1035: )
1036: IS
1037: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1038: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Commodity_Info';
1033: ( x_movement_transaction IN OUT NOCOPY
1034: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1035: )
1036: IS
1037: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1038: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Commodity_Info';
1039:
1040: CURSOR l_com
1041: IS
1104: --=========================================================================
1105:
1106: PROCEDURE Get_Order_Number
1107: ( x_movement_transaction IN OUT NOCOPY
1108: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1109: )
1110: IS
1111: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1112: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Order_Number';
1107: ( x_movement_transaction IN OUT NOCOPY
1108: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1109: )
1110: IS
1111: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1112: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Order_Number';
1113:
1114: CURSOR l_on
1115: IS
1576: --=========================================================================
1577:
1578: PROCEDURE Get_Vendor_Info
1579: ( x_movement_transaction IN OUT NOCOPY
1580: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1581: )
1582: IS
1583: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1584:
1579: ( x_movement_transaction IN OUT NOCOPY
1580: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1581: )
1582: IS
1583: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1584:
1585: CURSOR l_ven
1586: IS
1587: SELECT