APPS.GMD_PARAMETERS_PKG dependencies on GMD_PARAMETERS

Line 1: PACKAGE BODY gmd_parameters_pkg AS

1: PACKAGE BODY gmd_parameters_pkg AS
2: /* $Header: GMDPARMB.pls 120.1 2005/06/02 23:10:01 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references gmd_parameters%ROWTYPE;

Line 5: old_references gmd_parameters%ROWTYPE;

1: PACKAGE BODY gmd_parameters_pkg AS
2: /* $Header: GMDPARMB.pls 120.1 2005/06/02 23:10:01 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references gmd_parameters%ROWTYPE;
6: new_references gmd_parameters%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references gmd_parameters%ROWTYPE;

2: /* $Header: GMDPARMB.pls 120.1 2005/06/02 23:10:01 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references gmd_parameters%ROWTYPE;
6: new_references gmd_parameters%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM gmd_parameters

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM gmd_parameters
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 94: FROM gmd_parameters

90: || (reverse chronological order - newest change first)
91: */
92: CURSOR cur_rowid IS
93: SELECT rowid
94: FROM gmd_parameters
95: WHERE parameter_id = x_parameter_id
96: FOR UPDATE NOWAIT;
97:
98: lv_rowid cur_rowid%RowType;

Line 247: INSERT INTO gmd_parameters (

243: x_last_update_date => x_last_update_date,
244: x_last_updated_by => x_last_updated_by,
245: x_last_update_login => x_last_update_login
246: );
247: INSERT INTO gmd_parameters (
248: parameter_id,
249: orgn_code,
250: recipe_status,
251: validity_rule_status,

Line 304: FROM gmd_parameters

300: validity_rule_status,
301: formula_status,
302: routing_status,
303: operation_status
304: FROM gmd_parameters
305: WHERE rowid = x_rowid
306: FOR UPDATE NOWAIT;
307:
308: tlinfo c1%ROWTYPE;

Line 405: UPDATE gmd_parameters

401: x_last_updated_by => x_last_updated_by,
402: x_last_update_login => x_last_update_login
403: );
404:
405: UPDATE gmd_parameters
406: SET
407: orgn_code = new_references.orgn_code,
408: recipe_status = new_references.recipe_status,
409: validity_rule_status = new_references.validity_rule_status,

Line 447: FROM gmd_parameters

443: || (reverse chronological order - newest change first)
444: */
445: CURSOR c1 IS
446: SELECT rowid
447: FROM gmd_parameters
448: WHERE parameter_id = x_parameter_id;
449:
450: BEGIN
451:

Line 506: DELETE FROM gmd_parameters

502: p_action => 'DELETE',
503: x_rowid => x_rowid
504: );
505:
506: DELETE FROM gmd_parameters
507: WHERE rowid = x_rowid;
508:
509: IF (SQL%NOTFOUND) THEN
510: RAISE NO_DATA_FOUND;

Line 516: END gmd_parameters_pkg;

512:
513: END delete_row;
514:
515:
516: END gmd_parameters_pkg;