DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on INV_MGD_MVT_DATA_STR

Line 72: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

68:
69: Function Get_Conversion_Rate
70: ( p_invoice_currency_code VARCHAR2
71: , p_movement_transaction IN
72: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
73: )
74: RETURN NUMBER IS
75: l_gl_set_of_books_id VARCHAR2(15);
76: l_last_dayofperiod DATE;

Line 830: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

826: -- x_total_invoiced_qty OUT total invoiced qty for this order
827: -- COMMENT : Procedure to calcualte total line level charge
828: -- ========================================================================
829: PROCEDURE Calc_Total_Line_Charge
830: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
831: , x_this_line_charge OUT NOCOPY NUMBER
832: , x_total_line_charge OUT NOCOPY NUMBER
833: , x_total_invoiced_qty OUT NOCOPY NUMBER
834: )

Line 982: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

978: -- COMMENT : Procedure to calcualte processed invoice amount and quantity
979: -- for RTV and RMA
980: -- ========================================================================
981: PROCEDURE Calc_Processed_Ret_Data
982: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
983: , x_processed_ret_amt OUT NOCOPY NUMBER
984: , x_processed_ret_qty OUT NOCOPY NUMBER
985: )
986: IS

Line 1302: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1298: --=======================================================================
1299:
1300: PROCEDURE Calc_Exchange_Rate
1301: ( x_movement_transaction IN OUT NOCOPY
1302: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1303: , p_stat_typ_transaction IN
1304: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1305: )
1306: IS

Line 1304: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

1300: PROCEDURE Calc_Exchange_Rate
1301: ( x_movement_transaction IN OUT NOCOPY
1302: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1303: , p_stat_typ_transaction IN
1304: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1305: )
1306: IS
1307: l_gl_set_of_books_id VARCHAR2(15);
1308: l_last_dayofperiod DATE;

Line 1414: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1410: --=======================================================================
1411:
1412: FUNCTION Calc_Movement_Amount
1413: ( p_movement_transaction IN
1414: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1415: )
1416: RETURN NUMBER
1417: IS
1418: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 1418: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1414: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1415: )
1416: RETURN NUMBER
1417: IS
1418: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1419: l_report_price NUMBER;
1420: l_tr_value NUMBER;
1421: l_inv_uom VARCHAR2(10);
1422: l_trans_conv_inv_rate NUMBER;

Line 1771: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1767: --=======================================================================
1768:
1769: FUNCTION Calc_Statistics_Value
1770: ( p_movement_transaction IN
1771: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1772: )
1773: RETURN NUMBER
1774: IS
1775: l_stat_value NUMBER;

Line 1963: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

1959: -- invoice information to the Movement Statistics table.
1960: -- ========================================================================
1961: PROCEDURE Calc_Invoice_Info
1962: ( p_stat_typ_transaction IN
1963: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1964: , x_movement_transaction IN OUT NOCOPY
1965: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1966: )
1967: IS

Line 1965: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1961: PROCEDURE Calc_Invoice_Info
1962: ( p_stat_typ_transaction IN
1963: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1964: , x_movement_transaction IN OUT NOCOPY
1965: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1966: )
1967: IS
1968: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1969: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 1968: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

1964: , x_movement_transaction IN OUT NOCOPY
1965: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1966: )
1967: IS
1968: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1969: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1970: l_unit_price NUMBER;
1971: l_invoice_quantity NUMBER;
1972: l_rtv_invoice_quantity NUMBER :=0;

Line 1969: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1965: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1966: )
1967: IS
1968: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1969: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1970: l_unit_price NUMBER;
1971: l_invoice_quantity NUMBER;
1972: l_rtv_invoice_quantity NUMBER :=0;
1973: l_tran_curr_code VARCHAR2(15);

Line 3764: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

3760: --=========================================================================
3761:
3762: FUNCTION Get_Period_Name
3763: ( p_movement_transaction IN
3764: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
3765: , p_stat_typ_transaction IN
3766: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
3767: )
3768: RETURN VARCHAR2

Line 3766: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

3762: FUNCTION Get_Period_Name
3763: ( p_movement_transaction IN
3764: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
3765: , p_stat_typ_transaction IN
3766: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
3767: )
3768: RETURN VARCHAR2
3769: IS
3770: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 3770: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

3766: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
3767: )
3768: RETURN VARCHAR2
3769: IS
3770: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3771: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3772: l_function_name CONSTANT VARCHAR2(30) := 'Get_Period_Name';
3773:
3774: CURSOR c_period IS

Line 3771: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

3767: )
3768: RETURN VARCHAR2
3769: IS
3770: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3771: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
3772: l_function_name CONSTANT VARCHAR2(30) := 'Get_Period_Name';
3773:
3774: CURSOR c_period IS
3775: SELECT

Line 3869: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

3865: --=========================================================================
3866:
3867: PROCEDURE Get_Reference_Date
3868: ( p_stat_typ_transaction IN
3869: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
3870: , x_movement_transaction IN OUT NOCOPY
3871: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
3872: )
3873: IS

Line 3871: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

3867: PROCEDURE Get_Reference_Date
3868: ( p_stat_typ_transaction IN
3869: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
3870: , x_movement_transaction IN OUT NOCOPY
3871: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
3872: )
3873: IS
3874: l_transaction_date DATE;
3875: l_invoice_date DATE;

Line 3879: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

3875: l_invoice_date DATE;
3876: l_pending_date DATE;
3877: l_months NUMBER;
3878: l_no_days NUMBER;
3879: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
3880: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Reference_Date';
3881:
3882: BEGIN
3883: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)