APPS.INV_MGD_MVT_STATS_PROC dependencies on INV_MGD_MVT_DATA_STR

Line 70: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

66: -- legal entity where the RMA is booked
67: --========================================================================
68:
69: PROCEDURE Process_RMA_Triangulation
70: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
71: , p_stat_typ_transaction IN INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
72: , x_return_status OUT NOCOPY VARCHAR2
73: )
74: IS

Line 71: , p_stat_typ_transaction IN INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

67: --========================================================================
68:
69: PROCEDURE Process_RMA_Triangulation
70: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
71: , p_stat_typ_transaction IN INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
72: , x_return_status OUT NOCOPY VARCHAR2
73: )
74: IS
75: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 75: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

71: , p_stat_typ_transaction IN INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
72: , x_return_status OUT NOCOPY VARCHAR2
73: )
74: IS
75: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
76: l_api_name CONSTANT VARCHAR2(30) := 'Process_RMA_Triangulation';
77: l_error VARCHAR2(600);
78: x_msg_count NUMBER;
79: x_msg_data VARCHAR2(2000);

Line 81: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

77: l_error VARCHAR2(600);
78: x_msg_count NUMBER;
79: x_msg_data VARCHAR2(2000);
80: l_insert_status VARCHAR2(10);
81: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
82: l_return_status VARCHAR2(1);
83: BEGIN
84: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
85: THEN

Line 256: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

252: IS
253: l_return_status VARCHAR2(1);
254: l_msg_count NUMBER;
255: l_msg_data VARCHAR2(100);
256: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
257: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
258: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transaction';
259: l_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.Value('AFLOG_ENABLED'),'N');
260: l_error VARCHAR2(600);

Line 257: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

253: l_return_status VARCHAR2(1);
254: l_msg_count NUMBER;
255: l_msg_data VARCHAR2(100);
256: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
257: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
258: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transaction';
259: l_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.Value('AFLOG_ENABLED'),'N');
260: l_error VARCHAR2(600);
261: BEGIN

Line 626: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

622: -- table.
623: --========================================================================
624:
625: PROCEDURE Process_Transaction
626: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
627: )
628: IS
629: l_return_status VARCHAR2(1);
630: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 630: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

626: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
627: )
628: IS
629: l_return_status VARCHAR2(1);
630: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
631: l_msg_count NUMBER;
632: l_msg_data VARCHAR2(100);
633: l_api_name CONSTANT VARCHAR2(300) := 'Process_Transaction (OVERLOADED)';
634: BEGIN

Line 726: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

722: -- date range.
723: --========================================================================
724:
725: PROCEDURE Process_INV_Transaction
726: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
727: , p_start_date IN DATE
728: , p_end_date IN DATE
729: , p_transaction_type IN VARCHAR2
730: , x_return_status OUT NOCOPY VARCHAR2

Line 733: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

729: , p_transaction_type IN VARCHAR2
730: , x_return_status OUT NOCOPY VARCHAR2
731: )
732: IS
733: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
734: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 734: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

730: , x_return_status OUT NOCOPY VARCHAR2
731: )
732: IS
733: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
734: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
738: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

731: )
732: IS
733: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
734: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
738: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
739: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;

732: IS
733: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
734: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
738: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
739: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
740: x_msg_count NUMBER;

Line 737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

733: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
734: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
738: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
739: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
740: x_msg_count NUMBER;
741: x_msg_data VARCHAR2(2000);

Line 738: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

734: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
738: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
739: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
740: x_msg_count NUMBER;
741: x_msg_data VARCHAR2(2000);
742: l_insert_flag VARCHAR2(1);

Line 739: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

735: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
736: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
737: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
738: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
739: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
740: x_msg_count NUMBER;
741: x_msg_data VARCHAR2(2000);
742: l_insert_flag VARCHAR2(1);
743: l_insert_status VARCHAR2(10);

