eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on FND_GLOBAL

Line 1542: , FND_GLOBAL.user_id

1538: , -1
1539: , jsot.project_id
1540: , jsot.task_id
1541: , sysdate
1542: , FND_GLOBAL.user_id
1543: , sysdate
1544: , FND_GLOBAL.user_id
1545: , FND_GLOBAL.login_id
1546: , 'N'

Line 1544: , FND_GLOBAL.user_id

1540: , jsot.task_id
1541: , sysdate
1542: , FND_GLOBAL.user_id
1543: , sysdate
1544: , FND_GLOBAL.user_id
1545: , FND_GLOBAL.login_id
1546: , 'N'
1547: );
1548:

Line 1545: , FND_GLOBAL.login_id

1541: , sysdate
1542: , FND_GLOBAL.user_id
1543: , sysdate
1544: , FND_GLOBAL.user_id
1545: , FND_GLOBAL.login_id
1546: , 'N'
1547: );
1548:
1549: END IF;

Line 1559: , last_updated_by = FND_GLOBAL.user_id

1555: UPDATE jmf_subcontract_orders
1556: SET interlock_status ='N'
1557: , batch_id = -1
1558: , last_update_date = sysdate
1559: , last_updated_by = FND_GLOBAL.user_id
1560: , last_update_login = FND_GLOBAL.login_id
1561: WHERE interlock_status = 'E'
1562: AND EXISTS
1563: ( SELECT 'X'

Line 1560: , last_update_login = FND_GLOBAL.login_id

1556: SET interlock_status ='N'
1557: , batch_id = -1
1558: , last_update_date = sysdate
1559: , last_updated_by = FND_GLOBAL.user_id
1560: , last_update_login = FND_GLOBAL.login_id
1561: WHERE interlock_status = 'E'
1562: AND EXISTS
1563: ( SELECT 'X'
1564: FROM jmf_subcontract_orders

Line 2022: , FND_GLOBAL.user_id

2018: , l_primary_uom
2019: , poll.org_id
2020: , l_additional_supply
2021: , sysdate
2022: , FND_GLOBAL.user_id
2023: , sysdate
2024: , FND_GLOBAL.user_id
2025: , FND_GLOBAL.login_id
2026: , poll.quantity

Line 2024: , FND_GLOBAL.user_id

2020: , l_additional_supply
2021: , sysdate
2022: , FND_GLOBAL.user_id
2023: , sysdate
2024: , FND_GLOBAL.user_id
2025: , FND_GLOBAL.login_id
2026: , poll.quantity
2027: , l_primary_uom_qty
2028: , 0

Line 2025: , FND_GLOBAL.login_id

2021: , sysdate
2022: , FND_GLOBAL.user_id
2023: , sysdate
2024: , FND_GLOBAL.user_id
2025: , FND_GLOBAL.login_id
2026: , poll.quantity
2027: , l_primary_uom_qty
2028: , 0
2029: , 0

Line 2043: , last_updated_by = FND_GLOBAL.user_id

2039:
2040: UPDATE jmf_shikyu_components
2041: SET replen_so_creation_failed = 'Y'
2042: , last_update_date = sysdate
2043: , last_updated_by = FND_GLOBAL.user_id
2044: , last_update_login = FND_GLOBAL.login_id
2045: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2046: AND shikyu_component_id = l_component_id;
2047:

Line 2044: , last_update_login = FND_GLOBAL.login_id

2040: UPDATE jmf_shikyu_components
2041: SET replen_so_creation_failed = 'Y'
2042: , last_update_date = sysdate
2043: , last_updated_by = FND_GLOBAL.user_id
2044: , last_update_login = FND_GLOBAL.login_id
2045: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2046: AND shikyu_component_id = l_component_id;
2047:
2048: IF g_log_enabled

Line 2158: , last_updated_by = FND_GLOBAL.user_id

2154:
2155: UPDATE jmf_shikyu_components
2156: SET replen_so_creation_failed = NULL
2157: , last_update_date = sysdate
2158: , last_updated_by = FND_GLOBAL.user_id
2159: , last_update_login = FND_GLOBAL.login_id
2160: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2161: AND shikyu_component_id = l_osa_component_id;
2162:

Line 2159: , last_update_login = FND_GLOBAL.login_id

2155: UPDATE jmf_shikyu_components
2156: SET replen_so_creation_failed = NULL
2157: , last_update_date = sysdate
2158: , last_updated_by = FND_GLOBAL.user_id
2159: , last_update_login = FND_GLOBAL.login_id
2160: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2161: AND shikyu_component_id = l_osa_component_id;
2162:
2163: END IF;

Line 2504: , last_updated_by = FND_GLOBAL.user_id

2500:
2501: UPDATE JMF_SUBCONTRACT_ORDERS
2502: SET interlock_status = 'E'
2503: , last_update_date = sysdate
2504: , last_updated_by = FND_GLOBAL.user_id
2505: , last_update_login = FND_GLOBAL.login_id
2506: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2507:
2508: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INVALID_BOM');

Line 2505: , last_update_login = FND_GLOBAL.login_id

2501: UPDATE JMF_SUBCONTRACT_ORDERS
2502: SET interlock_status = 'E'
2503: , last_update_date = sysdate
2504: , last_updated_by = FND_GLOBAL.user_id
2505: , last_update_login = FND_GLOBAL.login_id
2506: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2507:
2508: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INVALID_BOM');
2509: FND_MSG_PUB.add;

Line 2726: , FND_GLOBAL.user_id

2722: , l_osa_tbl(i).oem_organization_id
2723: , l_comp_tbl(l_curr_index).primary_uom_code
2724: , l_comp_tbl(l_curr_index).primary_quantity
2725: , sysdate
2726: , FND_GLOBAL.user_id
2727: , sysdate
2728: , FND_GLOBAL.user_id
2729: , FND_GLOBAL.login_id
2730: , null

Line 2728: , FND_GLOBAL.user_id

2724: , l_comp_tbl(l_curr_index).primary_quantity
2725: , sysdate
2726: , FND_GLOBAL.user_id
2727: , sysdate
2728: , FND_GLOBAL.user_id
2729: , FND_GLOBAL.login_id
2730: , null
2731: , null
2732: , null

Line 2729: , FND_GLOBAL.login_id

2725: , sysdate
2726: , FND_GLOBAL.user_id
2727: , sysdate
2728: , FND_GLOBAL.user_id
2729: , FND_GLOBAL.login_id
2730: , null
2731: , null
2732: , null
2733: , null

Line 2807: , last_updated_by = FND_GLOBAL.user_id

2803: -- (specifically, shikyu_component_price could not be obtained)
2804: UPDATE JMF_SUBCONTRACT_ORDERS
2805: SET interlock_status = 'E'
2806: , last_update_date = sysdate
2807: , last_updated_by = FND_GLOBAL.user_id
2808: , last_update_login = FND_GLOBAL.login_id
2809: WHERE subcontract_po_shipment_id =
2810: l_osa_tbl(i).subcontract_po_shipment_id;
2811:

Line 2808: , last_update_login = FND_GLOBAL.login_id

2804: UPDATE JMF_SUBCONTRACT_ORDERS
2805: SET interlock_status = 'E'
2806: , last_update_date = sysdate
2807: , last_updated_by = FND_GLOBAL.user_id
2808: , last_update_login = FND_GLOBAL.login_id
2809: WHERE subcontract_po_shipment_id =
2810: l_osa_tbl(i).subcontract_po_shipment_id;
2811:
2812: END IF;

Line 2823: , last_updated_by = FND_GLOBAL.user_id

2819:
2820: UPDATE JMF_SUBCONTRACT_ORDERS
2821: SET interlock_status = 'E'
2822: , last_update_date = sysdate
2823: , last_updated_by = FND_GLOBAL.user_id
2824: , last_update_login = FND_GLOBAL.login_id
2825: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2826:
2827: DELETE FROM jmf_shikyu_components

Line 2824: , last_update_login = FND_GLOBAL.login_id

2820: UPDATE JMF_SUBCONTRACT_ORDERS
2821: SET interlock_status = 'E'
2822: , last_update_date = sysdate
2823: , last_updated_by = FND_GLOBAL.user_id
2824: , last_update_login = FND_GLOBAL.login_id
2825: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2826:
2827: DELETE FROM jmf_shikyu_components
2828: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;

Line 2889: , last_updated_by = FND_GLOBAL.user_id

2885:
2886: UPDATE JMF_SUBCONTRACT_ORDERS
2887: SET interlock_status = 'E'
2888: , last_update_date = sysdate
2889: , last_updated_by = FND_GLOBAL.user_id
2890: , last_update_login = FND_GLOBAL.login_id
2891: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2892:
2893: END IF; /* IF l_routing_count <= 0 */

Line 2890: , last_update_login = FND_GLOBAL.login_id

2886: UPDATE JMF_SUBCONTRACT_ORDERS
2887: SET interlock_status = 'E'
2888: , last_update_date = sysdate
2889: , last_updated_by = FND_GLOBAL.user_id
2890: , last_update_login = FND_GLOBAL.login_id
2891: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2892:
2893: END IF; /* IF l_routing_count <= 0 */
2894:

Line 3255: , last_updated_by = FND_GLOBAL.user_id

3251: -- Based on the above action, update JSO with interlock_status
3252: UPDATE jmf_subcontract_orders
3253: SET interlock_status ='P'
3254: , last_update_date = sysdate
3255: , last_updated_by = FND_GLOBAL.user_id
3256: , last_update_login = FND_GLOBAL.login_id
3257: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3258:
3259: l_osa_tbl(i).wip_entity_id := l_wip_entity_id;

Line 3256: , last_update_login = FND_GLOBAL.login_id

3252: UPDATE jmf_subcontract_orders
3253: SET interlock_status ='P'
3254: , last_update_date = sysdate
3255: , last_updated_by = FND_GLOBAL.user_id
3256: , last_update_login = FND_GLOBAL.login_id
3257: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3258:
3259: l_osa_tbl(i).wip_entity_id := l_wip_entity_id;
3260:

Line 3299: , last_updated_by = FND_GLOBAL.user_id

3295: UPDATE jmf_subcontract_orders
3296: SET interlock_status ='U'
3297: , batch_id = -1
3298: , last_update_date = sysdate
3299: , last_updated_by = FND_GLOBAL.user_id
3300: , last_update_login = FND_GLOBAL.login_id
3301: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3302:
3303: IF g_log_enabled THEN

Line 3300: , last_update_login = FND_GLOBAL.login_id

3296: SET interlock_status ='U'
3297: , batch_id = -1
3298: , last_update_date = sysdate
3299: , last_updated_by = FND_GLOBAL.user_id
3300: , last_update_login = FND_GLOBAL.login_id
3301: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3302:
3303: IF g_log_enabled THEN
3304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3502: , last_updated_by = FND_GLOBAL.user_id

3498: FORALL i IN l_curr_index .. l_batch_size
3499: UPDATE jmf_subcontract_orders
3500: SET batch_id = l_batch_id
3501: , last_update_date = sysdate
3502: , last_updated_by = FND_GLOBAL.user_id
3503: , last_update_login = FND_GLOBAL.login_id
3504: WHERE subcontract_po_shipment_id = l_osa_tbl(i);
3505:
3506: IF g_log_enabled THEN

Line 3503: , last_update_login = FND_GLOBAL.login_id

3499: UPDATE jmf_subcontract_orders
3500: SET batch_id = l_batch_id
3501: , last_update_date = sysdate
3502: , last_updated_by = FND_GLOBAL.user_id
3503: , last_update_login = FND_GLOBAL.login_id
3504: WHERE subcontract_po_shipment_id = l_osa_tbl(i);
3505:
3506: IF g_log_enabled THEN
3507: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN