APPS.IGF_SL_CL_RESP_R1_PKG dependencies on IGF_SL_CL_RESP_R1_ALL

Line 5: old_references igf_sl_cl_resp_r1_all%ROWTYPE;

1: PACKAGE BODY igf_sl_cl_resp_r1_pkg AS
2: /* $Header: IGFLI22B.pls 120.1 2006/04/19 08:25:43 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r1_all%ROWTYPE;
6: new_references igf_sl_cl_resp_r1_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_cl_resp_r1_all%ROWTYPE;

2: /* $Header: IGFLI22B.pls 120.1 2006/04/19 08:25:43 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r1_all%ROWTYPE;
6: new_references igf_sl_cl_resp_r1_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 155: FROM igf_sl_cl_resp_r1_all

151: */
152:
153: CURSOR cur_old_ref_values IS
154: SELECT *
155: FROM igf_sl_cl_resp_r1_all
156: WHERE rowid = x_rowid;
157:
158: BEGIN
159:

Line 388: FROM igf_sl_cl_resp_r1_all

384: || (reverse chronological order - newest change first)
385: */
386: CURSOR cur_rowid IS
387: SELECT rowid
388: FROM igf_sl_cl_resp_r1_all
389: WHERE clrp1_id = x_clrp1_id
390: FOR UPDATE NOWAIT;
391:
392: lv_rowid cur_rowid%RowType;

Line 423: FROM igf_sl_cl_resp_r1_all

419: || (reverse chronological order - newest change first)
420: */
421: CURSOR cur_rowid IS
422: SELECT rowid
423: FROM igf_sl_cl_resp_r1_all
424: WHERE ((cbth_id = x_cbth_id));
425:
426: lv_rowid cur_rowid%RowType;
427:

Line 902: FROM igf_sl_cl_resp_r1_all

898: || (reverse chronological order - newest change first)
899: */
900: CURSOR c IS
901: SELECT rowid
902: FROM igf_sl_cl_resp_r1_all
903: WHERE clrp1_id = x_clrp1_id;
904:
905: x_last_update_date DATE;
906: x_last_updated_by NUMBER;

Line 912: l_org_id igf_sl_cl_resp_r1_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

908: x_request_id NUMBER;
909: x_program_id NUMBER;
910: x_program_application_id NUMBER;
911: x_program_update_date DATE;
912: l_org_id igf_sl_cl_resp_r1_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
913:
914: BEGIN
915:
916: x_last_update_date := SYSDATE;

Line 1087: INSERT INTO igf_sl_cl_resp_r1_all (

1083: x_b_alien_reg_num_txt => x_b_alien_reg_num_txt,
1084: x_esign_src_typ_cd => x_esign_src_typ_cd
1085: );
1086:
1087: INSERT INTO igf_sl_cl_resp_r1_all (
1088: clrp1_id,
1089: cbth_id,
1090: rec_code,
1091: rec_type_ind,

Line 1642: FROM igf_sl_cl_resp_r1_all

1638: school_use_txt,
1639: b_alien_reg_num_txt,
1640: esign_src_typ_cd
1641:
1642: FROM igf_sl_cl_resp_r1_all
1643: WHERE rowid = x_rowid
1644: FOR UPDATE NOWAIT;
1645:
1646: tlinfo c1%ROWTYPE;

Line 2118: UPDATE igf_sl_cl_resp_r1_all

2114: x_program_update_date := SYSDATE;
2115: END IF;
2116: END IF;
2117:
2118: UPDATE igf_sl_cl_resp_r1_all
2119: SET
2120: cbth_id = new_references.cbth_id,
2121: rec_code = new_references.rec_code,
2122: rec_type_ind = new_references.rec_type_ind,

Line 2402: FROM igf_sl_cl_resp_r1_all

2398: || (reverse chronological order - newest change first)
2399: */
2400: CURSOR c1 IS
2401: SELECT rowid
2402: FROM igf_sl_cl_resp_r1_all
2403: WHERE clrp1_id = x_clrp1_id;
2404:
2405: BEGIN
2406:

Line 2699: DELETE FROM igf_sl_cl_resp_r1_all

2695: p_action => 'DELETE',
2696: x_rowid => x_rowid
2697: );
2698:
2699: DELETE FROM igf_sl_cl_resp_r1_all
2700: WHERE rowid = x_rowid;
2701:
2702: IF (SQL%NOTFOUND) THEN
2703: RAISE NO_DATA_FOUND;