1197: THEN
1198: l_movement_transaction.order_line_id := l_link_to_line_id;
1199: END IF;
1200:
1201: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
1202: ( p_stat_typ_transaction => l_stat_typ_transaction
1203: , x_movement_transaction => l_movement_transaction
1204: );
1205:
1202: ( p_stat_typ_transaction => l_stat_typ_transaction
1203: , x_movement_transaction => l_movement_transaction
1204: );
1205:
1206: INV_MGD_MVT_FIN_MDTR. Get_Reference_Date
1207: ( p_stat_typ_transaction => l_stat_typ_transaction
1208: , x_movement_transaction => l_movement_transaction
1209: );
1210:
1811: THEN
1812: l_movement_transaction.order_line_id := l_link_to_line_id;
1813: END IF;
1814:
1815: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
1816: ( p_stat_typ_transaction => l_stat_typ_transaction
1817: , x_movement_transaction => l_movement_transaction
1818: );
1819:
1816: ( p_stat_typ_transaction => l_stat_typ_transaction
1817: , x_movement_transaction => l_movement_transaction
1818: );
1819:
1820: INV_MGD_MVT_FIN_MDTR. Get_Reference_Date
1821: ( p_stat_typ_transaction => l_stat_typ_transaction
1822: , x_movement_transaction => l_movement_transaction
1823: );
1824:
2082: -- to Transaction Date.
2083: IF NVL(l_stat_typ_transaction2.reference_period_rule,'SHIPMENT_BASED')
2084: = 'INVOICE_BASED'
2085: THEN
2086: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
2087: ( p_stat_typ_transaction => l_stat_typ_transaction2
2088: , x_movement_transaction => l_movement_transaction2
2089: );
2090: INV_MGD_MVT_FIN_MDTR.Get_Reference_Date
2086: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
2087: ( p_stat_typ_transaction => l_stat_typ_transaction2
2088: , x_movement_transaction => l_movement_transaction2
2089: );
2090: INV_MGD_MVT_FIN_MDTR.Get_Reference_Date
2091: ( p_stat_typ_transaction => l_stat_typ_transaction2
2092: , x_movement_transaction => l_movement_transaction2
2093: );
2094: l_movement_transaction2.transaction_date :=
3282: ELSE
3283: l_movement_transaction.document_source_type := 'PO';
3284: END IF;
3285:
3286: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
3287: ( p_stat_typ_transaction => l_stat_typ_transaction
3288: , x_movement_transaction => l_movement_transaction
3289: );
3290:
3287: ( p_stat_typ_transaction => l_stat_typ_transaction
3288: , x_movement_transaction => l_movement_transaction
3289: );
3290:
3291: INV_MGD_MVT_FIN_MDTR. Get_Reference_Date
3292: ( p_stat_typ_transaction => l_stat_typ_transaction
3293: , x_movement_transaction => l_movement_transaction
3294: );
3295:
4681: THEN
4682: l_movement_transaction.document_source_type := 'RMA';
4683: END IF;
4684:
4685: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
4686: ( p_stat_typ_transaction => l_stat_typ_transaction
4687: , x_movement_transaction => l_movement_transaction
4688: );
4689:
4686: ( p_stat_typ_transaction => l_stat_typ_transaction
4687: , x_movement_transaction => l_movement_transaction
4688: );
4689:
4690: INV_MGD_MVT_FIN_MDTR. Get_Reference_Date
4691: ( p_stat_typ_transaction => l_stat_typ_transaction
4692: , x_movement_transaction => l_movement_transaction
4693: );
4694:
5423: INV_MGD_MVT_PO_MDTR.Get_Blanket_Info
5424: ( x_movement_transaction => l_movement_transaction
5425: );
5426:
5427: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
5428: ( p_stat_typ_transaction => l_stat_typ_transaction
5429: , x_movement_transaction => l_movement_transaction
5430: );
5431:
5429: , x_movement_transaction => l_movement_transaction
5430: );
5431:
5432: l_movement_transaction.movement_amount :=
5433: INV_MGD_MVT_FIN_MDTR.Calc_Movement_Amount
5434: (p_movement_transaction => l_movement_transaction
5435: );
5436:
5437: --Calculate freight charge and include in statistics value
5435: );
5436:
5437: --Calculate freight charge and include in statistics value
5438: l_movement_transaction.stat_ext_value :=
5439: INV_MGD_MVT_FIN_MDTR.Calc_Statistics_Value
5440: (p_movement_transaction => l_movement_transaction);
5441:
5442: IF l_movement_transaction.invoice_id IS NOT NULL
5443: THEN
5767: l_movement_transaction.transaction_quantity);
5768:
5769: --Recalculate movement amount
5770: l_movement_transaction.movement_amount :=
5771: INV_MGD_MVT_FIN_MDTR.Calc_Movement_Amount
5772: (p_movement_transaction => l_movement_transaction);
5773:
5774: --Calculate freight charge and include in statistics value
5775: l_movement_transaction.stat_ext_value :=
5772: (p_movement_transaction => l_movement_transaction);
5773:
5774: --Calculate freight charge and include in statistics value
5775: l_movement_transaction.stat_ext_value :=
5776: INV_MGD_MVT_FIN_MDTR.Calc_Statistics_Value
5777: (p_movement_transaction => l_movement_transaction);
5778:
5779: --Fix bug 4866967 and 5203245
5780: INV_MGD_MVT_UTILS_PKG.Get_Weight_Precision
6148: INV_MGD_MVT_UTILS_PKG.Get_Order_Number
6149: ( x_movement_transaction => l_movement_transaction
6150: );
6151:
6152: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info
6153: ( p_stat_typ_transaction => l_stat_typ_transaction
6154: , x_movement_transaction => l_movement_transaction
6155: );
6156:
6158: --Only continue if the invoice is found, otherwise, everything
6159: --is same as before, no need to go through following code
6160: IF l_movement_transaction.invoice_id IS NOT NULL
6161: THEN
6162: INV_MGD_MVT_FIN_MDTR. Get_Reference_Date
6163: ( p_stat_typ_transaction => l_stat_typ_transaction
6164: , x_movement_transaction => l_movement_transaction
6165: );
6166:
6168: NVL(l_movement_transaction.reference_date,
6169: l_movement_transaction.transaction_date);
6170:
6171: l_movement_transaction.period_name :=
6172: INV_MGD_MVT_FIN_MDTR.Get_Period_Name
6173: (p_movement_transaction => l_movement_transaction
6174: ,p_stat_typ_transaction => l_stat_typ_transaction);
6175:
6176: /* Bug: 5291257. Call to function INV_MGD_MVT_FIN_MDTR.Get_Set_Of_Books_Period
6172: INV_MGD_MVT_FIN_MDTR.Get_Period_Name
6173: (p_movement_transaction => l_movement_transaction
6174: ,p_stat_typ_transaction => l_stat_typ_transaction);
6175:
6176: /* Bug: 5291257. Call to function INV_MGD_MVT_FIN_MDTR.Get_Set_Of_Books_Period
6177: is modified becasue p_period_type is no more required. */
6178: l_movement_transaction.set_of_books_period :=
6179: INV_MGD_MVT_FIN_MDTR.Get_Set_Of_Books_Period
6180: (p_legal_entity_id => l_movement_transaction.entity_org_id
6175:
6176: /* Bug: 5291257. Call to function INV_MGD_MVT_FIN_MDTR.Get_Set_Of_Books_Period
6177: is modified becasue p_period_type is no more required. */
6178: l_movement_transaction.set_of_books_period :=
6179: INV_MGD_MVT_FIN_MDTR.Get_Set_Of_Books_Period
6180: (p_legal_entity_id => l_movement_transaction.entity_org_id
6181: ,p_period_date => NVL(l_movement_transaction.invoice_date_reference,
6182: l_movement_transaction.transaction_date)
6183: --,p_period_type => NVL(l_stat_typ_transaction.period_type,'Month')
6183: --,p_period_type => NVL(l_stat_typ_transaction.period_type,'Month')
6184: );
6185:
6186: /*l_movement_transaction.currency_conversion_date :=
6187: INV_MGD_MVT_FIN_MDTR.
6188: Calc_Conversion_Date(p_movement_transaction => l_movement_transaction
6189: , p_stat_typ_transaction => l_stat_typ_transaction
6190: );
6191:
6189: , p_stat_typ_transaction => l_stat_typ_transaction
6190: );
6191:
6192: l_movement_transaction.currency_conversion_rate :=
6193: INV_MGD_MVT_FIN_MDTR.
6194: Calc_Exchange_Rate(p_movement_transaction => l_movement_transaction
6195: , p_stat_typ_transaction => l_stat_typ_transaction
6196: );
6197: */
6197: */
6198:
6199:
6200: l_movement_transaction.movement_amount :=
6201: INV_MGD_MVT_FIN_MDTR.Calc_Movement_Amount
6202: (p_movement_transaction => l_movement_transaction
6203: );
6204:
6205: --Calculate freight charge and include in statistics value
6203: );
6204:
6205: --Calculate freight charge and include in statistics value
6206: l_movement_transaction.stat_ext_value :=
6207: INV_MGD_MVT_FIN_MDTR.Calc_Statistics_Value
6208: (p_movement_transaction => l_movement_transaction);
6209:
6210: l_movement_transaction.financial_document_flag := 'PROCESSED_INCLUDED';
6211: l_movement_transaction.movement_status := 'O';