APPS.MTL_PARAMETERS_PKG dependencies on MTL_PARAMETERS

Line 1: PACKAGE BODY mtl_parameters_pkg AS

1: PACKAGE BODY mtl_parameters_pkg AS
2: /* $Header: INVSDOOB.pls 120.12.12020000.3 2013/01/30 15:22:51 avrose ship $ */
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY VARCHAR2
5: , x_organization_id NUMBER

Line 198: FROM mtl_parameters

194:
195: ) IS
196: CURSOR c IS
197: SELECT ROWID
198: FROM mtl_parameters
199: WHERE organization_id = x_organization_id;
200: BEGIN
201: INSERT INTO mtl_parameters
202: (

Line 201: INSERT INTO mtl_parameters

197: SELECT ROWID
198: FROM mtl_parameters
199: WHERE organization_id = x_organization_id;
200: BEGIN
201: INSERT INTO mtl_parameters
202: (
203: organization_id
204: , last_update_date
205: , last_updated_by

Line 785: FROM mtl_parameters

781: , x_opsm_enabled_flag VARCHAR2 -- Added for OPSM
782: ) IS
783: CURSOR c IS
784: SELECT *
785: FROM mtl_parameters
786: WHERE ROWID = x_rowid
787: FOR UPDATE OF organization_id NOWAIT;
788:
789: recinfo c%ROWTYPE;

Line 1679: UPDATE mtl_parameters

1675: , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
1676: , x_opsm_enabled_flag VARCHAR2 -- Added for OPSM
1677: ) IS
1678: BEGIN
1679: UPDATE mtl_parameters
1680: SET organization_id = x_organization_id
1681: , last_update_date = x_last_update_date
1682: , last_updated_by = x_last_updated_by
1683: , last_update_login = x_last_update_login

Line 1876: DELETE FROM mtl_parameters

1872: END update_row;
1873:
1874: PROCEDURE delete_row(x_rowid VARCHAR2) IS
1875: BEGIN
1876: DELETE FROM mtl_parameters
1877: WHERE ROWID = x_rowid;
1878:
1879: IF (SQL%NOTFOUND) THEN
1880: RAISE NO_DATA_FOUND;

Line 1952: fnd_msg_pub.add_exc_msg(g_pkg_name, 'MTL_PARAMETERS_PKG');

1948: WHEN OTHERS THEN
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;
1950:
1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1952: fnd_msg_pub.add_exc_msg(g_pkg_name, 'MTL_PARAMETERS_PKG');
1953: END IF;
1954: END upd_sub_accts_with_org_accts;
1955:
1956: FUNCTION get_miss_num

Line 2057: END mtl_parameters_pkg;

2053: RETURN VARCHAR2 IS
2054: BEGIN
2055: RETURN fnd_api.g_ret_sts_success;
2056: END;
2057: END mtl_parameters_pkg;