DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PROC dependencies on INV_MGD_MVT_SETUP_MDTR

Line 760: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

756: );
757:
758: -- Get the setup info from the stat type usages table for the
759: -- specified legal entity.
760: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
761: ( p_legal_entity_id => l_movement_transaction.entity_org_id
762: , p_movement_transaction => l_movement_transaction
763: , x_return_status => l_return_status
764: , setup_crsr => setup_crsr

Line 786: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

782: , l_stat_typ_transaction.triangulation_mode;
783:
784: EXIT l_inner WHEN setup_crsr%NOTFOUND;
785:
786: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
787: ( p_legal_entity_id => l_movement_transaction.entity_org_id
788: , p_start_date => p_start_date
789: , p_end_date => p_end_date
790: , p_transaction_type => p_transaction_type

Line 899: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

895: AND (l_le_terr_code <> NVL(l_subinv_terr_code, l_org_terr_code))))
896: THEN
897: l_insert_flag := 'N';
898: ELSE
899: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
900: ( p_movement_transaction => l_movement_transaction);
901: END IF;
902:
903: -- Process the inventory transaction

Line 1158: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

1154: ( p_trxn_date => l_movement_transaction.transaction_date
1155: , p_le_id => l_movement_transaction.entity_org_id
1156: );
1157:
1158: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
1159: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1160: , p_movement_transaction => l_movement_transaction
1161: , x_return_status => l_return_status
1162: , setup_crsr => setup_crsr

Line 1226: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

1222: --Set back the included item line id
1223: l_movement_transaction.order_line_id := l_line_id;
1224: END IF;
1225:
1226: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
1227: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1228: , p_start_date => p_start_date
1229: , p_end_date => p_end_date
1230: , p_transaction_type => p_transaction_type

Line 1372: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

1368: OR (l_need_create_kit = 'Y' AND l_kit_record_status = 'Y'))
1369: THEN
1370: l_insert_flag := 'N';
1371: ELSE
1372: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
1373: ( p_movement_transaction => l_movement_transaction);
1374: END IF;
1375:
1376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1761: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

1757: (p_le_id => l_shipping_le_id);
1758:
1759: l_movement_transaction.destination_territory_code := l_le_territory_code;
1760:
1761: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
1762: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1763: , p_movement_transaction => l_movement_transaction
1764: , x_return_status => l_return_status
1765: , setup_crsr => setup_crsr

Line 1832: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

1828: --Set back the included item line id
1829: l_movement_transaction.order_line_id := l_line_id;
1830: END IF;
1831:
1832: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
1833: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1834: , p_start_date => p_start_date
1835: , p_end_date => p_end_date
1836: , p_transaction_type => p_transaction_type

Line 1908: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

1904: IF (l_need_create_kit = 'Y' AND l_kit_record_status = 'Y')
1905: THEN
1906: l_insert_flag := 'N';
1907: ELSE
1908: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
1909: ( p_movement_transaction => l_movement_transaction);
1910: END IF;
1911:
1912: -- Process the SO transaction

Line 2016: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

2012: IF (l_need_create_kit = 'Y' AND l_kit_record_status = 'Y')
2013: THEN
2014: l_insert_flag := 'N';
2015: ELSE
2016: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
2017: ( p_movement_transaction => l_movement_transaction2);
2018: END IF;
2019:
2020: -- Process the SO transaction

Line 2389: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

2385: -- Destination Org Territory Code should be same, is commented here.
2386: -- Its added in later section.
2387: --IF l_le_terr_code = l_movement_transaction.destination_territory_code
2388: --THEN
2389: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
2390: ( p_legal_entity_id => l_movement_transaction.entity_org_id
2391: , p_movement_transaction => l_movement_transaction
2392: , x_return_status => l_return_status
2393: , setup_crsr => setup_crsr

Line 2415: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

2411: , l_stat_typ_transaction.triangulation_mode;
2412:
2413: EXIT l_inner WHEN setup_crsr%NOTFOUND;
2414:
2415: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
2416: ( p_legal_entity_id => l_movement_transaction.entity_org_id
2417: , p_start_date => p_start_date
2418: , p_end_date => p_end_date
2419: , p_transaction_type => p_transaction_type

Line 2474: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

2470: AND (l_stat_typ_transaction.include_establishments = 'N')))
2471: THEN
2472: l_insert_flag := 'N';
2473: ELSE
2474: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
2475: ( p_movement_transaction => l_movement_transaction);
2476: END IF;
2477:
2478: -- Process the SO transaction

Line 3247: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

