APPS.INV_MGD_MVT_STATS_PROC dependencies on INV_MGD_MVT_SO_MDTR

Line 1110: INV_MGD_MVT_SO_MDTR.Get_SO_Transactions

1106:
1107: l_movement_transaction := p_movement_transaction;
1108:
1109: -- Call the transaction proxy which processes all the transactions.
1110: INV_MGD_MVT_SO_MDTR.Get_SO_Transactions
1111: ( so_crsr => so_crsr
1112: , p_movement_transaction => l_movement_transaction
1113: , p_start_date => p_start_date
1114: , p_end_date => p_end_date

Line 1357: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Status

1353: END IF;
1354:
1355: --Find out if there is already a movement record created for this kit
1356: --if no, set l_kit_record to 'N' else set to 'Y'
1357: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Status
1358: (p_delivery_detail_id => l_movement_transaction.picking_line_detail_id);
1359: --End of bug 4185582, 4238563.
1360:
1361: --Only create record for organization located in the same country as legal entity

Line 1389: INV_MGD_MVT_SO_MDTR.Get_SO_Details

1385:
1386: -- Process the SO transaction
1387: IF l_insert_flag = 'Y'
1388: THEN
1389: INV_MGD_MVT_SO_MDTR.Get_SO_Details
1390: (x_movement_transaction => l_movement_transaction
1391: ,x_return_status => l_return_status
1392: );
1393:

Line 1396: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details

1392: );
1393:
1394: IF l_need_create_kit = 'Y'
1395: THEN
1396: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details
1397: ( p_link_to_line_id => l_link_to_line_id
1398: , x_movement_transaction => l_movement_transaction
1399: );
1400: END IF;

Line 1515: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions

1511: IF l_need_create_kit = 'Y'
1512: THEN
1513: IF l_kit_record_status = 'N'
1514: THEN
1515: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
1516: ( p_movement_id => l_movement_transaction.movement_id
1517: , p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
1518: , p_link_to_line_id => l_link_to_line_id
1519: , p_status => l_cross_le_status

Line 1524: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions

1520: , x_return_status => l_return_status
1521: );
1522: END IF;
1523: ELSE
1524: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
1525: ( p_movement_transaction => l_movement_transaction
1526: , p_status => l_cross_le_status
1527: , x_return_status => l_return_status
1528: );

Line 1693: INV_MGD_MVT_SO_MDTR.Get_Triangulation_Txns

1689: x_return_status := FND_API.G_RET_STS_SUCCESS;
1690: l_movement_transaction := p_movement_transaction;
1691:
1692: -- Call the transaction proxy which processes all the transactions.
1693: INV_MGD_MVT_SO_MDTR.Get_Triangulation_Txns
1694: ( sot_crsr => sot_crsr
1695: , p_movement_transaction => l_movement_transaction
1696: , p_start_date => p_start_date
1697: , p_end_date => p_end_date

Line 1896: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Triangulation_Status

1892: l_need_create_kit := 'Y';
1893:
1894: --Find out if there is already a movement record created for this kit
1895: --if no, set l_kit_record to 'N' else set to 'Y'
1896: l_kit_record_status := INV_MGD_MVT_SO_MDTR.Get_KIT_Triangulation_Status
1897: (p_delivery_detail_id => l_movement_transaction.picking_line_detail_id);
1898: ELSE
1899: l_need_create_kit := 'N';
1900: END IF;

Line 1915: INV_MGD_MVT_SO_MDTR.Get_SO_Details

1911:
1912: -- Process the SO transaction
1913: IF l_insert_flag = 'Y'
1914: THEN
1915: INV_MGD_MVT_SO_MDTR.Get_SO_Details
1916: (x_movement_transaction => l_movement_transaction
1917: ,x_return_status => l_return_status
1918: );
1919:

Line 1922: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details

1918: );
1919:
1920: IF l_need_create_kit = 'Y'
1921: THEN
1922: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details
1923: ( p_link_to_line_id => l_link_to_line_id
1924: , x_movement_transaction => l_movement_transaction
1925: );
1926: END IF;

Line 2056: INV_MGD_MVT_SO_MDTR.Get_SO_Details

2052: , l_movement_transaction2.currency_conversion_date;
2053: CLOSE l_order_currency;
2054: ELSE
2055: -- when create the first so, the insert flag is 'N', no so info populated
2056: INV_MGD_MVT_SO_MDTR.Get_SO_Details
2057: (x_movement_transaction => l_movement_transaction2
2058: ,x_return_status => l_return_status
2059: );
2060:

Line 2063: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details

2059: );
2060:
2061: IF l_need_create_kit = 'Y'
2062: THEN
2063: INV_MGD_MVT_SO_MDTR.Get_KIT_SO_Details
2064: ( p_link_to_line_id => l_link_to_line_id
2065: , x_movement_transaction => l_movement_transaction2
2066: );
2067: END IF;

Line 2160: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions

2156: IF l_need_create_kit = 'Y'
2157: THEN
2158: IF l_kit_record_status = 'N'
2159: THEN
2160: INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
2161: ( p_movement_id => l_movement_transaction.movement_id
2162: , p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
2163: , p_link_to_line_id => l_link_to_line_id
2164: , p_status => 'ARRIVALPROCESSED'

Line 2169: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions

2165: , x_return_status => l_return_status
2166: );
2167: END IF;
2168: ELSE
2169: INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
2170: ( p_movement_transaction => l_movement_transaction
2171: , p_status => 'ARRIVALPROCESSED'
2172: , x_return_status => l_return_status
2173: );