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 863: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

859: -- x_total_invoiced_qty OUT total invoiced qty for this order
860: -- COMMENT : Procedure to calcualte total line level charge
861: -- ========================================================================
862: PROCEDURE Calc_Total_Line_Charge
863: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
864: , x_this_line_charge OUT NOCOPY NUMBER
865: , x_total_line_charge OUT NOCOPY NUMBER
866: , x_total_invoiced_qty OUT NOCOPY NUMBER
867: )

Line 1015: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1011: -- COMMENT : Procedure to calcualte processed invoice amount and quantity
1012: -- for RTV and RMA
1013: -- ========================================================================
1014: PROCEDURE Calc_Processed_Ret_Data
1015: ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1016: , x_processed_ret_amt OUT NOCOPY NUMBER
1017: , x_processed_ret_qty OUT NOCOPY NUMBER
1018: )
1019: IS

Line 1335: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1331: --=======================================================================
1332:
1333: PROCEDURE Calc_Exchange_Rate
1334: ( x_movement_transaction IN OUT NOCOPY
1335: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1336: , p_stat_typ_transaction IN
1337: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1338: )
1339: IS

Line 1337: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

1333: PROCEDURE Calc_Exchange_Rate
1334: ( x_movement_transaction IN OUT NOCOPY
1335: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1336: , p_stat_typ_transaction IN
1337: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1338: )
1339: IS
1340: l_gl_set_of_books_id VARCHAR2(15);
1341: l_last_dayofperiod DATE;

Line 1447: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1443: --=======================================================================
1444:
1445: FUNCTION Calc_Movement_Amount
1446: ( p_movement_transaction IN
1447: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1448: )
1449: RETURN NUMBER
1450: IS
1451: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 1451: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

1447: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1448: )
1449: RETURN NUMBER
1450: IS
1451: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1452: l_report_price NUMBER;
1453: l_tr_value NUMBER;
1454: l_inv_uom VARCHAR2(10);
1455: l_trans_conv_inv_rate NUMBER;

Line 1890: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

1886: --=======================================================================
1887:
1888: FUNCTION Calc_Statistics_Value
1889: ( p_movement_transaction IN
1890: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1891: )
1892: RETURN NUMBER
1893: IS
1894: l_stat_value NUMBER;

Line 2082: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

2078: -- invoice information to the Movement Statistics table.
2079: -- ========================================================================
2080: PROCEDURE Calc_Invoice_Info
2081: ( p_stat_typ_transaction IN
2082: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
2083: , x_movement_transaction IN OUT NOCOPY
2084: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2085: )
2086: IS

Line 2084: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

2080: PROCEDURE Calc_Invoice_Info
2081: ( p_stat_typ_transaction IN
2082: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
2083: , x_movement_transaction IN OUT NOCOPY
2084: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2085: )
2086: IS
2087: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2088: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

Line 2087: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

2083: , x_movement_transaction IN OUT NOCOPY
2084: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2085: )
2086: IS
2087: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2088: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2089: l_unit_price NUMBER;
2090: l_invoice_quantity NUMBER;
2091: l_rtv_invoice_quantity NUMBER :=0;

Line 2088: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

2084: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
2085: )
2086: IS
2087: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
2088: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2089: l_unit_price NUMBER;
2090: l_invoice_quantity NUMBER;
2091: l_rtv_invoice_quantity NUMBER :=0;
2092: l_tran_curr_code VARCHAR2(15);

Line 4603: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

4599: --=========================================================================
4600:
4601: FUNCTION Get_Period_Name
4602: ( p_movement_transaction IN
4603: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4604: , p_stat_typ_transaction IN
4605: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
4606: )
4607: RETURN VARCHAR2

Line 4605: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

4601: FUNCTION Get_Period_Name
4602: ( p_movement_transaction IN
4603: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4604: , p_stat_typ_transaction IN
4605: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
4606: )
4607: RETURN VARCHAR2
4608: IS
4609: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

Line 4609: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

4605: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
4606: )
4607: RETURN VARCHAR2
4608: IS
4609: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4610: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4611: l_function_name CONSTANT VARCHAR2(30) := 'Get_Period_Name';
4612:
4613: CURSOR c_period IS

Line 4610: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;

4606: )
4607: RETURN VARCHAR2
4608: IS
4609: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4610: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
4611: l_function_name CONSTANT VARCHAR2(30) := 'Get_Period_Name';
4612:
4613: CURSOR c_period IS
4614: SELECT

Line 4708: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type

4704: --=========================================================================
4705:
4706: PROCEDURE Get_Reference_Date
4707: ( p_stat_typ_transaction IN
4708: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
4709: , x_movement_transaction IN OUT NOCOPY
4710: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4711: )
4712: IS

Line 4710: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

4706: PROCEDURE Get_Reference_Date
4707: ( p_stat_typ_transaction IN
4708: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
4709: , x_movement_transaction IN OUT NOCOPY
4710: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
4711: )
4712: IS
4713: l_transaction_date DATE;
4714: l_invoice_date DATE;

Line 4718: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;

4714: l_invoice_date DATE;
4715: l_pending_date DATE;
4716: l_months NUMBER;
4717: l_no_days NUMBER;
4718: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
4719: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Reference_Date';
4720:
4721: BEGIN
4722: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)