DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PROC dependencies on INV_MGD_MVT_SETUP_MDTR

Line 808: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

804: );
805:
806: -- Get the setup info from the stat type usages table for the
807: -- specified legal entity.
808: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
809: ( p_legal_entity_id => l_movement_transaction.entity_org_id
810: , p_movement_transaction => l_movement_transaction
811: , x_return_status => l_return_status
812: , setup_crsr => setup_crsr

Line 834: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

830: , l_stat_typ_transaction.triangulation_mode;
831:
832: EXIT l_inner WHEN setup_crsr%NOTFOUND;
833:
834: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
835: ( p_legal_entity_id => l_movement_transaction.entity_org_id
836: , p_start_date => p_start_date
837: , p_end_date => p_end_date
838: , p_transaction_type => p_transaction_type

Line 947: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

943: AND (l_le_terr_code <> NVL(l_subinv_terr_code, l_org_terr_code))))
944: THEN
945: l_insert_flag := 'N';
946: ELSE
947: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
948: ( p_movement_transaction => l_movement_transaction);
949: END IF;
950:
951: -- Process the inventory transaction

Line 1215: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

1211: ( p_trxn_date => l_movement_transaction.transaction_date
1212: , p_le_id => l_movement_transaction.entity_org_id
1213: );
1214:
1215: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
1216: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1217: , p_movement_transaction => l_movement_transaction
1218: , x_return_status => l_return_status
1219: , setup_crsr => setup_crsr

Line 1283: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

1279: --Set back the included item line id
1280: l_movement_transaction.order_line_id := l_line_id;
1281: END IF;
1282:
1283: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
1284: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1285: , p_start_date => p_start_date
1286: , p_end_date => p_end_date
1287: , p_transaction_type => p_transaction_type

Line 1429: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

1425: OR (l_need_create_kit = 'Y' AND l_kit_record_status = 'Y'))
1426: THEN
1427: l_insert_flag := 'N';
1428: ELSE
1429: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
1430: ( p_movement_transaction => l_movement_transaction);
1431: END IF;
1432:
1433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1879: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

1875: ||','||l_movement_transaction.destination_territory_code
1876: ,'debug msg');
1877: END IF;
1878:
1879: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
1880: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1881: , p_movement_transaction => l_movement_transaction
1882: , x_return_status => l_return_status
1883: , setup_crsr => setup_crsr

Line 1962: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

1958: --Set back the included item line id
1959: l_movement_transaction.order_line_id := l_line_id;
1960: END IF;
1961:
1962: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
1963: ( p_legal_entity_id => l_movement_transaction.entity_org_id
1964: , p_start_date => p_start_date
1965: , p_end_date => p_end_date
1966: , p_transaction_type => p_transaction_type

Line 2052: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

2048: IF (l_need_create_kit = 'Y' AND l_kit_record_status = 'Y')
2049: THEN
2050: l_insert_flag := 'N';
2051: ELSE
2052: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
2053: ( p_movement_transaction => l_movement_transaction);
2054: END IF;
2055:
2056: --Debug

Line 2193: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

2189: IF (l_need_create_kit = 'Y' AND l_kit_record_status = 'Y')
2190: THEN
2191: l_insert_flag := 'N';
2192: ELSE
2193: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
2194: ( p_movement_transaction => l_movement_transaction2);
2195: END IF;
2196:
2197: --Debug

Line 2669: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

2665: -- Destination Org Territory Code should be same, is commented here.
2666: -- Its added in later section.
2667: --IF l_le_terr_code = l_movement_transaction.destination_territory_code
2668: --THEN
2669: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
2670: ( p_legal_entity_id => l_movement_transaction.entity_org_id
2671: , p_movement_transaction => l_movement_transaction
2672: , x_return_status => l_return_status
2673: , setup_crsr => setup_crsr

Line 2695: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

2691: , l_stat_typ_transaction.triangulation_mode;
2692:
2693: EXIT l_inner WHEN setup_crsr%NOTFOUND;
2694:
2695: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
2696: ( p_legal_entity_id => l_movement_transaction.entity_org_id
2697: , p_start_date => p_start_date
2698: , p_end_date => p_end_date
2699: , p_transaction_type => p_transaction_type

Line 2754: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

2750: AND (l_stat_typ_transaction.include_establishments = 'N')))
2751: THEN
2752: l_insert_flag := 'N';
2753: ELSE
2754: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
2755: ( p_movement_transaction => l_movement_transaction);
2756: END IF;
2757:
2758: -- Process the SO transaction

Line 3576: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

3572: ( p_trxn_date => l_movement_transaction.transaction_date
3573: , p_le_id => l_movement_transaction.entity_org_id
3574: );
3575:
3576: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
3577: ( p_legal_entity_id => l_movement_transaction.entity_org_id
3578: , p_movement_transaction => l_movement_transaction
3579: , x_return_status => l_return_status
3580: , setup_crsr => setup_crsr

Line 3651: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

3647: ,'debug msg');
3648: END IF;
3649: END IF;
3650:
3651: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
3652: ( p_legal_entity_id => l_movement_transaction.entity_org_id
3653: , p_start_date => p_start_date
3654: , p_end_date => p_end_date
3655: , p_transaction_type => p_transaction_type

Line 3840: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

3836: AND l_movement_transaction.usage_type = 'INTERNAL'))
3837: THEN
3838: l_insert_flag := 'N';
3839: ELSE
3840: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
3841: ( p_movement_transaction => l_movement_transaction);
3842: END IF;
3843:
3844: --Find out the parent movement id and movement status of a correct

