APPS.MTL_CLIENT_PARAMETERS_PKG dependencies on MTL_CLIENT_PARAMETERS

Line 1: PACKAGE BODY MTL_CLIENT_PARAMETERS_PKG AS

1: PACKAGE BODY MTL_CLIENT_PARAMETERS_PKG AS
2: /* $Header: INVCTDFB.pls 120.1 2011/01/14 13:33:41 gjyoti noship $ */
3: /*#
4: * This package provides routine for MTL_CLIENT_PARAMETERS table handler
5: * LSP installation utilities

Line 4: * This package provides routine for MTL_CLIENT_PARAMETERS table handler

1: PACKAGE BODY MTL_CLIENT_PARAMETERS_PKG AS
2: /* $Header: INVCTDFB.pls 120.1 2011/01/14 13:33:41 gjyoti noship $ */
3: /*#
4: * This package provides routine for MTL_CLIENT_PARAMETERS table handler
5: * LSP installation utilities
6: * @rep:scope private
7: * @rep:product INV
8: * @rep:lifecycle active

Line 9: * @rep:displayname MTL Client Parameters pkg

5: * LSP installation utilities
6: * @rep:scope private
7: * @rep:product INV
8: * @rep:lifecycle active
9: * @rep:displayname MTL Client Parameters pkg
10: * @rep:category BUSINESS_ENTITY LSP
11: */
12:
13:

Line 14: /* Procedure to Lock record for MTL_CLIENT_PARAMETERS table

10: * @rep:category BUSINESS_ENTITY LSP
11: */
12:
13:
14: /* Procedure to Lock record for MTL_CLIENT_PARAMETERS table
15: */
16:
17: PROCEDURE lock_row (X_Rowid VARCHAR2,
18: p_client_id NUMBER,

Line 42: FROM mtl_client_parameters

38: )
39: IS
40: CURSOR C IS
41: SELECT *
42: FROM mtl_client_parameters
43: WHERE rowid = X_Rowid
44: FOR UPDATE of client_id NOWAIT;
45: Recinfo C%ROWTYPE;
46: BEGIN

Line 119: /* Procedure to Insert record for MTL_CLIENT_PARAMETERS table

115: end if;
116: END Lock_Row;
117:
118:
119: /* Procedure to Insert record for MTL_CLIENT_PARAMETERS table
120: */
121:
122: PROCEDURE insert_row (X_Rowid IN OUT NOCOPY VARCHAR2,
123: p_client_id NUMBER,

Line 164: CURSOR C IS SELECT rowid FROM mtl_client_parameters

160: p_creation_date DATE,
161: p_created_by NUMBER,
162: p_last_update_login NUMBER
163: ) IS
164: CURSOR C IS SELECT rowid FROM mtl_client_parameters
165: WHERE client_id = p_client_id;
166:
167: BEGIN
168:

Line 169: INSERT INTO mtl_client_parameters(

165: WHERE client_id = p_client_id;
166:
167: BEGIN
168:
169: INSERT INTO mtl_client_parameters(
170: client_id,
171: client_code,
172: client_number,
173: trading_partner_site_id,

Line 263: /* Procedure to Update record for MTL_CLIENT_PARAMETERS table

259: CLOSE C;
260: END Insert_Row;
261:
262:
263: /* Procedure to Update record for MTL_CLIENT_PARAMETERS table
264: */
265:
266: PROCEDURE update_row (X_Rowid VARCHAR2,
267: p_client_id NUMBER,

Line 312: UPDATE mtl_client_parameters

308: ) IS
309:
310: BEGIN
311:
312: UPDATE mtl_client_parameters
313: SET
314: trading_partner_site_id = p_trading_partner_site_id,
315: receipt_asn_exists_code = p_receipt_asn_exists_code,
316: rma_receipt_routing_id = p_rma_receipt_routing_id,

Line 357: END MTL_CLIENT_PARAMETERS_PKG;

353: end if;
354:
355: END update_Row;
356:
357: END MTL_CLIENT_PARAMETERS_PKG;