DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on FND_GLOBAL

Line 167: AND fu.user_id = fnd_global.user_id;

163: INTO x_dodaac
164: FROM per_people_extra_info pei, fnd_user fu
165: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
166: AND pei.person_id= fu.employee_id
167: AND fu.user_id = fnd_global.user_id;
168: EXCEPTION
169: WHEN No_Data_Found THEN
170: x_dodaac := NULL;
171: WHEN OTHERS THEN

Line 2878: ,FND_GLOBAL.user_id --LAST_UPDATED_BY

2874: AND AUCTION_LINE_NUMBER = paed.associated_to_line
2875: AND draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
2876: )
2877: ,SYSDATE --LAST_UPDATE_DATE
2878: ,FND_GLOBAL.user_id --LAST_UPDATED_BY
2879: ,SYSDATE --CREATION_DATE
2880: ,FND_GLOBAL.user_id --CREATED_BY
2881: ,FND_GLOBAL.login_id --LAST_UPDATE_LOGIN
2882: FROM PON_AUCTION_EXHIBIT_DETAILS paed

Line 2880: ,FND_GLOBAL.user_id --CREATED_BY

2876: )
2877: ,SYSDATE --LAST_UPDATE_DATE
2878: ,FND_GLOBAL.user_id --LAST_UPDATED_BY
2879: ,SYSDATE --CREATION_DATE
2880: ,FND_GLOBAL.user_id --CREATED_BY
2881: ,FND_GLOBAL.login_id --LAST_UPDATE_LOGIN
2882: FROM PON_AUCTION_EXHIBIT_DETAILS paed
2883: WHERE (paed.auction_header_id, paed.associated_to_line)
2884: IN (

Line 2881: ,FND_GLOBAL.login_id --LAST_UPDATE_LOGIN

2877: ,SYSDATE --LAST_UPDATE_DATE
2878: ,FND_GLOBAL.user_id --LAST_UPDATED_BY
2879: ,SYSDATE --CREATION_DATE
2880: ,FND_GLOBAL.user_id --CREATED_BY
2881: ,FND_GLOBAL.login_id --LAST_UPDATE_LOGIN
2882: FROM PON_AUCTION_EXHIBIT_DETAILS paed
2883: WHERE (paed.auction_header_id, paed.associated_to_line)
2884: IN (
2885: SELECT auction_header_id,auction_line_number FROM po_lines_merge_v pol