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 237: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

233: IS
234: l_return_status VARCHAR2(1);
235: l_msg_count NUMBER;
236: l_msg_data VARCHAR2(100);
237: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
238: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
239: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transaction';
240: l_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.Value('AFLOG_ENABLED'),'N');
241: l_error VARCHAR2(600);

Line 238: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

234: l_return_status VARCHAR2(1);
235: l_msg_count NUMBER;
236: l_msg_data VARCHAR2(100);
237: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
238: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
239: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transaction';
240: l_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.Value('AFLOG_ENABLED'),'N');
241: l_error VARCHAR2(600);
242: BEGIN

Line 578: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

574: -- table.
575: --========================================================================
576:
577: PROCEDURE Process_Transaction
578: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
579: )
580: IS
581: l_return_status VARCHAR2(1);
582: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 582: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

578: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
579: )
580: IS
581: l_return_status VARCHAR2(1);
582: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
583: l_msg_count NUMBER;
584: l_msg_data VARCHAR2(100);
585: l_api_name CONSTANT VARCHAR2(300) := 'Process_Transaction (OVERLOADED)';
586: BEGIN

Line 678: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

674: -- date range.
675: --========================================================================
676:
677: PROCEDURE Process_INV_Transaction
678: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
679: , p_start_date IN DATE
680: , p_end_date IN DATE
681: , p_transaction_type IN VARCHAR2
682: , x_return_status OUT NOCOPY VARCHAR2

Line 685: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

681: , p_transaction_type IN VARCHAR2
682: , x_return_status OUT NOCOPY VARCHAR2
683: )
684: IS
685: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
686: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 686: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

682: , x_return_status OUT NOCOPY VARCHAR2
683: )
684: IS
685: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
686: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
690: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

683: )
684: IS
685: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
686: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
690: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
691: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;

684: IS
685: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
686: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
690: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
691: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
692: x_msg_count NUMBER;

Line 689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

685: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
686: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
690: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
691: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
692: x_msg_count NUMBER;
693: x_msg_data VARCHAR2(2000);

Line 690: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

686: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
690: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
691: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
692: x_msg_count NUMBER;
693: x_msg_data VARCHAR2(2000);
694: l_insert_flag VARCHAR2(1);

Line 691: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

687: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
688: l_material_transaction INV_MGD_MVT_DATA_STR.Material_Transaction_Rec_Type;
689: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
690: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
691: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
692: x_msg_count NUMBER;
693: x_msg_data VARCHAR2(2000);
694: l_insert_flag VARCHAR2(1);
695: l_insert_status VARCHAR2(10);

Line 1048: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1044: --========================================================================
1045:
1046: PROCEDURE Process_SO_Transaction
1047: ( p_movement_transaction IN
1048: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1049: , p_start_date IN DATE
1050: , p_end_date IN DATE
1051: , p_transaction_type IN VARCHAR2
1052: , x_return_status OUT NOCOPY VARCHAR2

Line 1057: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;

1053: )
1054: IS
1055: l_api_name CONSTANT VARCHAR2(30) := 'Process_SO_Transaction';
1056: l_error VARCHAR2(600);
1057: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1058: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 1058: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1054: IS
1055: l_api_name CONSTANT VARCHAR2(30) := 'Process_SO_Transaction';
1056: l_error VARCHAR2(600);
1057: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1058: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1062: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

1055: l_api_name CONSTANT VARCHAR2(30) := 'Process_SO_Transaction';
1056: l_error VARCHAR2(600);
1057: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1058: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1062: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1063: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1056: l_error VARCHAR2(600);
1057: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1058: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1062: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1063: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1064: l_insert_flag VARCHAR2(1);

Line 1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1057: so_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1058: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1062: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1063: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1064: l_insert_flag VARCHAR2(1);
1065: x_msg_count NUMBER;

Line 1062: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1058: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1062: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1063: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1064: l_insert_flag VARCHAR2(1);
1065: x_msg_count NUMBER;
1066: x_msg_data VARCHAR2(2000);

