DBA Data[Home] [Help]

APPS.PO_CORE_S4 dependencies on MTL_PARAMETERS

Line 60: PROCEDURE NAME: get_mtl_parameters()

56: END cleanup_po_tables;
57:
58: /*===========================================================================
59:
60: PROCEDURE NAME: get_mtl_parameters()
61:
62: ===========================================================================*/
63: PROCEDURE get_mtl_parameters (x_org_id IN NUMBER,
64: x_org_code IN VARCHAR2,

Line 63: PROCEDURE get_mtl_parameters (x_org_id IN NUMBER,

59:
60: PROCEDURE NAME: get_mtl_parameters()
61:
62: ===========================================================================*/
63: PROCEDURE get_mtl_parameters (x_org_id IN NUMBER,
64: x_org_code IN VARCHAR2,
65: x_project_reference_enabled IN OUT NOCOPY NUMBER,
66: x_project_control_level IN OUT NOCOPY NUMBER) IS
67:

Line 92: FROM mtl_parameters mp

88: SELECT mp.PROJECT_REFERENCE_ENABLED,
89: mp.PROJECT_CONTROL_LEVEL
90: INTO x_project_reference_enabled,
91: x_project_control_level
92: FROM mtl_parameters mp
93: WHERE mp.organization_id = NVL(x_org_id, mp.organization_id)
94: AND mp.organization_code = NVL(x_org_code, mp.organization_code);
95:
96: END IF;

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

107: x_project_reference_enabled := NULL;
108: x_project_control_level := NULL;
109:
110: WHEN OTHERS THEN
111: po_message_s.sql_error('get_mtl_parameters', progress, sqlcode);
112: raise;
113:
114: END get_mtl_parameters;
115: -----

Line 114: END get_mtl_parameters;

110: WHEN OTHERS THEN
111: po_message_s.sql_error('get_mtl_parameters', progress, sqlcode);
112: raise;
113:
114: END get_mtl_parameters;
115: -----
116: /*===========================================================================
117: PROCEDURE NAME: raise_business_event()
118: