APPS.IGS_UC_REF_COUNTRY_PKG dependencies on IGS_UC_REF_COUNTRY

Line 1: PACKAGE BODY igs_uc_ref_country_pkg AS

1: PACKAGE BODY igs_uc_ref_country_pkg AS
2: /* $Header: IGSXI55B.pls 120.0 2006/08/21 03:42:56 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_country%ROWTYPE;

Line 5: old_references igs_uc_ref_country%ROWTYPE;

1: PACKAGE BODY igs_uc_ref_country_pkg AS
2: /* $Header: IGSXI55B.pls 120.0 2006/08/21 03:42:56 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_country%ROWTYPE;
6: new_references igs_uc_ref_country%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ref_country%ROWTYPE;

2: /* $Header: IGSXI55B.pls 120.0 2006/08/21 03:42:56 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_country%ROWTYPE;
6: new_references igs_uc_ref_country%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_uc_ref_country

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM igs_uc_ref_country
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 88: FROM igs_uc_ref_country

84: || (reverse chronological order - newest change first)
85: */
86: CURSOR cur_rowid IS
87: SELECT rowid
88: FROM igs_uc_ref_country
89: WHERE country_code = x_country_code
90: FOR UPDATE NOWAIT;
91:
92: lv_rowid cur_rowid%RowType;

Line 212: fnd_message.set_token ('ROUTINE', 'IGS_UC_REF_COUNTRY_PKG.INSERT_ROW');

208: x_last_update_login := -1;
209: END IF;
210: ELSE
211: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
212: fnd_message.set_token ('ROUTINE', 'IGS_UC_REF_COUNTRY_PKG.INSERT_ROW');
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215: END IF;
216:

Line 231: INSERT INTO igs_uc_ref_country (

227: x_last_updated_by => x_last_updated_by,
228: x_last_update_login => x_last_update_login
229: );
230:
231: INSERT INTO igs_uc_ref_country (
232: country_code,
233: description,
234: type,
235: imported,

Line 277: FROM igs_uc_ref_country

273: SELECT
274: description,
275: type,
276: imported
277: FROM igs_uc_ref_country
278: WHERE rowid = x_rowid
279: FOR UPDATE NOWAIT;
280:
281: tlinfo c1%ROWTYPE;

Line 351: fnd_message.set_token ('ROUTINE', 'IGS_UC_REF_COUNTRY_PKG.UPDATE_ROW');

347: x_last_update_login := -1;
348: END IF;
349: ELSE
350: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
351: fnd_message.set_token ('ROUTINE', 'IGS_UC_REF_COUNTRY_PKG.UPDATE_ROW');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355:

Line 370: UPDATE igs_uc_ref_country

366: x_last_updated_by => x_last_updated_by,
367: x_last_update_login => x_last_update_login
368: );
369:
370: UPDATE igs_uc_ref_country
371: SET
372: description = new_references.description,
373: type = new_references.type,
374: imported = new_references.imported,

Line 406: FROM igs_uc_ref_country

402: || (reverse chronological order - newest change first)
403: */
404: CURSOR c1 IS
405: SELECT rowid
406: FROM igs_uc_ref_country
407: WHERE country_code = x_country_code;
408:
409: BEGIN
410:

Line 459: DELETE FROM igs_uc_ref_country

455: p_action => 'DELETE',
456: x_rowid => x_rowid
457: );
458:
459: DELETE FROM igs_uc_ref_country
460: WHERE rowid = x_rowid;
461:
462: IF (SQL%NOTFOUND) THEN
463: RAISE NO_DATA_FOUND;

Line 469: END igs_uc_ref_country_pkg;

465:
466: END delete_row;
467:
468:
469: END igs_uc_ref_country_pkg;