Line 1105: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1101: --========================================================================
1102:
1103: PROCEDURE Process_SO_Transaction
1104: ( p_movement_transaction IN
1105: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1106: , p_start_date IN DATE
1107: , p_end_date IN DATE
1108: , p_transaction_type IN VARCHAR2
1109: , x_return_status OUT NOCOPY VARCHAR2

Line 1114: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;

1110: )
1111: IS
1112: l_api_name CONSTANT VARCHAR2(30) := 'Process_SO_Transaction';
1113: l_error VARCHAR2(600);
1114: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1115: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 1115: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1111: IS
1112: l_api_name CONSTANT VARCHAR2(30) := 'Process_SO_Transaction';
1113: l_error VARCHAR2(600);
1114: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1115: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1119: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

1112: l_api_name CONSTANT VARCHAR2(30) := 'Process_SO_Transaction';
1113: l_error VARCHAR2(600);
1114: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1115: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1119: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1120: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1113: l_error VARCHAR2(600);
1114: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1115: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1119: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1120: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1121: l_insert_flag VARCHAR2(1);

Line 1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1114: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1115: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1119: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1120: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1121: l_insert_flag VARCHAR2(1);
1122: x_msg_count NUMBER;

Line 1119: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1115: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1119: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1120: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1121: l_insert_flag VARCHAR2(1);
1122: x_msg_count NUMBER;
1123: x_msg_data VARCHAR2(2000);

Line 1120: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1116: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1117: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1118: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1119: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1120: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1121: l_insert_flag VARCHAR2(1);
1122: x_msg_count NUMBER;
1123: x_msg_data VARCHAR2(2000);
1124: l_so_le_id NUMBER;

Line 1692: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1688: --========================================================================
1689:
1690: PROCEDURE Process_Triangulation_Txn
1691: ( p_movement_transaction IN
1692: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1693: , p_start_date IN DATE
1694: , p_end_date IN DATE
1695: , p_transaction_type IN VARCHAR2
1696: , x_return_status OUT NOCOPY VARCHAR2

Line 1701: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;

1697: )
1698: IS
1699: l_api_name CONSTANT VARCHAR2(30) := 'Process_Triangulation_Txn';
1700: l_error VARCHAR2(600);
1701: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1702: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

Line 1702: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1698: IS
1699: l_api_name CONSTANT VARCHAR2(30) := 'Process_Triangulation_Txn';
1700: l_error VARCHAR2(600);
1701: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1702: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1699: l_api_name CONSTANT VARCHAR2(30) := 'Process_Triangulation_Txn';
1700: l_error VARCHAR2(600);
1701: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1702: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1700: l_error VARCHAR2(600);
1701: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1702: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1708: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

1701: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1702: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1708: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1709: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1702: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1708: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1709: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1710: l_insert_flag VARCHAR2(1);

Line 1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1703: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1708: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1709: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1710: l_insert_flag VARCHAR2(1);
1711: x_msg_count NUMBER;

Line 1708: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1704: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1708: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1709: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1710: l_insert_flag VARCHAR2(1);
1711: x_msg_count NUMBER;
1712: x_msg_data VARCHAR2(2000);

Line 1709: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1705: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1706: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1707: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1708: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1709: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1710: l_insert_flag VARCHAR2(1);
1711: x_msg_count NUMBER;
1712: x_msg_data VARCHAR2(2000);
1713: l_insert_status VARCHAR2(10);

Line 2454: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

2450: --========================================================================
2451:
2452: PROCEDURE Process_IO_Arrival_Txn
2453: ( p_movement_transaction IN
2454: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2455: , p_start_date IN DATE
2456: , p_end_date IN DATE
2457: , p_transaction_type IN VARCHAR2
2458: , x_return_status OUT NOCOPY VARCHAR2

Line 2462: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;

2458: , x_return_status OUT NOCOPY VARCHAR2
2459: )
2460: IS
2461: -- Declare the REF Cursor
2462: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2463: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 2463: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

2459: )
2460: IS
2461: -- Declare the REF Cursor
2462: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2463: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2467: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

2460: IS
2461: -- Declare the REF Cursor
2462: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2463: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2467: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2468: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

2461: -- Declare the REF Cursor
2462: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2463: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2467: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2468: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2469: l_insert_flag VARCHAR2(1);

Line 2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

2462: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2463: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2467: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2468: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2469: l_insert_flag VARCHAR2(1);
2470: x_msg_count NUMBER;

Line 2467: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

2463: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2467: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2468: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2469: l_insert_flag VARCHAR2(1);
2470: x_msg_count NUMBER;
2471: x_msg_data VARCHAR2(2000);

