APPS.INV_MGD_MVT_STATS_PROC dependencies on INV_MGD_MVT_SO_MDTR

Line 1167: INV_MGD_MVT_SO_MDTR.Get_SO_Transactions

1163:
1164: l_movement_transaction := p_movement_transaction;
1165:
1166: -- Call the transaction proxy which processes all the transactions.
1167: INV_MGD_MVT_SO_MDTR.Get_SO_Transactions
1168: ( so_crsr => so_crsr
1169: , p_movement_transaction => l_movement_transaction
1170: , p_start_date => p_start_date
1171: , p_end_date => p_end_date

Line 1414: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Status

1410: END IF;
1411:
1412: --Find out if there is already a movement record created for this kit
1413: --if no, set l_kit_record to 'N' else set to 'Y'
1414: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Status
1415: (p_delivery_detail_id => l_movement_transaction.picking_line_detail_id);
1416: --End of bug 4185582, 4238563.
1417:
1418: --Only create record for organization located in the same country as legal entity

Line 1446: INV_MGD_MVT_SO_MDTR.Get_SO_Details

1442:
1443: -- Process the SO transaction
1444: IF l_insert_flag = 'Y'
1445: THEN
1446: INV_MGD_MVT_SO_MDTR.Get_SO_Details
1447: (x_movement_transaction => l_movement_transaction
1448: ,x_return_status => l_return_status
1449: );
1450:

Line 1453: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details

1449: );
1450:
1451: IF l_need_create_kit = 'Y'
1452: THEN
1453: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details
1454: ( p_link_to_line_id => l_link_to_line_id
1455: , x_movement_transaction => l_movement_transaction
1456: );
1457: END IF;

Line 1594: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions

1590: IF l_need_create_kit = 'Y'
1591: THEN
1592: IF l_kit_record_status = 'N'
1593: THEN
1594: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
1595: ( p_movement_id => l_movement_transaction.movement_id
1596: , p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
1597: , p_link_to_line_id => l_link_to_line_id
1598: , p_status => l_cross_le_status

Line 1603: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions

1599: , x_return_status => l_return_status
1600: );
1601: END IF;
1602: ELSE
1603: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
1604: ( p_movement_transaction => l_movement_transaction
1605: , p_status => l_cross_le_status
1606: , x_return_status => l_return_status
1607: );

Line 1772: INV_MGD_MVT_SO_MDTR.Get_Triangulation_Txns

1768: x_return_status := FND_API.G_RET_STS_SUCCESS;
1769: l_movement_transaction := p_movement_transaction;
1770:
1771: -- Call the transaction proxy which processes all the transactions.
1772: INV_MGD_MVT_SO_MDTR.Get_Triangulation_Txns
1773: ( sot_crsr => sot_crsr
1774: , p_movement_transaction => l_movement_transaction
1775: , p_start_date => p_start_date
1776: , p_end_date => p_end_date

Line 2040: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Triangulation_Status

2036: l_need_create_kit := 'Y';
2037:
2038: --Find out if there is already a movement record created for this kit
2039: --if no, set l_kit_record to 'N' else set to 'Y'
2040: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Triangulation_Status
2041: (p_delivery_detail_id => l_movement_transaction.picking_line_detail_id);
2042: ELSE
2043: l_need_create_kit := 'N';
2044: END IF;

Line 2071: INV_MGD_MVT_SO_MDTR.Get_SO_Details

2067:
2068: -- Process the SO transaction
2069: IF l_insert_flag = 'Y'
2070: THEN
2071: INV_MGD_MVT_SO_MDTR.Get_SO_Details
2072: (x_movement_transaction => l_movement_transaction
2073: ,x_return_status => l_return_status
2074: );
2075:

Line 2078: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details

2074: );
2075:
2076: IF l_need_create_kit = 'Y'
2077: THEN
2078: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details
2079: ( p_link_to_line_id => l_link_to_line_id
2080: , x_movement_transaction => l_movement_transaction
2081: );
2082: END IF;

Line 2245: INV_MGD_MVT_SO_MDTR.Get_SO_Details

2241: , l_movement_transaction2.currency_conversion_date;
2242: CLOSE l_order_currency;
2243: ELSE
2244: -- when create the first so, the insert flag is 'N', no so info populated
2245: INV_MGD_MVT_SO_MDTR.Get_SO_Details
2246: (x_movement_transaction => l_movement_transaction2
2247: ,x_return_status => l_return_status
2248: );
2249:

Line 2252: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details

2248: );
2249:
2250: IF l_need_create_kit = 'Y'
2251: THEN
2252: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details
2253: ( p_link_to_line_id => l_link_to_line_id
2254: , x_movement_transaction => l_movement_transaction2
2255: );
2256: END IF;

Line 2358: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions

2354: IF l_need_create_kit = 'Y'
2355: THEN
2356: IF l_kit_record_status = 'N'
2357: THEN
2358: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
2359: ( p_movement_id => l_movement_transaction.movement_id
2360: , p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
2361: , p_link_to_line_id => l_link_to_line_id
2362: , p_status => 'ARRIVALPROCESSED'

Line 2367: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions

2363: , x_return_status => l_return_status
2364: );
2365: END IF;
2366: ELSE
2367: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
2368: ( p_movement_transaction => l_movement_transaction
2369: , p_status => 'ARRIVALPROCESSED'
2370: , x_return_status => l_return_status
2371: );