APPS.PO_CORE_S4 dependencies on MTL_PARAMETERS

Line 55: PROCEDURE NAME: get_mtl_parameters()

51: END cleanup_po_tables;
52:
53: /*===========================================================================
54:
55: PROCEDURE NAME: get_mtl_parameters()
56:
57: ===========================================================================*/
58: PROCEDURE get_mtl_parameters (x_org_id IN NUMBER,
59: x_org_code IN VARCHAR2,

Line 58: PROCEDURE get_mtl_parameters (x_org_id IN NUMBER,

54:
55: PROCEDURE NAME: get_mtl_parameters()
56:
57: ===========================================================================*/
58: PROCEDURE get_mtl_parameters (x_org_id IN NUMBER,
59: x_org_code IN VARCHAR2,
60: x_project_reference_enabled IN OUT NOCOPY NUMBER,
61: x_project_control_level IN OUT NOCOPY NUMBER) IS
62:

Line 87: FROM mtl_parameters mp

83: SELECT mp.PROJECT_REFERENCE_ENABLED,
84: mp.PROJECT_CONTROL_LEVEL
85: INTO x_project_reference_enabled,
86: x_project_control_level
87: FROM mtl_parameters mp
88: WHERE mp.organization_id = NVL(x_org_id, mp.organization_id)
89: AND mp.organization_code = NVL(x_org_code, mp.organization_code);
90:
91: END IF;

Line 106: po_message_s.sql_error('get_mtl_parameters', progress, sqlcode);

102: x_project_reference_enabled := NULL;
103: x_project_control_level := NULL;
104:
105: WHEN OTHERS THEN
106: po_message_s.sql_error('get_mtl_parameters', progress, sqlcode);
107: raise;
108:
109: END get_mtl_parameters;
110:

Line 109: END get_mtl_parameters;

105: WHEN OTHERS THEN
106: po_message_s.sql_error('get_mtl_parameters', progress, sqlcode);
107: raise;
108:
109: END get_mtl_parameters;
110:
111:
112: END po_core_s4;