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 1711: , FND_GLOBAL.user_id

1707: , -1
1708: , jsot.project_id
1709: , jsot.task_id
1710: , sysdate
1711: , FND_GLOBAL.user_id
1712: , sysdate
1713: , FND_GLOBAL.user_id
1714: , FND_GLOBAL.login_id
1715: , 'N'

Line 1713: , FND_GLOBAL.user_id

1709: , jsot.task_id
1710: , sysdate
1711: , FND_GLOBAL.user_id
1712: , sysdate
1713: , FND_GLOBAL.user_id
1714: , FND_GLOBAL.login_id
1715: , 'N'
1716: );
1717:

Line 1714: , FND_GLOBAL.login_id

1710: , sysdate
1711: , FND_GLOBAL.user_id
1712: , sysdate
1713: , FND_GLOBAL.user_id
1714: , FND_GLOBAL.login_id
1715: , 'N'
1716: );
1717:
1718: END IF;

Line 1728: , last_updated_by = FND_GLOBAL.user_id

1724: UPDATE jmf_subcontract_orders
1725: SET interlock_status ='N'
1726: , batch_id = -1
1727: , last_update_date = sysdate
1728: , last_updated_by = FND_GLOBAL.user_id
1729: , last_update_login = FND_GLOBAL.login_id
1730: WHERE interlock_status = 'E'
1731: AND EXISTS
1732: ( SELECT 'X'

Line 1729: , last_update_login = FND_GLOBAL.login_id

1725: SET interlock_status ='N'
1726: , batch_id = -1
1727: , last_update_date = sysdate
1728: , last_updated_by = FND_GLOBAL.user_id
1729: , last_update_login = FND_GLOBAL.login_id
1730: WHERE interlock_status = 'E'
1731: AND EXISTS
1732: ( SELECT 'X'
1733: FROM jmf_subcontract_orders

Line 2236: , FND_GLOBAL.user_id

2232: , l_primary_uom
2233: , poll.org_id
2234: , l_additional_supply
2235: , sysdate
2236: , FND_GLOBAL.user_id
2237: , sysdate
2238: , FND_GLOBAL.user_id
2239: , FND_GLOBAL.login_id
2240: , poll.quantity

Line 2238: , FND_GLOBAL.user_id

2234: , l_additional_supply
2235: , sysdate
2236: , FND_GLOBAL.user_id
2237: , sysdate
2238: , FND_GLOBAL.user_id
2239: , FND_GLOBAL.login_id
2240: , poll.quantity
2241: , l_primary_uom_qty
2242: , 0

Line 2239: , FND_GLOBAL.login_id

2235: , sysdate
2236: , FND_GLOBAL.user_id
2237: , sysdate
2238: , FND_GLOBAL.user_id
2239: , FND_GLOBAL.login_id
2240: , poll.quantity
2241: , l_primary_uom_qty
2242: , 0
2243: , 0

Line 2257: , last_updated_by = FND_GLOBAL.user_id

2253:
2254: UPDATE jmf_shikyu_components
2255: SET replen_so_creation_failed = 'Y'
2256: , last_update_date = sysdate
2257: , last_updated_by = FND_GLOBAL.user_id
2258: , last_update_login = FND_GLOBAL.login_id
2259: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2260: AND shikyu_component_id = l_component_id;
2261:

Line 2258: , last_update_login = FND_GLOBAL.login_id

2254: UPDATE jmf_shikyu_components
2255: SET replen_so_creation_failed = 'Y'
2256: , last_update_date = sysdate
2257: , last_updated_by = FND_GLOBAL.user_id
2258: , last_update_login = FND_GLOBAL.login_id
2259: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2260: AND shikyu_component_id = l_component_id;
2261:
2262: IF g_log_enabled

Line 2388: , last_updated_by = FND_GLOBAL.user_id

2384:
2385: UPDATE jmf_shikyu_components
2386: SET replen_so_creation_failed = NULL
2387: , last_update_date = sysdate
2388: , last_updated_by = FND_GLOBAL.user_id
2389: , last_update_login = FND_GLOBAL.login_id
2390: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2391: AND shikyu_component_id = l_osa_component_id;
2392:

Line 2389: , last_update_login = FND_GLOBAL.login_id

2385: UPDATE jmf_shikyu_components
2386: SET replen_so_creation_failed = NULL
2387: , last_update_date = sysdate
2388: , last_updated_by = FND_GLOBAL.user_id
2389: , last_update_login = FND_GLOBAL.login_id
2390: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2391: AND shikyu_component_id = l_osa_component_id;
2392:
2393: END IF;

Line 2769: , last_updated_by = FND_GLOBAL.user_id

2765:
2766: UPDATE JMF_SUBCONTRACT_ORDERS
2767: SET interlock_status = 'E'
2768: , last_update_date = sysdate
2769: , last_updated_by = FND_GLOBAL.user_id
2770: , last_update_login = FND_GLOBAL.login_id
2771: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2772:
2773: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INVALID_BOM');

Line 2770: , last_update_login = FND_GLOBAL.login_id

2766: UPDATE JMF_SUBCONTRACT_ORDERS
2767: SET interlock_status = 'E'
2768: , last_update_date = sysdate
2769: , last_updated_by = FND_GLOBAL.user_id
2770: , last_update_login = FND_GLOBAL.login_id
2771: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2772:
2773: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INVALID_BOM');
2774: FND_MSG_PUB.add;

Line 2998: , FND_GLOBAL.user_id

2994: , l_osa_tbl(i).oem_organization_id
2995: , l_comp_tbl(l_curr_index).primary_uom_code
2996: , l_comp_tbl(l_curr_index).primary_quantity
2997: , sysdate
2998: , FND_GLOBAL.user_id
2999: , sysdate
3000: , FND_GLOBAL.user_id
3001: , FND_GLOBAL.login_id
3002: , null

Line 3000: , FND_GLOBAL.user_id

2996: , l_comp_tbl(l_curr_index).primary_quantity
2997: , sysdate
2998: , FND_GLOBAL.user_id
2999: , sysdate
3000: , FND_GLOBAL.user_id
3001: , FND_GLOBAL.login_id
3002: , null
3003: , null
3004: , null

Line 3001: , FND_GLOBAL.login_id

2997: , sysdate
2998: , FND_GLOBAL.user_id
2999: , sysdate
3000: , FND_GLOBAL.user_id
3001: , FND_GLOBAL.login_id
3002: , null
3003: , null
3004: , null
3005: , null

Line 3079: , last_updated_by = FND_GLOBAL.user_id

3075: -- (specifically, shikyu_component_price could not be obtained)
3076: UPDATE JMF_SUBCONTRACT_ORDERS
3077: SET interlock_status = 'E'
3078: , last_update_date = sysdate
3079: , last_updated_by = FND_GLOBAL.user_id
3080: , last_update_login = FND_GLOBAL.login_id
3081: WHERE subcontract_po_shipment_id =
3082: l_osa_tbl(i).subcontract_po_shipment_id;
3083:

Line 3080: , last_update_login = FND_GLOBAL.login_id

3076: UPDATE JMF_SUBCONTRACT_ORDERS
3077: SET interlock_status = 'E'
3078: , last_update_date = sysdate
3079: , last_updated_by = FND_GLOBAL.user_id
3080: , last_update_login = FND_GLOBAL.login_id
3081: WHERE subcontract_po_shipment_id =
3082: l_osa_tbl(i).subcontract_po_shipment_id;
3083:
3084: END IF;

Line 3095: , last_updated_by = FND_GLOBAL.user_id

3091:
3092: UPDATE JMF_SUBCONTRACT_ORDERS
3093: SET interlock_status = 'E'
3094: , last_update_date = sysdate
3095: , last_updated_by = FND_GLOBAL.user_id
3096: , last_update_login = FND_GLOBAL.login_id
3097: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3098:
3099: DELETE FROM jmf_shikyu_components

Line 3096: , last_update_login = FND_GLOBAL.login_id

3092: UPDATE JMF_SUBCONTRACT_ORDERS
3093: SET interlock_status = 'E'
3094: , last_update_date = sysdate
3095: , last_updated_by = FND_GLOBAL.user_id
3096: , last_update_login = FND_GLOBAL.login_id
3097: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3098:
3099: DELETE FROM jmf_shikyu_components
3100: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;

Line 3161: , last_updated_by = FND_GLOBAL.user_id

3157:
3158: UPDATE JMF_SUBCONTRACT_ORDERS
3159: SET interlock_status = 'E'
3160: , last_update_date = sysdate
3161: , last_updated_by = FND_GLOBAL.user_id
3162: , last_update_login = FND_GLOBAL.login_id
3163: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3164:
3165: END IF; /* IF l_routing_count <= 0 */

Line 3162: , last_update_login = FND_GLOBAL.login_id

3158: UPDATE JMF_SUBCONTRACT_ORDERS
3159: SET interlock_status = 'E'
3160: , last_update_date = sysdate
3161: , last_updated_by = FND_GLOBAL.user_id
3162: , last_update_login = FND_GLOBAL.login_id
3163: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3164:
3165: END IF; /* IF l_routing_count <= 0 */
3166:

Line 3532: , last_updated_by = FND_GLOBAL.user_id

3528: -- Based on the above action, update JSO with interlock_status
3529: UPDATE jmf_subcontract_orders
3530: SET interlock_status ='P'
3531: , last_update_date = sysdate
3532: , last_updated_by = FND_GLOBAL.user_id
3533: , last_update_login = FND_GLOBAL.login_id
3534: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3535:
3536: l_osa_tbl(i).wip_entity_id := l_wip_entity_id;

Line 3533: , last_update_login = FND_GLOBAL.login_id

3529: UPDATE jmf_subcontract_orders
3530: SET interlock_status ='P'
3531: , last_update_date = sysdate
3532: , last_updated_by = FND_GLOBAL.user_id
3533: , last_update_login = FND_GLOBAL.login_id
3534: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3535:
3536: l_osa_tbl(i).wip_entity_id := l_wip_entity_id;
3537:

Line 3596: , last_updated_by = FND_GLOBAL.user_id

3592: UPDATE jmf_subcontract_orders
3593: SET interlock_status ='U'
3594: , batch_id = -1
3595: , last_update_date = sysdate
3596: , last_updated_by = FND_GLOBAL.user_id
3597: , last_update_login = FND_GLOBAL.login_id
3598: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3599:
3600: --Debugging changes for bug 9315131

Line 3597: , last_update_login = FND_GLOBAL.login_id

3593: SET interlock_status ='U'
3594: , batch_id = -1
3595: , last_update_date = sysdate
3596: , last_updated_by = FND_GLOBAL.user_id
3597: , last_update_login = FND_GLOBAL.login_id
3598: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3599:
3600: --Debugging changes for bug 9315131
3601: IF g_log_enabled THEN

Line 3805: , last_updated_by = FND_GLOBAL.user_id

3801: FORALL i IN l_curr_index .. l_batch_size
3802: UPDATE jmf_subcontract_orders
3803: SET batch_id = l_batch_id
3804: , last_update_date = sysdate
3805: , last_updated_by = FND_GLOBAL.user_id
3806: , last_update_login = FND_GLOBAL.login_id
3807: WHERE subcontract_po_shipment_id = l_osa_tbl(i);
3808:
3809: IF g_log_enabled THEN

Line 3806: , last_update_login = FND_GLOBAL.login_id

3802: UPDATE jmf_subcontract_orders
3803: SET batch_id = l_batch_id
3804: , last_update_date = sysdate
3805: , last_updated_by = FND_GLOBAL.user_id
3806: , last_update_login = FND_GLOBAL.login_id
3807: WHERE subcontract_po_shipment_id = l_osa_tbl(i);
3808:
3809: IF g_log_enabled THEN
3810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN