DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PROC dependencies on INV_MGD_MVT_STATS_PVT

Line 147: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

143: ':trian::' || l_movement_transaction.triangulation_country_code
144: );
145: END IF;
146:
147: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
148: (p_api_version_number => 1.0
149: ,p_init_msg_list => FND_API.G_FALSE
150: ,x_movement_transaction => l_movement_transaction
151: ,x_msg_count => x_msg_count

Line 881: INV_MGD_MVT_STATS_PVT.Init_Movement_Record

877: --the transaction is not inside of start period and end period
878: --so not create transaction
879: CLOSE ref_crsr;
880: ELSE
881: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
882: ( x_movement_transaction => l_movement_transaction);
883:
884: --Get subinventory location fix bug 2683302
885: l_subinv_terr_code :=

Line 986: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

982: INV_MGD_MVT_UTILS_PKG.Get_Org_VAT_Number
983: ( p_entity_org_id => l_movement_transaction.entity_org_id
984: , p_date => l_movement_transaction.transaction_date);
985:
986: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
987: ( p_api_version_number => 1.0
988: , p_init_msg_list => FND_API.G_FALSE
989: , x_movement_transaction => l_movement_transaction
990: , x_msg_count => x_msg_count

Line 1342: INV_MGD_MVT_STATS_PVT.Init_Movement_Record

1338: ||','||l_stat_typ_transaction.reference_period_rule
1339: ,'debug msg');
1340: END IF;
1341:
1342: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
1343: (x_movement_transaction => l_movement_transaction);
1344:
1345: --Get legal entity where this SO is created
1346: l_so_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity

Line 1545: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

1541: THEN
1542: l_movement_transaction.movement_id := null;
1543: END IF;
1544:
1545: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
1546: (p_api_version_number => 1.0
1547: ,p_init_msg_list => FND_API.G_FALSE
1548: ,x_movement_transaction => l_movement_transaction
1549: ,x_msg_count => x_msg_count

Line 1846: INV_MGD_MVT_STATS_PVT.Init_Movement_Record

1842: IF (l_shipping_le_id IS NOT NULL
1843: AND l_shipping_le_id <> l_movement_transaction.entity_org_id)
1844: THEN
1845: --Initialize movement record
1846: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
1847: (x_movement_transaction => l_movement_transaction);
1848:
1849: --Find out territory code for legal entity
1850: l_le_territory_code :=

Line 2132: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

2128: ELSE
2129: l_movement_transaction.financial_document_flag := 'PROCESSED_INCLUDED';
2130: END IF;
2131:
2132: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
2133: (p_api_version_number => 1.0
2134: ,p_init_msg_list => FND_API.G_FALSE
2135: ,x_movement_transaction => l_movement_transaction
2136: ,x_msg_count => x_msg_count

Line 2318: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

2314: ELSE
2315: l_movement_transaction2.financial_document_flag := 'PROCESSED_INCLUDED';
2316: END IF;
2317:
2318: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
2319: (p_api_version_number => 1.0
2320: ,p_init_msg_list => FND_API.G_FALSE
2321: ,x_movement_transaction => l_movement_transaction2
2322: ,x_msg_count => x_msg_count

Line 2639: INV_MGD_MVT_STATS_PVT.Init_Movement_Record

2635: ||'::ORD_LINE_ID::' || l_movement_transaction.order_line_id
2636: ,'debug msg');
2637: END IF;
2638:
2639: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
2640: (x_movement_transaction => l_movement_transaction);
2641:
2642: --Find out territory code
2643: l_subinv_terr_code :=

Line 2801: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

2797: l_movement_transaction.financial_document_flag := 'PROCESSED_INCLUDED';
2798: END IF;
2799: --End Bugfix 13400081
2800:
2801: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
2802: (p_api_version_number => 1.0
2803: ,p_init_msg_list => FND_API.G_FALSE
2804: ,x_movement_transaction => l_movement_transaction
2805: ,x_msg_count => x_msg_count

Line 3154: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

3150: --Set movement_id,used to insert into parent_movement_id for new record
3151: x_mvt_rtv_transaction.movement_id := l_parent_mvt_id;
3152:
3153: --Insert rtv arrival adjustment record
3154: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
3155: ( p_api_version_number => 1.0
3156: , p_init_msg_list => FND_API.G_FALSE
3157: , x_movement_transaction => x_mvt_rtv_transaction
3158: , x_msg_count => x_msg_count

Line 3379: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics

3375: l_parent_mvt_transaction.invoice_quantity;
3376: END IF;
3377:
3378: --Update parent PO
3379: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
3380: ( p_movement_statistics => l_parent_mvt_transaction
3381: , x_return_status => l_return_status
3382: , x_msg_count => x_msg_count
3383: , x_msg_data => x_msg_data

Line 3710: INV_MGD_MVT_STATS_PVT.Init_Movement_Record

3706: ||','||l_stat_typ_transaction.reference_period_rule
3707: ,'debug msg');
3708: END IF;
3709:
3710: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
3711: (x_movement_transaction => l_movement_transaction);
3712:
3713: IF (p_transaction_type = 'RTV')
3714: AND (l_receipt_transaction.transaction_type = 'RECEIVE')

Line 3951: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

3947: ( x_mvt_rtv_transaction => l_movement_transaction
3948: , x_return_status => l_insert_status
3949: );
3950: ELSE
3951: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
3952: (p_api_version_number => 1.0
3953: ,p_init_msg_list => FND_API.G_FALSE
3954: ,x_movement_transaction => l_movement_transaction
3955: ,x_msg_count => x_msg_count

Line 4070: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

4066: l_movement_transaction.financial_document_flag
4067: := 'PROCESSED_INCLUDED';
4068: END IF;
4069:
4070: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
4071: (p_api_version_number => 1.0
4072: ,p_init_msg_list => FND_API.G_FALSE
4073: ,x_movement_transaction => l_movement_transaction
4074: ,x_msg_count => x_msg_count

Line 4213: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

4209: l_movement_transaction.financial_document_flag
4210: := 'PROCESSED_INCLUDED';
4211: END IF;
4212:
4213: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
4214: (p_api_version_number => 1.0
4215: ,p_init_msg_list => FND_API.G_FALSE
4216: ,x_movement_transaction => l_movement_transaction
4217: ,x_msg_count => x_msg_count

Line 4585: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

4581: --Set movement_id,used to insert into parent_movement_id for new record
4582: x_mvt_rma_transaction.movement_id := l_parent_mvt_id;
4583:
4584: --Insert rma arrival adjustment record
4585: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
4586: ( p_api_version_number => 1.0
4587: , p_init_msg_list => FND_API.G_FALSE
4588: , x_movement_transaction => x_mvt_rma_transaction
4589: , x_msg_count => x_msg_count

Line 4810: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics

4806: l_parent_mvt_transaction.invoice_quantity;
4807: END IF;
4808:
4809: --Update parent SO
4810: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
4811: ( p_movement_statistics => l_parent_mvt_transaction
4812: , x_return_status => l_return_status
4813: , x_msg_count => x_msg_count
4814: , x_msg_data => x_msg_data

Line 5154: INV_MGD_MVT_STATS_PVT.Init_Movement_Record

5150: --the transaction is not inside of start period and end period
5151: --so not create transaction
5152: CLOSE ref_crsr;
5153: ELSE
5154: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
5155: (x_movement_transaction => l_movement_transaction);
5156:
5157: -- The RMA details is fetched here because sometimes the ship_to_site
5158: -- is not present in the RCV table; hence we get the ship to site from

Line 5638: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

5634: ( x_mvt_rma_transaction => l_movement_transaction
5635: , x_return_status => l_insert_status
5636: );
5637: ELSE
5638: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
5639: (p_api_version_number => 1.0
5640: ,p_init_msg_list => FND_API.G_FALSE
5641: ,x_movement_transaction => l_movement_transaction
5642: ,x_msg_count => x_msg_count

Line 5809: INV_MGD_MVT_STATS_PVT.Get_Invoice_Transactions

5805: l_movement_transaction := p_movement_transaction;
5806:
5807: -- Call the transaction proxy which processes all the transactions.
5808:
5809: INV_MGD_MVT_STATS_PVT.Get_Invoice_Transactions
5810: ( inv_crsr => inv_crsr
5811: , p_movement_transaction => l_movement_transaction
5812: , p_start_date => p_start_date
5813: , p_end_date => p_end_date

Line 6048: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics

6044: l_movement_transaction.invoice_quantity := null;
6045: END IF;
6046:
6047:
6048: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
6049: (p_movement_statistics => l_movement_transaction
6050: , x_return_status => l_return_status
6051: , x_msg_count => x_msg_count
6052: , x_msg_data => x_msg_data

Line 6173: INV_MGD_MVT_STATS_PVT.Get_PO_Trans_With_Correction

6169: x_return_status := FND_API.G_RET_STS_SUCCESS;
6170:
6171: -- Call the transaction proxy which processes all the PO and RTV transactions
6172: -- with corrections in the specified date range.
6173: INV_MGD_MVT_STATS_PVT.Get_PO_Trans_With_Correction
6174: ( inv_crsr => inv_crsr
6175: , p_legal_entity_id => p_legal_entity_id
6176: , p_start_date => p_start_date
6177: , p_end_date => p_end_date

Line 6411: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics

6407: l_movement_transaction.unit_weight := null;
6408: END IF;
6409:
6410: --Update original movement records
6411: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
6412: ( p_movement_statistics => l_movement_transaction
6413: , x_return_status => l_return_status
6414: , x_msg_count => x_msg_count
6415: , x_msg_data => x_msg_data

Line 6537: INV_MGD_MVT_STATS_PVT.Get_Pending_Txns

6533: l_movement_transaction := p_movement_transaction;
6534:
6535: -- Call the transaction proxy which processes all the transactions.
6536:
6537: INV_MGD_MVT_STATS_PVT.Get_Pending_Txns
6538: ( p_movement_transaction => l_movement_transaction
6539: , val_crsr => mvt_crsr
6540: , p_document_source_type => p_transaction_type
6541: , x_return_status => l_return_status);

Line 6806: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics

6802:
6803: l_movement_transaction.financial_document_flag := 'PROCESSED_INCLUDED';
6804: l_movement_transaction.movement_status := 'O';
6805:
6806: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
6807: (p_movement_statistics => l_movement_transaction
6808: , x_return_status => l_return_status
6809: , x_msg_count => x_msg_count
6810: , x_msg_data => x_msg_data

Line 6819: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics

6815: ELSE
6816: IF ( sysdate > l_movement_transaction.transaction_date )
6817: THEN
6818: l_movement_transaction.movement_status :='O';
6819: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
6820: (p_movement_statistics => l_movement_transaction
6821: , x_return_status => l_return_status
6822: , x_msg_count => x_msg_count
6823: , x_msg_data => x_msg_data