Line 1063: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1059: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1060: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1061: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1062: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1063: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1064: l_insert_flag VARCHAR2(1);
1065: x_msg_count NUMBER;
1066: x_msg_data VARCHAR2(2000);
1067: l_so_le_id NUMBER;

Line 1613: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1609: --========================================================================
1610:
1611: PROCEDURE Process_Triangulation_Txn
1612: ( p_movement_transaction IN
1613: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1614: , p_start_date IN DATE
1615: , p_end_date IN DATE
1616: , p_transaction_type IN VARCHAR2
1617: , x_return_status OUT NOCOPY VARCHAR2

Line 1622: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;

1618: )
1619: IS
1620: l_api_name CONSTANT VARCHAR2(30) := 'Process_Triangulation_Txn';
1621: l_error VARCHAR2(600);
1622: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1623: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

Line 1623: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1619: IS
1620: l_api_name CONSTANT VARCHAR2(30) := 'Process_Triangulation_Txn';
1621: l_error VARCHAR2(600);
1622: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1623: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1620: l_api_name CONSTANT VARCHAR2(30) := 'Process_Triangulation_Txn';
1621: l_error VARCHAR2(600);
1622: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1623: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1621: l_error VARCHAR2(600);
1622: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1623: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1629: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

1622: sot_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
1623: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1629: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1630: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1623: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1629: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1630: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1631: l_insert_flag VARCHAR2(1);

Line 1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1624: l_movement_transaction2 INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1629: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1630: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1631: l_insert_flag VARCHAR2(1);
1632: x_msg_count NUMBER;

Line 1629: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1625: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1629: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1630: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1631: l_insert_flag VARCHAR2(1);
1632: x_msg_count NUMBER;
1633: x_msg_data VARCHAR2(2000);

Line 1630: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

1626: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1627: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1628: l_stat_typ_transaction2 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1629: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1630: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
1631: l_insert_flag VARCHAR2(1);
1632: x_msg_count NUMBER;
1633: x_msg_data VARCHAR2(2000);
1634: l_insert_status VARCHAR2(10);

Line 2256: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

2252: --========================================================================
2253:
2254: PROCEDURE Process_IO_Arrival_Txn
2255: ( p_movement_transaction IN
2256: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2257: , p_start_date IN DATE
2258: , p_end_date IN DATE
2259: , p_transaction_type IN VARCHAR2
2260: , x_return_status OUT NOCOPY VARCHAR2

Line 2264: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;

2260: , x_return_status OUT NOCOPY VARCHAR2
2261: )
2262: IS
2263: -- Declare the REF Cursor
2264: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2265: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 2265: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

2261: )
2262: IS
2263: -- Declare the REF Cursor
2264: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2265: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2269: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

2262: IS
2263: -- Declare the REF Cursor
2264: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2265: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2269: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2270: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

Line 2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;

2263: -- Declare the REF Cursor
2264: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2265: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2269: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2270: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2271: l_insert_flag VARCHAR2(1);

Line 2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

2264: io_arrival_crsr INV_MGD_MVT_DATA_STR.soCurTyp;
2265: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2269: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2270: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2271: l_insert_flag VARCHAR2(1);
2272: x_msg_count NUMBER;

Line 2269: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

2265: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2269: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2270: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2271: l_insert_flag VARCHAR2(1);
2272: x_msg_count NUMBER;
2273: x_msg_data VARCHAR2(2000);

Line 2270: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

2266: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2267: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
2268: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2269: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2270: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
2271: l_insert_flag VARCHAR2(1);
2272: x_msg_count NUMBER;
2273: x_msg_data VARCHAR2(2000);
2274: l_insert_status VARCHAR2(10);

Line 2606: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

2602: -- the parent PO is closed
2603: --=========================================================================
2604: PROCEDURE Update_PO_With_RTV
2605: ( x_mvt_rtv_transaction IN OUT NOCOPY
2606: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2607: , x_return_status OUT NOCOPY VARCHAR2
2608: )
2609: IS
2610: l_parent_mvt_id NUMBER;

Line 2612: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

