APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 330: l_acceptance_level PO_SYSTEM_PARAMETERS_ALL.cat_admin_authoring_acceptance%TYPE;

326: l_acceptance_required VARCHAR2(1);
327: l_org_id PO_HEADERS_ALL.org_id%TYPE;
328: l_draft_id PO_DRAFTS.draft_id%TYPE;
329: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
330: l_acceptance_level PO_SYSTEM_PARAMETERS_ALL.cat_admin_authoring_acceptance%TYPE;
331: BEGIN
332: d_position := 0;
333:
334: IF (PO_LOG.d_proc) THEN

Line 370: FROM po_system_parameters_all PSP

366: NVL(PSP.cat_admin_authoring_acceptance, 'NOT_REQUIRED'),
367: PO_GLOBAL.g_ROLE_SUPPLIER,
368: NVL(PSP.supplier_authoring_acceptance, 'REQUIRED'))
369: INTO l_acceptance_level
370: FROM po_system_parameters_all PSP
371: WHERE PSP.org_id = l_org_id;
372:
373: -- bug5249414
374: -- Accept attribute values tlp records that are translations