DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on FND_GLOBAL

Line 567: l_login_id := FND_GLOBAL.login_id ;

563: END IF;
564:
565: --
566: l_appl_id := 201 ; -- Bug 5013999
567: l_login_id := FND_GLOBAL.login_id ;
568:
569:
570:
571: -- Insert the data into PO_BC_DISTRIBUTIONS from PO_ENCUMBRANCE_GT,

Line 3158: POLL.last_updated_by = fnd_global.user_id,

3154:
3155: UPDATE PO_LINE_LOCATIONS_ALL POLL
3156: SET POLL.approved_flag = 'R',
3157: POLL.last_update_date = sysdate,
3158: POLL.last_updated_by = fnd_global.user_id,
3159: POLL.last_update_login = fnd_global.login_id
3160: WHERE POLL.po_release_id is NULL
3161: AND nvl(POLL.approved_flag,'N') = 'Y'
3162: AND EXISTS

Line 3159: POLL.last_update_login = fnd_global.login_id

3155: UPDATE PO_LINE_LOCATIONS_ALL POLL
3156: SET POLL.approved_flag = 'R',
3157: POLL.last_update_date = sysdate,
3158: POLL.last_updated_by = fnd_global.user_id,
3159: POLL.last_update_login = fnd_global.login_id
3160: WHERE POLL.po_release_id is NULL
3161: AND nvl(POLL.approved_flag,'N') = 'Y'
3162: AND EXISTS
3163: (

Line 3194: POH.last_updated_by = fnd_global.user_id,

3190: UPDATE PO_HEADERS_ALL POH
3191: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3192: POH.approved_flag = 'R',
3193: POH.last_update_date = sysdate,
3194: POH.last_updated_by = fnd_global.user_id,
3195: POH.last_update_login = fnd_global.login_id
3196: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3197: AND EXISTS
3198: (

Line 3195: POH.last_update_login = fnd_global.login_id

3191: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3192: POH.approved_flag = 'R',
3193: POH.last_update_date = sysdate,
3194: POH.last_updated_by = fnd_global.user_id,
3195: POH.last_update_login = fnd_global.login_id
3196: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3197: AND EXISTS
3198: (
3199: SELECT 'UNRESERVED DISTRIBUTION EXISTS'

Line 3232: POH.last_updated_by = fnd_global.user_id,

3228: UPDATE PO_HEADERS_ALL POH
3229: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3230: POH.approved_flag = 'R',
3231: POH.last_update_date = sysdate,
3232: POH.last_updated_by = fnd_global.user_id,
3233: POH.last_update_login = fnd_global.login_id
3234: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3235: AND EXISTS
3236: (

Line 3233: POH.last_update_login = fnd_global.login_id

3229: SET POH.authorization_status = 'REQUIRES REAPPROVAL',
3230: POH.approved_flag = 'R',
3231: POH.last_update_date = sysdate,
3232: POH.last_updated_by = fnd_global.user_id,
3233: POH.last_update_login = fnd_global.login_id
3234: WHERE nvl(POH.approved_flag,'N') = 'Y' -- if approved
3235: AND EXISTS
3236: (
3237: SELECT 'UNRESERVED SINGLE DISTRIBUTION EXISTS'

Line 3265: POLL.last_updated_by = fnd_global.user_id,

3261:
3262: UPDATE PO_LINE_LOCATIONS_ALL POLL
3263: SET POLL.approved_flag = 'R',
3264: POLL.last_update_date = sysdate,
3265: POLL.last_updated_by = fnd_global.user_id,
3266: POLL.last_update_login = fnd_global.login_id
3267: WHERE POLL.po_release_id is NOT NULL
3268: AND nvl(POLL.approved_flag,'N') = 'Y' -- if approved
3269: AND EXISTS

Line 3266: POLL.last_update_login = fnd_global.login_id

3262: UPDATE PO_LINE_LOCATIONS_ALL POLL
3263: SET POLL.approved_flag = 'R',
3264: POLL.last_update_date = sysdate,
3265: POLL.last_updated_by = fnd_global.user_id,
3266: POLL.last_update_login = fnd_global.login_id
3267: WHERE POLL.po_release_id is NOT NULL
3268: AND nvl(POLL.approved_flag,'N') = 'Y' -- if approved
3269: AND EXISTS
3270: (

Line 3299: POR.last_updated_by = fnd_global.user_id,

3295: UPDATE PO_RELEASES_ALL POR
3296: SET POR.authorization_status = 'REQUIRES REAPPROVAL',
3297: POR.approved_flag = 'R',
3298: POR.last_update_date = sysdate,
3299: POR.last_updated_by = fnd_global.user_id,
3300: POR.last_update_login = fnd_global.login_id
3301: WHERE nvl(POR.approved_flag,'N') = 'Y' -- if approved
3302: AND EXISTS
3303: (

Line 3300: POR.last_update_login = fnd_global.login_id

3296: SET POR.authorization_status = 'REQUIRES REAPPROVAL',
3297: POR.approved_flag = 'R',
3298: POR.last_update_date = sysdate,
3299: POR.last_updated_by = fnd_global.user_id,
3300: POR.last_update_login = fnd_global.login_id
3301: WHERE nvl(POR.approved_flag,'N') = 'Y' -- if approved
3302: AND EXISTS
3303: (
3304: SELECT 'UNRESERVED DISTRIBUTION EXISTS'