APPS.IGF_AW_DP_TERMS_PKG dependencies on IGF_AW_DP_TERMS

Line 1: PACKAGE BODY igf_aw_dp_terms_pkg AS

1: PACKAGE BODY igf_aw_dp_terms_pkg AS
2: /* $Header: IGFWI60B.pls 115.3 2003/11/21 06:38:05 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_dp_terms%ROWTYPE;

Line 5: old_references igf_aw_dp_terms%ROWTYPE;

1: PACKAGE BODY igf_aw_dp_terms_pkg AS
2: /* $Header: IGFWI60B.pls 115.3 2003/11/21 06:38:05 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_dp_terms%ROWTYPE;
6: new_references igf_aw_dp_terms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_dp_terms%ROWTYPE;

2: /* $Header: IGFWI60B.pls 115.3 2003/11/21 06:38:05 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_dp_terms%ROWTYPE;
6: new_references igf_aw_dp_terms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igf_aw_dp_terms

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

Line 128: igf_aw_dp_teach_prds_pkg.get_fk_igf_aw_dp_terms (

124: || (reverse chronological order - newest change first)
125: */
126: BEGIN
127:
128: igf_aw_dp_teach_prds_pkg.get_fk_igf_aw_dp_terms (
129: old_references.adterms_id
130: );
131:
132: END check_child_existance;

Line 176: FROM igf_aw_dp_terms

172: || (reverse chronological order - newest change first)
173: */
174: CURSOR cur_rowid IS
175: SELECT rowid
176: FROM igf_aw_dp_terms
177: WHERE adterms_id = x_adterms_id
178: FOR UPDATE NOWAIT;
179:
180: lv_rowid cur_rowid%RowType;

Line 216: FROM igf_aw_dp_terms

212: -------------------------------------------------------------------
213:
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM igf_aw_dp_terms
217: WHERE adplans_id = x_adplans_id
218: AND ld_cal_type = x_ld_cal_type
219: AND ld_sequence_number = x_ld_sequence_number
220: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 252: FROM igf_aw_dp_terms

248: || (reverse chronological order - newest change first)
249: */
250: CURSOR cur_rowid IS
251: SELECT rowid
252: FROM igf_aw_dp_terms
253: WHERE ((adplans_id = x_adplans_id));
254:
255: lv_rowid cur_rowid%RowType;
256:

Line 287: FROM igf_aw_dp_terms

283: || (reverse chronological order - newest change first)
284: */
285: CURSOR cur_rowid IS
286: SELECT rowid
287: FROM igf_aw_dp_terms
288: WHERE ((ld_cal_type = x_cal_type) AND
289: (ld_sequence_number = x_sequence_number));
290:
291: lv_rowid cur_rowid%ROWTYPE;

Line 426: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.INSERT_ROW');

422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:

Line 448: INSERT INTO igf_aw_dp_terms (

444: x_last_updated_by => x_last_updated_by,
445: x_last_update_login => x_last_update_login
446: );
447:
448: INSERT INTO igf_aw_dp_terms (
449: adterms_id,
450: adplans_id,
451: ld_cal_type,
452: ld_sequence_number,

Line 460: igf_aw_dp_terms_s.NEXTVAL,

456: last_update_date,
457: last_updated_by,
458: last_update_login
459: ) VALUES (
460: igf_aw_dp_terms_s.NEXTVAL,
461: new_references.adplans_id,
462: new_references.ld_cal_type,
463: new_references.ld_sequence_number,
464: new_references.ld_perct_num,

Line 498: FROM igf_aw_dp_terms

494: adplans_id,
495: ld_cal_type,
496: ld_sequence_number,
497: ld_perct_num
498: FROM igf_aw_dp_terms
499: WHERE rowid = x_rowid
500: FOR UPDATE NOWAIT;
501:
502: tlinfo c1%ROWTYPE;

Line 574: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.UPDATE_ROW');

570: x_last_update_login := -1;
571: END IF;
572: ELSE
573: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
574: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.UPDATE_ROW');
575: igs_ge_msg_stack.add;
576: app_exception.raise_exception;
577: END IF;
578:

Line 594: UPDATE igf_aw_dp_terms

590: x_last_updated_by => x_last_updated_by,
591: x_last_update_login => x_last_update_login
592: );
593:
594: UPDATE igf_aw_dp_terms
595: SET
596: adplans_id = new_references.adplans_id,
597: ld_cal_type = new_references.ld_cal_type,
598: ld_sequence_number = new_references.ld_sequence_number,

Line 632: FROM igf_aw_dp_terms

628: || (reverse chronological order - newest change first)
629: */
630: CURSOR c1 IS
631: SELECT rowid
632: FROM igf_aw_dp_terms
633: WHERE adterms_id = x_adterms_id;
634:
635: BEGIN
636:

Line 687: DELETE FROM igf_aw_dp_terms

683: p_action => 'DELETE',
684: x_rowid => x_rowid
685: );
686:
687: DELETE FROM igf_aw_dp_terms
688: WHERE rowid = x_rowid;
689:
690: IF (SQL%NOTFOUND) THEN
691: RAISE NO_DATA_FOUND;

Line 697: END igf_aw_dp_terms_pkg;

693:
694: END delete_row;
695:
696:
697: END igf_aw_dp_terms_pkg;