3243: ( p_trxn_date => l_movement_transaction.transaction_date
3244: , p_le_id => l_movement_transaction.entity_org_id
3245: );
3246:
3247: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
3248: ( p_legal_entity_id => l_movement_transaction.entity_org_id
3249: , p_movement_transaction => l_movement_transaction
3250: , x_return_status => l_return_status
3251: , setup_crsr => setup_crsr

Line 3308: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

3304: ,'debug msg');
3305: END IF;
3306: END IF;
3307:
3308: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
3309: ( p_legal_entity_id => l_movement_transaction.entity_org_id
3310: , p_start_date => p_start_date
3311: , p_end_date => p_end_date
3312: , p_transaction_type => p_transaction_type

Line 3497: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

3493: AND l_movement_transaction.usage_type = 'INTERNAL'))
3494: THEN
3495: l_insert_flag := 'N';
3496: ELSE
3497: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
3498: ( p_movement_transaction => l_movement_transaction);
3499: END IF;
3500:
3501: --Find out the parent movement id and movement status of a correct

Line 3694: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

3690: THEN
3691: l_insert_flag := 'N';
3692: ELSE
3693: --Find out the insert flag
3694: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
3695: ( p_movement_transaction => l_movement_transaction);
3696: END IF;
3697: ELSE
3698: l_insert_flag := 'N';

Line 3836: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

3832: THEN
3833: l_insert_flag := 'N';
3834: ELSE
3835: --Find out the insert flag
3836: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
3837: ( p_movement_transaction => l_movement_transaction);
3838: END IF;
3839: ELSE
3840: l_insert_flag := 'N';

Line 4651: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

4647: ( p_trxn_date => l_movement_transaction.transaction_date
4648: , p_le_id => l_movement_transaction.entity_org_id
4649: );
4650:
4651: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
4652: ( p_legal_entity_id => l_movement_transaction.entity_org_id
4653: , p_movement_transaction => l_movement_transaction
4654: , x_return_status => l_return_status
4655: , setup_crsr => setup_crsr

Line 4699: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

4695: l_movement_transaction.transaction_date :=
4696: l_movement_transaction.reference_date;
4697: END IF;
4698:
4699: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
4700: ( p_legal_entity_id => l_movement_transaction.entity_org_id
4701: , p_start_date => p_start_date
4702: , p_end_date => p_end_date
4703: , p_transaction_type => p_transaction_type

Line 4826: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

4822: l_movement_transaction.destination_territory_code := l_le_terr_code;
4823: /* 7165989 triangulation country would be the country where the RMA was created / booked */
4824: l_movement_transaction.triangulation_country_code := l_sold_from_org_code;
4825:
4826: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
4827: ( p_movement_transaction => l_movement_transaction);
4828: l_process_flag := 'Y';
4829: /* 7165989*/
4830: IF (l_insert_flag = 'Y' ) THEN

Line 4947: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

4943: -- user has selected Include Establishments as No.
4944: IF (l_stat_typ_transaction.include_establishments = 'Y' OR
4945: l_le_terr_code = l_movement_transaction.destination_territory_code)
4946: THEN
4947: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
4948: ( p_movement_transaction => l_movement_transaction);
4949: END IF;
4950: FND_FILE.put_line (FND_FILE.log ,'Case 2 : RMA Shipment Based Triangulation run at receiving LE' );
4951: END IF;

Line 4981: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

4977: -- user has selected Include Establishments as No.
4978: IF (l_stat_typ_transaction.include_establishments = 'Y' OR
4979: l_le_terr_code = l_movement_transaction.destination_territory_code)
4980: THEN
4981: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
4982: ( p_movement_transaction => l_movement_transaction);
4983: END IF;
4984: /* 6732517 - Change mvt_stat_status in RCV_TRANSACTIONS based on the triangulation records created */
4985: /* If status is NEW , change status to 'FORARVL' so that the arrival record can be created in the*/

Line 5015: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

5011: -- user has selected Include Establishments as No.
5012: IF (l_stat_typ_transaction.include_establishments = 'Y' OR
5013: l_le_terr_code = l_movement_transaction.destination_territory_code )
5014: THEN
5015: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
5016: ( p_movement_transaction => l_movement_transaction);
5017: END IF;
5018:
5019: END IF;

Line 5381: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context

5377: , l_movement_transaction.esl_drop_shipment_code;
5378:
5379: EXIT WHEN inv_crsr%NOTFOUND;
5380:
5381: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context
5382: ( p_legal_entity_id => l_movement_transaction.entity_org_id
5383: , p_start_date => p_start_date
5384: , p_end_date => p_end_date
5385: , p_transaction_type => p_transaction_type

Line 6109: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context

6105: EXIT WHEN mvt_crsr%NOTFOUND;
6106:
6107: l_trans_date := l_movement_transaction.transaction_date;
6108:
6109: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context
6110: ( p_legal_entity_id => l_movement_transaction.entity_org_id
6111: , p_start_date => p_start_date
6112: , p_end_date => p_end_date
6113: , p_transaction_type => p_transaction_type