APPS.IGF_AP_CSS_FNAR_PKG dependencies on IGF_AP_CSS_FNAR_ALL

Line 5: old_references igf_ap_css_fnar_all%ROWTYPE;

1: PACKAGE BODY igf_ap_css_fnar_pkg AS
2: /* $Header: IGFAI33B.pls 120.0 2005/06/01 14:06:47 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_css_fnar_all%ROWTYPE;
6: new_references igf_ap_css_fnar_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_css_fnar_all%ROWTYPE;

2: /* $Header: IGFAI33B.pls 120.0 2005/06/01 14:06:47 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_css_fnar_all%ROWTYPE;
6: new_references igf_ap_css_fnar_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 416: FROM IGF_AP_CSS_FNAR_ALL

412: */
413:
414: CURSOR cur_old_ref_values IS
415: SELECT *
416: FROM IGF_AP_CSS_FNAR_ALL
417: WHERE rowid = x_rowid;
418:
419: BEGIN
420:

Line 881: FROM igf_ap_css_fnar_all

877: || (reverse chronological order - newest change first)
878: */
879: CURSOR cur_rowid IS
880: SELECT rowid
881: FROM igf_ap_css_fnar_all
882: WHERE fnar_id = x_fnar_id
883: FOR UPDATE NOWAIT;
884:
885: lv_rowid cur_rowid%RowType;

Line 916: FROM igf_ap_css_fnar_all

912: || (reverse chronological order - newest change first)
913: */
914: CURSOR cur_rowid IS
915: SELECT rowid
916: FROM igf_ap_css_fnar_all
917: WHERE ((cssp_id = x_cssp_id));
918:
919: lv_rowid cur_rowid%RowType;
920:

Line 2174: FROM igf_ap_css_fnar_all

2170: || (reverse chronological order - newest change first)
2171: */
2172: CURSOR c IS
2173: SELECT rowid
2174: FROM igf_ap_css_fnar_all
2175: WHERE fnar_id = x_fnar_id;
2176:
2177: x_last_update_date DATE;
2178: x_last_updated_by NUMBER;

Line 2202: SELECT igf_ap_css_fnar_all_s.NEXTVAL

2198: igs_ge_msg_stack.add;
2199: app_exception.raise_exception;
2200: END IF;
2201:
2202: SELECT igf_ap_css_fnar_all_s.NEXTVAL
2203: INTO x_fnar_id
2204: FROM dual;
2205:
2206: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 2605: INSERT INTO igf_ap_css_fnar_all (

2601: x_parent_1_birth_date => x_parent_1_birth_date,
2602: x_parent_2_birth_date => x_parent_2_birth_date
2603: );
2604:
2605: INSERT INTO igf_ap_css_fnar_all (
2606: fnar_id,
2607: cssp_id,
2608: org_id,
2609: r_s_email_address,

Line 4193: FROM igf_ap_css_fnar_all

4189: cust_par_opt_tot_cont_amt,
4190: parents_email_txt,
4191: parent_1_birth_date,
4192: parent_2_birth_date
4193: FROM igf_ap_css_fnar_all
4194: WHERE rowid = x_rowid
4195: FOR UPDATE NOWAIT;
4196:
4197: tlinfo c1%ROWTYPE;

Line 5435: UPDATE igf_ap_css_fnar_all

5431: x_parent_1_birth_date => x_parent_1_birth_date,
5432: x_parent_2_birth_date => x_parent_2_birth_date
5433: );
5434:
5435: UPDATE igf_ap_css_fnar_all
5436: SET
5437: cssp_id = new_references.cssp_id,
5438: r_s_email_address = new_references.r_s_email_address,
5439: eps_code = new_references.eps_code,

Line 6237: FROM igf_ap_css_fnar_all

6233: || (reverse chronological order - newest change first)
6234: */
6235: CURSOR c1 IS
6236: SELECT rowid
6237: FROM igf_ap_css_fnar_all
6238: WHERE fnar_id = x_fnar_id;
6239:
6240: BEGIN
6241:

Line 7056: DELETE FROM igf_ap_css_fnar_all

7052: p_action => 'DELETE',
7053: x_rowid => x_rowid
7054: );
7055:
7056: DELETE FROM igf_ap_css_fnar_all
7057: WHERE rowid = x_rowid;
7058:
7059: IF (SQL%NOTFOUND) THEN
7060: RAISE NO_DATA_FOUND;