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.6.12010000.3 2008/10/13 08:18:53 vssrivat ship $ */
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY VARCHAR2
5: , x_organization_id NUMBER

Line 194: FROM mtl_parameters

190: , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
191: ) IS
192: CURSOR c IS
193: SELECT ROWID
194: FROM mtl_parameters
195: WHERE organization_id = x_organization_id;
196: BEGIN
197: INSERT INTO mtl_parameters
198: (

Line 197: INSERT INTO mtl_parameters

193: SELECT ROWID
194: FROM mtl_parameters
195: WHERE organization_id = x_organization_id;
196: BEGIN
197: INSERT INTO mtl_parameters
198: (
199: organization_id
200: , last_update_date
201: , last_updated_by

Line 772: FROM mtl_parameters

768: , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
769: ) IS
770: CURSOR c IS
771: SELECT *
772: FROM mtl_parameters
773: WHERE ROWID = x_rowid
774: FOR UPDATE OF organization_id NOWAIT;
775:
776: recinfo c%ROWTYPE;

Line 1651: UPDATE mtl_parameters

1647: , x_lbr_management_enabled_flag VARCHAR2 DEFAULT NULL
1648: , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
1649: ) IS
1650: BEGIN
1651: UPDATE mtl_parameters
1652: SET organization_id = x_organization_id
1653: , last_update_date = x_last_update_date
1654: , last_updated_by = x_last_updated_by
1655: , last_update_login = x_last_update_login

Line 1845: DELETE FROM mtl_parameters

1841: END update_row;
1842:
1843: PROCEDURE delete_row(x_rowid VARCHAR2) IS
1844: BEGIN
1845: DELETE FROM mtl_parameters
1846: WHERE ROWID = x_rowid;
1847:
1848: IF (SQL%NOTFOUND) THEN
1849: RAISE NO_DATA_FOUND;

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

1917: WHEN OTHERS THEN
1918: x_return_status := fnd_api.g_ret_sts_unexp_error;
1919:
1920: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1921: fnd_msg_pub.add_exc_msg(g_pkg_name, 'MTL_PARAMETERS_PKG');
1922: END IF;
1923: END upd_sub_accts_with_org_accts;
1924:
1925: FUNCTION get_miss_num

Line 2026: END mtl_parameters_pkg;

2022: RETURN VARCHAR2 IS
2023: BEGIN
2024: RETURN fnd_api.g_ret_sts_success;
2025: END;
2026: END mtl_parameters_pkg;