Line 4037: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

4033: THEN
4034: l_insert_flag := 'N';
4035: ELSE
4036: --Find out the insert flag
4037: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
4038: ( p_movement_transaction => l_movement_transaction);
4039: END IF;
4040: ELSE
4041: l_insert_flag := 'N';

Line 4179: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

4175: THEN
4176: l_insert_flag := 'N';
4177: ELSE
4178: --Find out the insert flag
4179: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
4180: ( p_movement_transaction => l_movement_transaction);
4181: END IF;
4182: ELSE
4183: l_insert_flag := 'N';

Line 5032: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context

5028: ( p_trxn_date => l_movement_transaction.transaction_date
5029: , p_le_id => l_movement_transaction.entity_org_id
5030: );
5031:
5032: INV_MGD_MVT_SETUP_MDTR.Get_Setup_Context
5033: ( p_legal_entity_id => l_movement_transaction.entity_org_id
5034: , p_movement_transaction => l_movement_transaction
5035: , x_return_status => l_return_status
5036: , setup_crsr => setup_crsr

Line 5106: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context

5102: END IF;
5103:
5104: END IF;
5105:
5106: INV_MGD_MVT_SETUP_MDTR.Get_Reference_Context
5107: ( p_legal_entity_id => l_movement_transaction.entity_org_id
5108: , p_start_date => p_start_date
5109: , p_end_date => p_end_date
5110: , p_transaction_type => p_transaction_type

Line 5250: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

5246: l_movement_transaction.destination_territory_code := l_le_terr_code;
5247: /* 7165989 triangulation country would be the country where the RMA was created / booked */
5248: l_movement_transaction.triangulation_country_code := l_sold_from_org_code;
5249:
5250: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
5251: ( p_movement_transaction => l_movement_transaction);
5252: l_process_flag := 'Y';
5253: /* 7165989*/
5254:

Line 5446: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

5442: -- user has selected Include Establishments as No.
5443: IF (l_stat_typ_transaction.include_establishments = 'Y' OR
5444: l_le_terr_code = l_movement_transaction.destination_territory_code)
5445: THEN
5446: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
5447: ( p_movement_transaction => l_movement_transaction);
5448: END IF;
5449: FND_FILE.put_line (FND_FILE.log ,'Case 2 : RMA Shipment Based Triangulation run at receiving LE' );
5450:

Line 5504: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

5500: -- user has selected Include Establishments as No.
5501: IF (l_stat_typ_transaction.include_establishments = 'Y' OR
5502: l_le_terr_code = l_movement_transaction.destination_territory_code)
5503: THEN
5504: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
5505: ( p_movement_transaction => l_movement_transaction);
5506:
5507: --Debug
5508: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 5569: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context

5565: -- user has selected Include Establishments as No.
5566: IF (l_stat_typ_transaction.include_establishments = 'Y' OR
5567: l_le_terr_code = l_movement_transaction.destination_territory_code )
5568: THEN
5569: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
5570: ( p_movement_transaction => l_movement_transaction);
5571: --Debug
5572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5573: THEN

Line 5974: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context

5970: , l_movement_transaction.esl_drop_shipment_code;
5971:
5972: EXIT WHEN inv_crsr%NOTFOUND;
5973:
5974: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context
5975: ( p_legal_entity_id => l_movement_transaction.entity_org_id
5976: , p_start_date => p_start_date
5977: , p_end_date => p_end_date
5978: , p_transaction_type => p_transaction_type

Line 6702: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context

6698: EXIT WHEN mvt_crsr%NOTFOUND;
6699:
6700: l_trans_date := l_movement_transaction.transaction_date;
6701:
6702: INV_MGD_MVT_SETUP_MDTR.Get_Invoice_Context
6703: ( p_legal_entity_id => l_movement_transaction.entity_org_id
6704: , p_start_date => p_start_date
6705: , p_end_date => p_end_date
6706: , p_transaction_type => p_transaction_type