APPS.IGF_AP_FA_ANT_DATA_PKG dependencies on IGF_AP_FA_ANT_DATA

Line 1: PACKAGE BODY igf_ap_fa_ant_data_pkg AS

1: PACKAGE BODY igf_ap_fa_ant_data_pkg AS
2: /* $Header: IGFAI76B.pls 120.0 2005/06/01 13:09:32 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_fa_ant_data%ROWTYPE;

Line 5: old_references igf_ap_fa_ant_data%ROWTYPE;

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

Line 6: new_references igf_ap_fa_ant_data%ROWTYPE;

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

Line 43: FROM igf_ap_fa_ant_data

39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM igf_ap_fa_ant_data
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 136: FROM igf_ap_fa_ant_data

132: || (reverse chronological order - newest change first)
133: */
134: CURSOR cur_rowid IS
135: SELECT rowid
136: FROM igf_ap_fa_ant_data
137: WHERE base_id = x_base_id
138: AND ld_cal_type = x_ld_cal_type
139: AND ld_sequence_number = x_ld_sequence_number
140: FOR UPDATE NOWAIT;

Line 173: FROM igf_ap_fa_ant_data

169: || (reverse chronological order - newest change first)
170: */
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igf_ap_fa_ant_data
174: WHERE ((base_id = x_base_id));
175:
176: lv_rowid cur_rowid%RowType;
177:

Line 351: fnd_message.set_token ('ROUTINE', 'IGF_AP_FA_ANT_DATA_PKG.INSERT_ROW');

347: x_program_update_date := SYSDATE;
348: END IF;
349: ELSE
350: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
351: fnd_message.set_token ('ROUTINE', 'IGF_AP_FA_ANT_DATA_PKG.INSERT_ROW');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355:

Line 380: INSERT INTO igf_ap_fa_ant_data (

376: x_last_updated_by => x_last_updated_by,
377: x_last_update_login => x_last_update_login
378: );
379:
380: INSERT INTO igf_ap_fa_ant_data (
381: base_id,
382: ld_cal_type,
383: ld_sequence_number,
384: org_unit_cd ,

Line 472: FROM igf_ap_fa_ant_data

468: attendance_type,
469: attendance_mode,
470: months_enrolled_num,
471: credit_points_num
472: FROM igf_ap_fa_ant_data
473: WHERE rowid = x_rowid
474: FOR UPDATE NOWAIT;
475:
476: tlinfo c1%ROWTYPE;

Line 568: fnd_message.set_token ('ROUTINE', 'IGF_AP_FA_ANT_DATA_PKG.UPDATE_ROW');

564: x_last_update_login := -1;
565: END IF;
566: ELSE
567: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
568: fnd_message.set_token ('ROUTINE', 'IGF_AP_FA_ANT_DATA_PKG.UPDATE_ROW');
569: igs_ge_msg_stack.add;
570: app_exception.raise_exception;
571: END IF;
572:

Line 611: UPDATE igf_ap_fa_ant_data

607: x_program_update_date := SYSDATE;
608: END IF;
609: END IF;
610:
611: UPDATE igf_ap_fa_ant_data
612: SET
613: org_unit_cd = new_references.org_unit_cd ,
614: program_type = new_references.program_type,
615: program_location_cd = new_references.program_location_cd,

Line 669: FROM igf_ap_fa_ant_data

665: || (reverse chronological order - newest change first)
666: */
667: CURSOR c1 IS
668: SELECT rowid
669: FROM igf_ap_fa_ant_data
670: WHERE base_id = x_base_id
671: AND ld_cal_type = x_ld_cal_type
672: AND ld_sequence_number = x_ld_sequence_number;
673:

Line 744: DELETE FROM igf_ap_fa_ant_data

740: p_action => 'DELETE',
741: x_rowid => x_rowid
742: );
743:
744: DELETE FROM igf_ap_fa_ant_data
745: WHERE rowid = x_rowid;
746:
747: IF (SQL%NOTFOUND) THEN
748: RAISE NO_DATA_FOUND;

Line 754: END igf_ap_fa_ant_data_pkg;

750:
751: END delete_row;
752:
753:
754: END igf_ap_fa_ant_data_pkg;