2608: )
2609: IS
2610: l_parent_mvt_id NUMBER;
2611: l_parent_mvt_status VARCHAR2(30);
2612: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2613: x_msg_count NUMBER;
2614: x_msg_data VARCHAR2(2000);
2615: l_return_status VARCHAR2(1);
2616: l_api_name CONSTANT VARCHAR2(30) := 'Update_PO_With_RTV';

Line 3120: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

3116: -- date range.
3117: --========================================================================
3118:
3119: PROCEDURE Process_PO_Transaction
3120: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
3121: , p_start_date IN DATE
3122: , p_end_date IN DATE
3123: , p_transaction_type IN VARCHAR2
3124: , x_return_status OUT NOCOPY VARCHAR2

Line 3128: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;

3124: , x_return_status OUT NOCOPY VARCHAR2
3125: )
3126: IS
3127: -- Declare the REF Cursor
3128: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3129: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

Line 3129: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;

3125: )
3126: IS
3127: -- Declare the REF Cursor
3128: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3129: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

3126: IS
3127: -- Declare the REF Cursor
3128: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3129: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

3127: -- Declare the REF Cursor
3128: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3129: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3135: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

3128: po_crsr INV_MGD_MVT_DATA_STR.poCurTyp;
3129: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3135: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3136: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

3129: rtv_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3135: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3136: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3137: x_msg_count NUMBER;

Line 3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

3130: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3135: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3136: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3137: x_msg_count NUMBER;
3138: x_msg_data VARCHAR2(2000);

Line 3135: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

3131: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3135: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3136: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3137: x_msg_count NUMBER;
3138: x_msg_data VARCHAR2(2000);
3139: l_insert_flag VARCHAR2(1);

Line 3136: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

3132: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
3133: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3134: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3135: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3136: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3137: x_msg_count NUMBER;
3138: x_msg_data VARCHAR2(2000);
3139: l_insert_flag VARCHAR2(1);
3140: l_vendor_site_id NUMBER;

Line 4002: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

3998: -- the parent SO is closed
3999: --=========================================================================
4000: PROCEDURE Update_SO_With_RMA
4001: ( x_mvt_rma_transaction IN OUT NOCOPY
4002: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4003: , x_return_status OUT NOCOPY VARCHAR2
4004: )
4005: IS
4006: l_parent_mvt_id NUMBER;

Line 4008: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4004: )
4005: IS
4006: l_parent_mvt_id NUMBER;
4007: l_parent_mvt_status VARCHAR2(30);
4008: l_parent_mvt_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4009: x_msg_count NUMBER;
4010: x_msg_data VARCHAR2(2000);
4011: l_return_status VARCHAR2(1);
4012: l_api_name CONSTANT VARCHAR2(30) := 'Update_SO_With_RMA';

Line 4516: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

4512: -- date range.
4513: --========================================================================
4514:
4515: PROCEDURE Process_RMA_Transaction
4516: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4517: , p_start_date IN DATE
4518: , p_end_date IN DATE
4519: , p_transaction_type IN VARCHAR2
4520: , x_return_status OUT NOCOPY VARCHAR2

Line 4524: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;

4520: , x_return_status OUT NOCOPY VARCHAR2
4521: )
4522: IS
4523: -- Declare the REF Cursor
4524: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4525: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 4525: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

4521: )
4522: IS
4523: -- Declare the REF Cursor
4524: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4525: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

4522: IS
4523: -- Declare the REF Cursor
4524: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4525: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4530: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;

4523: -- Declare the REF Cursor
4524: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4525: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4530: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4531: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4524: rma_crsr INV_MGD_MVT_DATA_STR.rtvCurTyp;
4525: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4530: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4531: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4532: x_msg_count NUMBER;

Line 4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4525: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4530: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4531: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4532: x_msg_count NUMBER;
4533: x_msg_data VARCHAR2(2000);

Line 4530: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4526: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4530: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4531: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4532: x_msg_count NUMBER;
4533: x_msg_data VARCHAR2(2000);
4534: l_insert_flag VARCHAR2(1);

Line 4531: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

