DBA Data[Home] [Help]

APPS.PO_PDOI_POSTPROC_PVT dependencies on FND_GLOBAL

Line 417: p_role_user_id => FND_GLOBAL.user_id,

413: -- to get the functional lock of the document explicitly
414: PO_DRAFTS_PVT.lock_document
415: ( p_po_header_id => l_doc_rec.po_header_id,
416: p_role => PO_PDOI_PARAMS.g_request.role,
417: p_role_user_id => FND_GLOBAL.user_id,
418: p_unlock_current => FND_API.G_FALSE
419: );
420:
421: IF (l_submit_for_buyer_acc_flag = FND_API.G_TRUE) THEN

Line 2565: last_updated_by = FND_GLOBAL.user_id,

2561:
2562: UPDATE po_headers_all
2563: SET start_date = NVL(start_date, l_expiration_date),
2564: end_date = l_expiration_date,
2565: last_updated_by = FND_GLOBAL.user_id,
2566: last_update_date = SYSDATE
2567: WHERE po_header_id = p_doc_rec.orig_po_header_id;
2568:
2569: IF (PO_LOG.d_proc) THEN

Line 3256: last_updated_by = FND_GLOBAL.user_id,

3252: approved_date = DECODE(l_approved_date,
3253: FND_API.G_MISS_DATE, approved_date,
3254: l_approved_date),
3255: last_update_date = SYSDATE,
3256: last_updated_by = FND_GLOBAL.user_id,
3257: last_update_login = FND_GLOBAL.login_id
3258: WHERE po_header_id = p_doc_rec.po_header_id;
3259:
3260: IF (p_auth_status = 'APPROVED') THEN

Line 3257: last_update_login = FND_GLOBAL.login_id

3253: FND_API.G_MISS_DATE, approved_date,
3254: l_approved_date),
3255: last_update_date = SYSDATE,
3256: last_updated_by = FND_GLOBAL.user_id,
3257: last_update_login = FND_GLOBAL.login_id
3258: WHERE po_header_id = p_doc_rec.po_header_id;
3259:
3260: IF (p_auth_status = 'APPROVED') THEN
3261: d_position := 20;

Line 3272: last_updated_by = FND_GLOBAL.user_id,

3268: UPDATE po_line_locations_all
3269: SET approved_flag = 'Y',
3270: approved_date = l_approved_date,
3271: last_update_date = SYSDATE,
3272: last_updated_by = FND_GLOBAL.user_id,
3273: last_update_login = FND_GLOBAL.login_id
3274: WHERE po_header_id = p_doc_rec.po_header_id
3275: AND shipment_type IN ('STANDARD', 'PRICE BREAK')
3276: AND NVL(approved_flag, 'N') <> 'Y';

Line 3273: last_update_login = FND_GLOBAL.login_id

3269: SET approved_flag = 'Y',
3270: approved_date = l_approved_date,
3271: last_update_date = SYSDATE,
3272: last_updated_by = FND_GLOBAL.user_id,
3273: last_update_login = FND_GLOBAL.login_id
3274: WHERE po_header_id = p_doc_rec.po_header_id
3275: AND shipment_type IN ('STANDARD', 'PRICE BREAK')
3276: AND NVL(approved_flag, 'N') <> 'Y';
3277:

Line 3289: x_user_id => FND_GLOBAL.user_id,

3285: x_object_type_code => PO_PDOI_PARAMS.g_request.document_type,
3286: x_old_employee_id => p_doc_rec.agent_id,
3287: x_action_code => 'APPROVE',
3288: x_note => NULL,
3289: x_user_id => FND_GLOBAL.user_id,
3290: x_login_id => FND_GLOBAL.login_id
3291: );
3292:
3293: -- Approved document should not have functional lock

Line 3290: x_login_id => FND_GLOBAL.login_id

3286: x_old_employee_id => p_doc_rec.agent_id,
3287: x_action_code => 'APPROVE',
3288: x_note => NULL,
3289: x_user_id => FND_GLOBAL.user_id,
3290: x_login_id => FND_GLOBAL.login_id
3291: );
3292:
3293: -- Approved document should not have functional lock
3294: PO_DRAFTS_PVT.unlock_document

Line 3606: WHERE fu.user_id = fnd_global.user_id

3602: INTO l_current_employee_id
3603: FROM fnd_user fu,
3604: per_workforce_current_x emp,
3605: po_agents poa
3606: WHERE fu.user_id = fnd_global.user_id
3607: AND fu.employee_id = emp.person_id (+)
3608: AND emp.person_id = poa.agent_id (+)
3609: AND SYSDATE BETWEEN Nvl(poa.start_date_active (+), SYSDATE - 1) AND
3610: Nvl(poa.end_date_active (+), SYSDATE + 1);

Line 4597: FND_GLOBAL.user_id,

4593: po_clm_car_util.get_modification_segment(p_po_header_id, -1),
4594: po_clm_car_util.get_agency_id(l_org_id),
4595: po_clm_car_util.get_prepared_user,
4596: SYSDATE,
4597: FND_GLOBAL.user_id,
4598: SYSDATE,
4599: FND_GLOBAL.user_id
4600: );
4601:

Line 4599: FND_GLOBAL.user_id

4595: po_clm_car_util.get_prepared_user,
4596: SYSDATE,
4597: FND_GLOBAL.user_id,
4598: SYSDATE,
4599: FND_GLOBAL.user_id
4600: );
4601:
4602: EXCEPTION
4603: WHEN OTHERS THEN