DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_PVT dependencies on FND_GLOBAL

Line 321: FND_GLOBAL.user_id,

317: created_by)
318: VALUES(
319: l_draft_id,
320: p_po_header_id,
321: FND_GLOBAL.user_id,
322: 'BUYER',
323: 'DRAFT',
324: 'MOD',
325: SYSDATE,

Line 326: FND_GLOBAL.user_id,

322: 'BUYER',
323: 'DRAFT',
324: 'MOD',
325: SYSDATE,
326: FND_GLOBAL.user_id,
327: FND_GLOBAL.login_id,
328: SYSDATE,
329: FND_GLOBAL.user_id);
330:

Line 327: FND_GLOBAL.login_id,

323: 'DRAFT',
324: 'MOD',
325: SYSDATE,
326: FND_GLOBAL.user_id,
327: FND_GLOBAL.login_id,
328: SYSDATE,
329: FND_GLOBAL.user_id);
330:
331: d_position := 20;

Line 329: FND_GLOBAL.user_id);

325: SYSDATE,
326: FND_GLOBAL.user_id,
327: FND_GLOBAL.login_id,
328: SYSDATE,
329: FND_GLOBAL.user_id);
330:
331: d_position := 20;
332: debug(d_module, d_position, 'Row created into PO_DRAFTS');
333:

Line 677: last_updated_by = FND_GLOBAL.user_id,

673: clm_default_dist_flag = l_clm_default_dist,
674: authorization_status = NULL,
675: document_creation_method = 'MULTI_MOD',
676: last_update_date = SYSDATE,
677: last_updated_by = FND_GLOBAL.user_id,
678: last_update_login = FND_GLOBAL.login_id
679: WHERE po_header_id = p_po_header_id
680: AND draft_id = p_draft_id;
681:

Line 678: last_update_login = FND_GLOBAL.login_id

674: authorization_status = NULL,
675: document_creation_method = 'MULTI_MOD',
676: last_update_date = SYSDATE,
677: last_updated_by = FND_GLOBAL.user_id,
678: last_update_login = FND_GLOBAL.login_id
679: WHERE po_header_id = p_po_header_id
680: AND draft_id = p_draft_id;
681:
682: d_position := 80;

Line 942: ,FND_GLOBAL.user_id

938: ,PK3_VALUE
939: ,PK4_VALUE
940: ,PK5_VALUE
941: ,SYSDATE
942: ,FND_GLOBAL.user_id
943: ,FND_GLOBAL.login_id
944: ,SYSDATE
945: ,FND_GLOBAL.user_id
946: ,C_EXT_ATTR1

Line 943: ,FND_GLOBAL.login_id

939: ,PK4_VALUE
940: ,PK5_VALUE
941: ,SYSDATE
942: ,FND_GLOBAL.user_id
943: ,FND_GLOBAL.login_id
944: ,SYSDATE
945: ,FND_GLOBAL.user_id
946: ,C_EXT_ATTR1
947: ,C_EXT_ATTR2

Line 945: ,FND_GLOBAL.user_id

941: ,SYSDATE
942: ,FND_GLOBAL.user_id
943: ,FND_GLOBAL.login_id
944: ,SYSDATE
945: ,FND_GLOBAL.user_id
946: ,C_EXT_ATTR1
947: ,C_EXT_ATTR2
948: ,C_EXT_ATTR3
949: ,C_EXT_ATTR4

Line 1120: ,FND_GLOBAL.user_id

1116: ,PK5_VALUE
1117: ,SOURCE_LANG
1118: ,LANGUAGE
1119: ,SYSDATE
1120: ,FND_GLOBAL.user_id
1121: ,FND_GLOBAL.login_id
1122: ,SYSDATE
1123: ,FND_GLOBAL.user_id
1124: ,TL_EXT_ATTR1

Line 1121: ,FND_GLOBAL.login_id

1117: ,SOURCE_LANG
1118: ,LANGUAGE
1119: ,SYSDATE
1120: ,FND_GLOBAL.user_id
1121: ,FND_GLOBAL.login_id
1122: ,SYSDATE
1123: ,FND_GLOBAL.user_id
1124: ,TL_EXT_ATTR1
1125: ,TL_EXT_ATTR2

Line 1123: ,FND_GLOBAL.user_id

1119: ,SYSDATE
1120: ,FND_GLOBAL.user_id
1121: ,FND_GLOBAL.login_id
1122: ,SYSDATE
1123: ,FND_GLOBAL.user_id
1124: ,TL_EXT_ATTR1
1125: ,TL_EXT_ATTR2
1126: ,TL_EXT_ATTR3
1127: ,TL_EXT_ATTR4

Line 2297: FND_GLOBAL.user_id,

2293: PMMC.new_vendor_site_id,
2294: PGOA.purchasing_org_id,
2295: PGOA.org_assignment_id,
2296: SYSDATE,
2297: FND_GLOBAL.user_id,
2298: FND_GLOBAL.login_id,
2299: SYSDATE,
2300: FND_GLOBAL.user_id
2301: FROM po_ga_org_assignments PGOA,

Line 2298: FND_GLOBAL.login_id,

2294: PGOA.purchasing_org_id,
2295: PGOA.org_assignment_id,
2296: SYSDATE,
2297: FND_GLOBAL.user_id,
2298: FND_GLOBAL.login_id,
2299: SYSDATE,
2300: FND_GLOBAL.user_id
2301: FROM po_ga_org_assignments PGOA,
2302: po_multi_mod_changes PMMC

Line 2300: FND_GLOBAL.user_id

2296: SYSDATE,
2297: FND_GLOBAL.user_id,
2298: FND_GLOBAL.login_id,
2299: SYSDATE,
2300: FND_GLOBAL.user_id
2301: FROM po_ga_org_assignments PGOA,
2302: po_multi_mod_changes PMMC
2303: WHERE PGOA.po_header_id = p_po_header_id
2304: AND PMMC.org_id = PGOA.purchasing_org_id

Line 2456: PreparerID => FND_GLOBAL.employee_id,

2452: WorkflowProcess => NULL,
2453: ActionOriginatedFrom => 'MULTI_MOD',
2454: DocumentID => p_po_header_id,
2455: DocumentNumber => l_headers_draft_rec.segment1,
2456: PreparerID => FND_GLOBAL.employee_id,
2457: DocumentTypeCode => l_doc_type_code,
2458: DocumentSubtype => l_headers_draft_rec.type_lookup_code,
2459: SubmitterAction => 'APPROVE',
2460: forwardToID => NULL,

Line 2684: last_updated_by = FND_GLOBAL.user_id,

2680: --Also update the who columns
2681: UPDATE po_multi_mod_docs
2682: SET draft_id = l_draft_id,
2683: last_update_date = sysdate,
2684: last_updated_by = FND_GLOBAL.user_id,
2685: last_update_login = FND_GLOBAL.login_id
2686: WHERE multi_mod_request_id = p_multi_mod_request_id
2687: AND document_id = p_po_header_id;
2688:

Line 2685: last_update_login = FND_GLOBAL.login_id

2681: UPDATE po_multi_mod_docs
2682: SET draft_id = l_draft_id,
2683: last_update_date = sysdate,
2684: last_updated_by = FND_GLOBAL.user_id,
2685: last_update_login = FND_GLOBAL.login_id
2686: WHERE multi_mod_request_id = p_multi_mod_request_id
2687: AND document_id = p_po_header_id;
2688:
2689: --Merge the Multi-Mod Addresses