Line 2468: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

2464: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2465: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2466: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2467: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2468: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2469: l_insert_flag VARCHAR2(1);
2470: x_msg_count NUMBER;
2471: x_msg_data VARCHAR2(2000);
2472: l_insert_status VARCHAR2(10);

Line 2914: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

2910: -- the parent PO is closed
2911: --=========================================================================
2912: PROCEDURE Update_PO_With_RTV
2913: ( x_mvt_rtv_transaction IN OUT NOCOPY
2914: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2915: , x_return_status OUT NOCOPY VARCHAR2
2916: )
2917: IS
2918: l_parent_mvt_id NUMBER;

Line 2920: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

2916: )
2917: IS
2918: l_parent_mvt_id NUMBER;
2919: l_parent_mvt_status VARCHAR2(30);
2920: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2921: x_msg_count NUMBER;
2922: x_msg_data VARCHAR2(2000);
2923: l_return_status VARCHAR2(1);
2924: l_api_name CONSTANT VARCHAR2(30) := 'Update_PO_With_RTV';

Line 3428: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

3424: -- date range.
3425: --========================================================================
3426:
3427: PROCEDURE Process_PO_Transaction
3428: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
3429: , p_start_date IN DATE
3430: , p_end_date IN DATE
3431: , p_transaction_type IN VARCHAR2
3432: , x_return_status OUT NOCOPY VARCHAR2

Line 3436: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;

3432: , x_return_status OUT NOCOPY VARCHAR2
3433: )
3434: IS
3435: -- Declare the REF Cursor
3436: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3437: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

Line 3437: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;

3433: )
3434: IS
3435: -- Declare the REF Cursor
3436: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3437: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

3434: IS
3435: -- Declare the REF Cursor
3436: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3437: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

3435: -- Declare the REF Cursor
3436: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3437: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3443: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

3436: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3437: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3443: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3444: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

3437: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3443: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3444: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3445: x_msg_count NUMBER;

Line 3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

3438: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3443: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3444: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3445: x_msg_count NUMBER;
3446: x_msg_data VARCHAR2(2000);

Line 3443: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

3439: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3443: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3444: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3445: x_msg_count NUMBER;
3446: x_msg_data VARCHAR2(2000);
3447: l_insert_flag VARCHAR2(1);

Line 3444: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

3440: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3441: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3442: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3443: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3444: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3445: x_msg_count NUMBER;
3446: x_msg_data VARCHAR2(2000);
3447: l_insert_flag VARCHAR2(1);
3448: l_vendor_site_id NUMBER;

Line 4345: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

4341: -- the parent SO is closed
4342: --=========================================================================
4343: PROCEDURE Update_SO_With_RMA
4344: ( x_mvt_rma_transaction IN OUT NOCOPY
4345: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4346: , x_return_status OUT NOCOPY VARCHAR2
4347: )
4348: IS
4349: l_parent_mvt_id NUMBER;

Line 4351: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4347: )
4348: IS
4349: l_parent_mvt_id NUMBER;
4350: l_parent_mvt_status VARCHAR2(30);
4351: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4352: x_msg_count NUMBER;
4353: x_msg_data VARCHAR2(2000);
4354: l_return_status VARCHAR2(1);
4355: l_api_name CONSTANT VARCHAR2(30) := 'Update_SO_With_RMA';

Line 4859: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

4855: -- date range.
4856: --========================================================================
4857:
4858: PROCEDURE Process_RMA_Transaction
4859: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4860: , p_start_date IN DATE
4861: , p_end_date IN DATE
4862: , p_transaction_type IN VARCHAR2
4863: , x_return_status OUT NOCOPY VARCHAR2

Line 4867: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;

4863: , x_return_status OUT NOCOPY VARCHAR2
4864: )
4865: IS
4866: -- Declare the REF Cursor
4867: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4868: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 4868: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

4864: )
4865: IS
4866: -- Declare the REF Cursor
4867: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4868: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

4865: IS
4866: -- Declare the REF Cursor
4867: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4868: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4873: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

4866: -- Declare the REF Cursor
4867: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4868: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4873: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4874: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4867: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4868: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4873: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4874: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4875: x_msg_count NUMBER;

