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.PO_ENCUMBRANCE_POSTPROCESSING dependencies on FND_GLOBAL

Line 532: l_login_id := FND_GLOBAL.login_id ;

528: END IF;
529:
530: --
531: l_appl_id := 201 ; -- Bug 5013999
532: l_login_id := FND_GLOBAL.login_id ;
533:
534:
535:
536: -- Insert the data into PO_BC_DISTRIBUTIONS from PO_ENCUMBRANCE_GT,

Line 2075: PRD.last_updated_by = fnd_global.user_id,

2071: AND TEMP.distribution_type = g_dist_type_REQUISITION
2072: GROUP BY TEMP.distribution_id
2073: ), /* Updating these cols also for bug#13930578 */
2074: PRD.last_update_date = sysdate,
2075: PRD.last_updated_by = fnd_global.user_id,
2076: PRD.last_update_login = fnd_global.login_id
2077: WHERE PRD.distribution_id in
2078: (
2079: SELECT MAIN_REQ.distribution_id

Line 2076: PRD.last_update_login = fnd_global.login_id

2072: GROUP BY TEMP.distribution_id
2073: ), /* Updating these cols also for bug#13930578 */
2074: PRD.last_update_date = sysdate,
2075: PRD.last_updated_by = fnd_global.user_id,
2076: PRD.last_update_login = fnd_global.login_id
2077: WHERE PRD.distribution_id in
2078: (
2079: SELECT MAIN_REQ.distribution_id
2080: FROM PO_ENCUMBRANCE_GT MAIN_REQ

Line 2156: PRD.last_updated_by = fnd_global.user_id,

2152: WHERE TEMP.distribution_id = PRD.distribution_id
2153: AND TEMP.distribution_type = g_dist_type_REQUISITION
2154: ), /* Updating these cols also for bug#13930578 */
2155: PRD.last_update_date = sysdate,
2156: PRD.last_updated_by = fnd_global.user_id,
2157: PRD.last_update_login = fnd_global.login_id
2158: WHERE PRD.distribution_id IN
2159: (
2160: SELECT MAIN_REQ.distribution_id

Line 2157: PRD.last_update_login = fnd_global.login_id

2153: AND TEMP.distribution_type = g_dist_type_REQUISITION
2154: ), /* Updating these cols also for bug#13930578 */
2155: PRD.last_update_date = sysdate,
2156: PRD.last_updated_by = fnd_global.user_id,
2157: PRD.last_update_login = fnd_global.login_id
2158: WHERE PRD.distribution_id IN
2159: (
2160: SELECT MAIN_REQ.distribution_id
2161: FROM PO_ENCUMBRANCE_GT MAIN_REQ

Line 2217: POD.last_updated_by = fnd_global.user_id,

2213: AND TEMP.distribution_type <> g_dist_type_REQUISITION
2214: GROUP BY TEMP.distribution_id
2215: ), /* Updating these cols also for bug#13930578 */
2216: POD.last_update_date = sysdate,
2217: POD.last_updated_by = fnd_global.user_id,
2218: POD.last_update_login = fnd_global.login_id
2219: WHERE POD.po_distribution_id in
2220: (
2221: SELECT MAIN_PURCH.distribution_id

Line 2218: POD.last_update_login = fnd_global.login_id

2214: GROUP BY TEMP.distribution_id
2215: ), /* Updating these cols also for bug#13930578 */
2216: POD.last_update_date = sysdate,
2217: POD.last_updated_by = fnd_global.user_id,
2218: POD.last_update_login = fnd_global.login_id
2219: WHERE POD.po_distribution_id in
2220: (
2221: SELECT MAIN_PURCH.distribution_id
2222: FROM PO_ENCUMBRANCE_GT MAIN_PURCH

Line 2282: PRD.last_updated_by = fnd_global.user_id,

2278: GROUP BY TEMP.distribution_id
2279: --: added MAX, SUM and GROUP BY operators
2280: ), /* Updating these cols also for bug#13930578 */
2281: PRD.last_update_date = sysdate,
2282: PRD.last_updated_by = fnd_global.user_id,
2283: PRD.last_update_login = fnd_global.login_id
2284: WHERE PRD.distribution_id in
2285: (
2286: SELECT BACKING_REQ.distribution_id

Line 2283: PRD.last_update_login = fnd_global.login_id

2279: --: added MAX, SUM and GROUP BY operators
2280: ), /* Updating these cols also for bug#13930578 */
2281: PRD.last_update_date = sysdate,
2282: PRD.last_updated_by = fnd_global.user_id,
2283: PRD.last_update_login = fnd_global.login_id
2284: WHERE PRD.distribution_id in
2285: (
2286: SELECT BACKING_REQ.distribution_id
2287: FROM PO_ENCUMBRANCE_GT BACKING_REQ

Line 2872: PRL.last_updated_by = fnd_global.user_id,

2868: AND NVL(PRD.prevent_encumbrance_flag, 'N') = 'N'
2869:
2870: ), /* Updating these cols also for bug#13930578 */
2871: PRL.last_update_date = sysdate,
2872: PRL.last_updated_by = fnd_global.user_id,
2873: PRL.last_update_login = fnd_global.login_id
2874:
2875: WHERE PRL.requisition_line_id IN
2876: (

Line 2873: PRL.last_update_login = fnd_global.login_id

2869:
2870: ), /* Updating these cols also for bug#13930578 */
2871: PRL.last_update_date = sysdate,
2872: PRL.last_updated_by = fnd_global.user_id,
2873: PRL.last_update_login = fnd_global.login_id
2874:
2875: WHERE PRL.requisition_line_id IN
2876: (
2877: SELECT TEMP.line_id

Line 2918: POLL.last_updated_by = fnd_global.user_id,

2914: WHERE POD.line_location_id = POLL.line_location_id
2915: AND NVL(POD.prevent_encumbrance_flag, 'N') = 'N'
2916: ), /* Updating these cols also for bug#13930578 */
2917: POLL.last_update_date = sysdate,
2918: POLL.last_updated_by = fnd_global.user_id,
2919: POLL.last_update_login = fnd_global.login_id
2920: WHERE POLL.line_location_id IN
2921: (
2922: SELECT TEMP.line_location_id

Line 2919: POLL.last_update_login = fnd_global.login_id

2915: AND NVL(POD.prevent_encumbrance_flag, 'N') = 'N'
2916: ), /* Updating these cols also for bug#13930578 */
2917: POLL.last_update_date = sysdate,
2918: POLL.last_updated_by = fnd_global.user_id,
2919: POLL.last_update_login = fnd_global.login_id
2920: WHERE POLL.line_location_id IN
2921: (
2922: SELECT TEMP.line_location_id
2923: FROM PO_ENCUMBRANCE_GT TEMP

Line 3488: POLL.last_updated_by = fnd_global.user_id,

3484:
3485: UPDATE PO_LINE_LOCATIONS_ALL POLL
3486: SET POLL.approved_flag = 'R',
3487: POLL.last_update_date = sysdate,
3488: POLL.last_updated_by = fnd_global.user_id,
3489: POLL.last_update_login = fnd_global.login_id
3490: WHERE POLL.po_release_id is NULL
3491: AND nvl(POLL.approved_flag,'N') = 'Y'
3492: AND EXISTS

Line 3489: POLL.last_update_login = fnd_global.login_id

3485: UPDATE PO_LINE_LOCATIONS_ALL POLL
3486: SET POLL.approved_flag = 'R',
3487: POLL.last_update_date = sysdate,
3488: POLL.last_updated_by = fnd_global.user_id,
3489: POLL.last_update_login = fnd_global.login_id
3490: WHERE POLL.po_release_id is NULL
3491: AND nvl(POLL.approved_flag,'N') = 'Y'
3492: AND EXISTS
3493: (

Line 3524: POH.last_updated_by = fnd_global.user_id,

3520: UPDATE PO_HEADERS_ALL POH
3521: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3522: POH.approved_flag = 'R',
3523: POH.last_update_date = sysdate,
3524: POH.last_updated_by = fnd_global.user_id,
3525: POH.last_update_login = fnd_global.login_id
3526: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3527: AND EXISTS
3528: (

Line 3525: POH.last_update_login = fnd_global.login_id

3521: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3522: POH.approved_flag = 'R',
3523: POH.last_update_date = sysdate,
3524: POH.last_updated_by = fnd_global.user_id,
3525: POH.last_update_login = fnd_global.login_id
3526: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3527: AND EXISTS
3528: (
3529: SELECT 'UNRESERVED DISTRIBUTION EXISTS'

Line 3562: POH.last_updated_by = fnd_global.user_id,

3558: UPDATE PO_HEADERS_ALL POH
3559: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3560: POH.approved_flag = 'R',
3561: POH.last_update_date = sysdate,
3562: POH.last_updated_by = fnd_global.user_id,
3563: POH.last_update_login = fnd_global.login_id
3564: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3565: AND EXISTS
3566: (

Line 3563: POH.last_update_login = fnd_global.login_id

3559: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3560: POH.approved_flag = 'R',
3561: POH.last_update_date = sysdate,
3562: POH.last_updated_by = fnd_global.user_id,
3563: POH.last_update_login = fnd_global.login_id
3564: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3565: AND EXISTS
3566: (
3567: SELECT 'UNRESERVED SINGLE DISTRIBUTION EXISTS'

Line 3595: POLL.last_updated_by = fnd_global.user_id,

3591:
3592: UPDATE PO_LINE_LOCATIONS_ALL POLL
3593: SET POLL.approved_flag = 'R',
3594: POLL.last_update_date = sysdate,
3595: POLL.last_updated_by = fnd_global.user_id,
3596: POLL.last_update_login = fnd_global.login_id
3597: WHERE POLL.po_release_id is NOT NULL
3598: AND nvl(POLL.approved_flag,'N') = 'Y' -- if approved
3599: AND EXISTS

Line 3596: POLL.last_update_login = fnd_global.login_id

3592: UPDATE PO_LINE_LOCATIONS_ALL POLL
3593: SET POLL.approved_flag = 'R',
3594: POLL.last_update_date = sysdate,
3595: POLL.last_updated_by = fnd_global.user_id,
3596: POLL.last_update_login = fnd_global.login_id
3597: WHERE POLL.po_release_id is NOT NULL
3598: AND nvl(POLL.approved_flag,'N') = 'Y' -- if approved
3599: AND EXISTS
3600: (

Line 3629: POR.last_updated_by = fnd_global.user_id,

3625: UPDATE PO_RELEASES_ALL POR
3626: SET POR.authorization_status = 'REQUIRES REAPPROVAL',
3627: POR.approved_flag = 'R',
3628: POR.last_update_date = sysdate,
3629: POR.last_updated_by = fnd_global.user_id,
3630: POR.last_update_login = fnd_global.login_id
3631: WHERE nvl(POR.approved_flag,'N') = 'Y' -- if approved
3632: AND EXISTS
3633: (

Line 3630: POR.last_update_login = fnd_global.login_id

3626: SET POR.authorization_status = 'REQUIRES REAPPROVAL',
3627: POR.approved_flag = 'R',
3628: POR.last_update_date = sysdate,
3629: POR.last_updated_by = fnd_global.user_id,
3630: POR.last_update_login = fnd_global.login_id
3631: WHERE nvl(POR.approved_flag,'N') = 'Y' -- if approved
3632: AND EXISTS
3633: (
3634: SELECT 'UNRESERVED DISTRIBUTION EXISTS'