APPS.IGF_AP_CSS_INTERFACE_PKG dependencies on IGF_AP_CSS_INTERFACE_ALL

Line 5: old_references igf_ap_css_interface_all%ROWTYPE;

1: PACKAGE BODY igf_ap_css_interface_pkg AS
2: /* $Header: IGFAI41B.pls 120.0 2005/06/01 13:23:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_css_interface_all%ROWTYPE;
6: new_references igf_ap_css_interface_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,

Line 6: new_references igf_ap_css_interface_all%ROWTYPE;

2: /* $Header: IGFAI41B.pls 120.0 2005/06/01 13:23:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_css_interface_all%ROWTYPE;
6: new_references igf_ap_css_interface_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,
10: x_rowid IN VARCHAR2 ,

Line 739: FROM IGF_AP_CSS_INTERFACE_ALL

735: */
736:
737: CURSOR cur_old_ref_values IS
738: SELECT *
739: FROM IGF_AP_CSS_INTERFACE_ALL
740: WHERE rowid = x_rowid;
741:
742: BEGIN
743:

Line 1501: FROM igf_ap_css_interface_all

1497: || (reverse chronological order - newest change first)
1498: */
1499: CURSOR cur_rowid IS
1500: SELECT rowid
1501: FROM igf_ap_css_interface_all
1502: WHERE css_id = x_css_id
1503: FOR UPDATE NOWAIT;
1504:
1505: lv_rowid cur_rowid%RowType;

Line 3724: FROM igf_ap_css_interface_all

3720: || (reverse chronological order - newest change first)
3721: */
3722: CURSOR c IS
3723: SELECT rowid
3724: FROM igf_ap_css_interface_all
3725: WHERE css_id = x_css_id;
3726:
3727: x_last_update_date DATE;
3728: x_last_updated_by NUMBER;

Line 3752: SELECT igf_ap_css_interface_all_s.NEXTVAL

3748: igs_ge_msg_stack.add;
3749: app_exception.raise_exception;
3750: END IF;
3751:
3752: SELECT igf_ap_css_interface_all_s.NEXTVAL
3753: INTO x_css_id
3754: FROM dual;
3755:
3756: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 4478: INSERT INTO igf_ap_css_interface_all (

4474: x_parent_2_birth_date => x_parent_2_birth_date,
4475: x_match_code => x_match_code
4476: );
4477:
4478: INSERT INTO igf_ap_css_interface_all (
4479: css_id,
4480: org_id,
4481: record_status,
4482: college_code,

Line 7358: FROM igf_ap_css_interface_all

7354: parents_email_txt,
7355: parent_1_birth_date,
7356: parent_2_birth_date,
7357: match_code
7358: FROM igf_ap_css_interface_all
7359: WHERE rowid = x_rowid
7360: FOR UPDATE NOWAIT;
7361:
7362: tlinfo c1%ROWTYPE;

Line 9568: UPDATE igf_ap_css_interface_all

9564: x_match_code => x_match_code
9565:
9566: );
9567:
9568: UPDATE igf_ap_css_interface_all
9569: SET
9570: record_status = new_references.record_status,
9571: college_code = new_references.college_code,
9572: academic_year = new_references.academic_year,

Line 11016: FROM igf_ap_css_interface_all

11012: || (reverse chronological order - newest change first)
11013: */
11014: CURSOR c1 IS
11015: SELECT rowid
11016: FROM igf_ap_css_interface_all
11017: WHERE css_id = x_css_id;
11018:
11019: BEGIN
11020:

Line 12481: DELETE FROM igf_ap_css_interface_all

12477: p_action => 'DELETE',
12478: x_rowid => x_rowid
12479: );
12480:
12481: DELETE FROM igf_ap_css_interface_all
12482: WHERE rowid = x_rowid;
12483:
12484: IF (SQL%NOTFOUND) THEN
12485: RAISE NO_DATA_FOUND;