Line 4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4868: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4873: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4874: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4875: x_msg_count NUMBER;
4876: x_msg_data VARCHAR2(2000);

Line 4873: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4869: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4873: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4874: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4875: x_msg_count NUMBER;
4876: x_msg_data VARCHAR2(2000);
4877: l_insert_flag VARCHAR2(1);

Line 4874: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

4870: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4871: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4872: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4873: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4874: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4875: x_msg_count NUMBER;
4876: x_msg_data VARCHAR2(2000);
4877: l_insert_flag VARCHAR2(1);
4878: l_vendor_site_id NUMBER;

Line 5774: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

5770: --========================================================================
5771:
5772: PROCEDURE Update_Invoice_Info
5773: ( p_movement_transaction IN
5774: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
5775: , p_start_date IN DATE
5776: , p_end_date IN DATE
5777: , p_transaction_type IN VARCHAR2
5778: , x_return_status OUT NOCOPY VARCHAR2

Line 5782: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

5778: , x_return_status OUT NOCOPY VARCHAR2
5779: )
5780: IS
5781: -- Declare the REF Cursor
5782: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5783: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5784: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5785: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5786: l_insert_flag VARCHAR2(1);

Line 5783: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

5779: )
5780: IS
5781: -- Declare the REF Cursor
5782: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5783: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5784: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5785: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5786: l_insert_flag VARCHAR2(1);
5787: x_msg_count NUMBER;

Line 5784: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

5780: IS
5781: -- Declare the REF Cursor
5782: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5783: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5784: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5785: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5786: l_insert_flag VARCHAR2(1);
5787: x_msg_count NUMBER;
5788: x_msg_data VARCHAR2(2000);

Line 5785: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

5781: -- Declare the REF Cursor
5782: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5783: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5784: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5785: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5786: l_insert_flag VARCHAR2(1);
5787: x_msg_count NUMBER;
5788: x_msg_data VARCHAR2(2000);
5789: l_insert_status VARCHAR2(10);

Line 6136: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

6132: , x_return_status OUT NOCOPY VARCHAR2
6133: )
6134: IS
6135: -- Declare the REF Cursor
6136: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
6137: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
6138: x_msg_count NUMBER;
6139: x_msg_data VARCHAR2(2000);
6140: l_correct_qty NUMBER;

Line 6137: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

6133: )
6134: IS
6135: -- Declare the REF Cursor
6136: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
6137: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
6138: x_msg_count NUMBER;
6139: x_msg_data VARCHAR2(2000);
6140: l_correct_qty NUMBER;
6141: l_correct_parimary_qty NUMBER;

Line 6499: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

6495: --========================================================================
6496:
6497: PROCEDURE Process_Pending_Transaction
6498: ( p_movement_transaction IN
6499: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
6500: , p_start_date IN DATE
6501: , p_end_date IN DATE
6502: , p_transaction_type IN VARCHAR2
6503: , x_return_status OUT NOCOPY VARCHAR2

Line 6507: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

6503: , x_return_status OUT NOCOPY VARCHAR2
6504: )
6505: IS
6506: -- Declare the REF Cursor
6507: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
6508: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6509: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6510: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
6511: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 6508: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

6504: )
6505: IS
6506: -- Declare the REF Cursor
6507: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
6508: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6509: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6510: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
6511: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
6512: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 6509: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

6505: IS
6506: -- Declare the REF Cursor
6507: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
6508: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6509: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6510: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
6511: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
6512: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
6513: l_insert_flag VARCHAR2(1);

Line 6510: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;

6506: -- Declare the REF Cursor
6507: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
6508: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6509: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6510: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
6511: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
6512: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
6513: l_insert_flag VARCHAR2(1);
6514: x_msg_count NUMBER;

Line 6511: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

6507: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
6508: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6509: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6510: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
6511: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
6512: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
6513: l_insert_flag VARCHAR2(1);
6514: x_msg_count NUMBER;
6515: x_msg_data VARCHAR2(2000);

Line 6512: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

6508: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6509: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
6510: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
6511: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
6512: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
6513: l_insert_flag VARCHAR2(1);
6514: x_msg_count NUMBER;
6515: x_msg_data VARCHAR2(2000);
6516: l_insert_status VARCHAR2(10);