4527: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
4528: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4529: x_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4530: l_movement_transaction_outer INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4531: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4532: x_msg_count NUMBER;
4533: x_msg_data VARCHAR2(2000);
4534: l_insert_flag VARCHAR2(1);
4535: l_vendor_site_id NUMBER;

Line 5181: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

5177: --========================================================================
5178:
5179: PROCEDURE Update_Invoice_Info
5180: ( p_movement_transaction IN
5181: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
5182: , p_start_date IN DATE
5183: , p_end_date IN DATE
5184: , p_transaction_type IN VARCHAR2
5185: , x_return_status OUT NOCOPY VARCHAR2

Line 5189: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

5185: , x_return_status OUT NOCOPY VARCHAR2
5186: )
5187: IS
5188: -- Declare the REF Cursor
5189: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5190: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5191: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5192: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5193: l_insert_flag VARCHAR2(1);

Line 5190: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

5186: )
5187: IS
5188: -- Declare the REF Cursor
5189: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5190: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5191: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5192: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5193: l_insert_flag VARCHAR2(1);
5194: x_msg_count NUMBER;

Line 5191: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

5187: IS
5188: -- Declare the REF Cursor
5189: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5190: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5191: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5192: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5193: l_insert_flag VARCHAR2(1);
5194: x_msg_count NUMBER;
5195: x_msg_data VARCHAR2(2000);

Line 5192: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

5188: -- Declare the REF Cursor
5189: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5190: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5191: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5192: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5193: l_insert_flag VARCHAR2(1);
5194: x_msg_count NUMBER;
5195: x_msg_data VARCHAR2(2000);
5196: l_insert_status VARCHAR2(10);

Line 5543: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

5539: , x_return_status OUT NOCOPY VARCHAR2
5540: )
5541: IS
5542: -- Declare the REF Cursor
5543: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5544: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5545: x_msg_count NUMBER;
5546: x_msg_data VARCHAR2(2000);
5547: l_correct_qty NUMBER;

Line 5544: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

5540: )
5541: IS
5542: -- Declare the REF Cursor
5543: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5544: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5545: x_msg_count NUMBER;
5546: x_msg_data VARCHAR2(2000);
5547: l_correct_qty NUMBER;
5548: l_correct_parimary_qty NUMBER;

Line 5906: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

5902: --========================================================================
5903:
5904: PROCEDURE Process_Pending_Transaction
5905: ( p_movement_transaction IN
5906: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
5907: , p_start_date IN DATE
5908: , p_end_date IN DATE
5909: , p_transaction_type IN VARCHAR2
5910: , x_return_status OUT NOCOPY VARCHAR2

Line 5914: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;

5910: , x_return_status OUT NOCOPY VARCHAR2
5911: )
5912: IS
5913: -- Declare the REF Cursor
5914: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5915: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5916: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5917: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
5918: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 5915: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

5911: )
5912: IS
5913: -- Declare the REF Cursor
5914: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5915: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5916: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5917: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
5918: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5919: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 5916: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;

5912: IS
5913: -- Declare the REF Cursor
5914: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5915: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5916: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5917: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
5918: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5919: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5920: l_insert_flag VARCHAR2(1);

Line 5917: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;

5913: -- Declare the REF Cursor
5914: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5915: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5916: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5917: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
5918: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5919: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5920: l_insert_flag VARCHAR2(1);
5921: x_msg_count NUMBER;

Line 5918: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

5914: inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
5915: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5916: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5917: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
5918: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5919: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5920: l_insert_flag VARCHAR2(1);
5921: x_msg_count NUMBER;
5922: x_msg_data VARCHAR2(2000);

Line 5919: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

5915: setup_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5916: ref_crsr INV_MGD_MVT_DATA_STR.setupCurTyp;
5917: mvt_crsr INV_MGD_MVT_DATA_STR.valCurTyp;
5918: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
5919: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
5920: l_insert_flag VARCHAR2(1);
5921: x_msg_count NUMBER;
5922: x_msg_data VARCHAR2(2000);
5923: l_insert_status VARCHAR2(10);