APPS.IGF_AP_CSS_PROFILE_PKG dependencies on IGF_AP_CSS_PROFILE_ALL

Line 5: old_references igf_ap_css_profile_all%ROWTYPE;

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

Line 6: new_references igf_ap_css_profile_all%ROWTYPE;

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

Line 359: FROM IGF_AP_CSS_PROFILE_ALL

355: */
356:
357: CURSOR cur_old_ref_values IS
358: SELECT *
359: FROM IGF_AP_CSS_PROFILE_ALL
360: WHERE rowid = x_rowid;
361:
362: BEGIN
363:

Line 764: igf_ap_css_fnar_pkg.get_fk_igf_ap_css_profile_all (

760: || (reverse chronological order - newest change first)
761: */
762: BEGIN
763:
764: igf_ap_css_fnar_pkg.get_fk_igf_ap_css_profile_all (
765: old_references.cssp_id
766: );
767:
768: END check_child_existance;

Line 785: FROM igf_ap_css_profile_all

781: || (reverse chronological order - newest change first)
782: */
783: CURSOR cur_rowid IS
784: SELECT rowid
785: FROM igf_ap_css_profile_all
786: WHERE cssp_id = x_cssp_id
787: FOR UPDATE NOWAIT;
788:
789: lv_rowid cur_rowid%RowType;

Line 820: FROM igf_ap_css_profile_all

816: || (reverse chronological order - newest change first)
817: */
818: CURSOR cur_rowid IS
819: SELECT rowid
820: FROM igf_ap_css_profile_all
821: WHERE ((base_id = x_base_id));
822:
823: lv_rowid cur_rowid%RowType;
824:

Line 1912: FROM igf_ap_css_profile_all

1908: || (reverse chronological order - newest change first)
1909: */
1910: CURSOR c IS
1911: SELECT rowid
1912: FROM igf_ap_css_profile_all
1913: WHERE cssp_id = x_cssp_id;
1914:
1915: x_last_update_date DATE;
1916: x_last_updated_by NUMBER;

Line 1940: SELECT igf_ap_css_profile_all_s.NEXTVAL

1936: igs_ge_msg_stack.add;
1937: app_exception.raise_exception;
1938: END IF;
1939:
1940: SELECT igf_ap_css_profile_all_s.NEXTVAL
1941: INTO x_cssp_id
1942: FROM dual;
1943:
1944: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 2287: INSERT INTO igf_ap_css_profile_all (

2283: x_location_computer_num => x_location_computer_num
2284:
2285: );
2286:
2287: INSERT INTO igf_ap_css_profile_all (
2288: cssp_id,
2289: org_id,
2290: base_id,
2291: system_record_type,

Line 3648: FROM igf_ap_css_profile_all

3644: p_tuit_fee_deduct_amt,
3645: stu_lives_with_num,
3646: stu_most_support_from_num,
3647: location_computer_num
3648: FROM igf_ap_css_profile_all
3649: WHERE rowid = x_rowid
3650: FOR UPDATE NOWAIT;
3651:
3652: tlinfo c1%ROWTYPE;

Line 4718: UPDATE igf_ap_css_profile_all

4714: x_stu_most_support_from_num => x_stu_most_support_from_num,
4715: x_location_computer_num => x_location_computer_num
4716: );
4717:
4718: UPDATE igf_ap_css_profile_all
4719: SET
4720: base_id = new_references.base_id,
4721: system_record_type = new_references.system_record_type,
4722: active_profile = new_references.active_profile,

Line 5407: FROM igf_ap_css_profile_all

5403: || (reverse chronological order - newest change first)
5404: */
5405: CURSOR c1 IS
5406: SELECT rowid
5407: FROM igf_ap_css_profile_all
5408: WHERE cssp_id = x_cssp_id;
5409:
5410: BEGIN
5411:

Line 6112: DELETE FROM igf_ap_css_profile_all

6108: p_action => 'DELETE',
6109: x_rowid => x_rowid
6110: );
6111:
6112: DELETE FROM igf_ap_css_profile_all
6113: WHERE rowid = x_rowid;
6114:
6115: IF (SQL%NOTFOUND) THEN
6116: RAISE NO_DATA_FOUND;