APPS.IGF_DB_PAYS_PRG_T_PKG dependencies on IGF_DB_PAYS_PRG_T

Line 1: PACKAGE BODY igf_db_pays_prg_t_pkg AS

1: PACKAGE BODY igf_db_pays_prg_t_pkg AS
2: /* $Header: IGFDI08B.pls 115.2 2002/11/28 14:14:50 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_pays_prg_t%ROWTYPE;

Line 5: old_references igf_db_pays_prg_t%ROWTYPE;

1: PACKAGE BODY igf_db_pays_prg_t_pkg AS
2: /* $Header: IGFDI08B.pls 115.2 2002/11/28 14:14:50 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_pays_prg_t%ROWTYPE;
6: new_references igf_db_pays_prg_t%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_db_pays_prg_t%ROWTYPE;

2: /* $Header: IGFDI08B.pls 115.2 2002/11/28 14:14:50 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_pays_prg_t%ROWTYPE;
6: new_references igf_db_pays_prg_t%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igf_db_pays_prg_t

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

Line 92: FROM igf_db_pays_prg_t

88: || (reverse chronological order - newest change first)
89: */
90: CURSOR cur_rowid IS
91: SELECT rowid
92: FROM igf_db_pays_prg_t
93: WHERE dbpays_id = x_dbpays_id
94: FOR UPDATE NOWAIT;
95:
96: lv_rowid cur_rowid%RowType;

Line 202: FROM igf_db_pays_prg_t

198: || (reverse chronological order - newest change first)
199: */
200: CURSOR c IS
201: SELECT rowid
202: FROM igf_db_pays_prg_t
203: WHERE dbpays_id = x_dbpays_id;
204:
205: x_last_update_date DATE;
206: x_last_updated_by NUMBER;

Line 230: SELECT igf_db_pays_prg_t_s.NEXTVAL

226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229:
230: SELECT igf_db_pays_prg_t_s.NEXTVAL
231: INTO x_dbpays_id
232: FROM dual;
233:
234: before_dml(

Line 250: INSERT INTO igf_db_pays_prg_t (

246: x_last_updated_by => x_last_updated_by,
247: x_last_update_login => x_last_update_login
248: );
249:
250: INSERT INTO igf_db_pays_prg_t (
251: dbpays_id,
252: base_id,
253: program_cd,
254: prg_ver_num,

Line 312: FROM igf_db_pays_prg_t

308: program_cd,
309: prg_ver_num,
310: unit_cd,
311: unit_ver_num
312: FROM igf_db_pays_prg_t
313: WHERE rowid = x_rowid
314: FOR UPDATE NOWAIT;
315:
316: tlinfo c1%ROWTYPE;

Line 410: UPDATE igf_db_pays_prg_t

406: x_last_updated_by => x_last_updated_by,
407: x_last_update_login => x_last_update_login
408: );
409:
410: UPDATE igf_db_pays_prg_t
411: SET
412: base_id = new_references.base_id,
413: program_cd = new_references.program_cd,
414: prg_ver_num = new_references.prg_ver_num,

Line 450: FROM igf_db_pays_prg_t

446: || (reverse chronological order - newest change first)
447: */
448: CURSOR c1 IS
449: SELECT rowid
450: FROM igf_db_pays_prg_t
451: WHERE dbpays_id = x_dbpays_id;
452:
453: BEGIN
454:

Line 507: DELETE FROM igf_db_pays_prg_t

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

Line 517: END igf_db_pays_prg_t_pkg;

513:
514: END delete_row;
515:
516:
517: END igf_db_pays_prg_t_pkg;