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;
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: )
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
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
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;
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;
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;
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;
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
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;
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;
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);
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
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;
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
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
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
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;
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)