DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_MOAC_UTILS_PVT

Line 6136: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);

6132: DELETE FROM PO_ATTRIBUTE_VALUES
6133: WHERE po_line_id = NVL(p_po_line_id, -2)
6134: AND req_template_name = NVL(p_req_template_name, '-2')
6135: AND req_template_line_num = NVL(p_req_template_line_num, -2)
6136: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);
6137:
6138: l_progress := '020';
6139: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows deleted='||SQL%rowcount); END IF;
6140:

Line 6148: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);

6144: DELETE FROM PO_ATTRIBUTE_VALUES_TLP
6145: WHERE po_line_id = NVL(p_po_line_id, -2)
6146: AND req_template_name = NVL(p_req_template_name, '-2')
6147: AND req_template_line_num = NVL(p_req_template_line_num, -2)
6148: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);
6149:
6150: l_progress := '030';
6151: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6152: