APPS.IGS_FI_1098T_DATA_PKG dependencies on IGS_FI_1098T_DATA

Line 1: PACKAGE BODY igs_fi_1098t_data_pkg AS

1: PACKAGE BODY igs_fi_1098t_data_pkg AS
2: /* $Header: IGSSIE8B.pls 120.0 2005/09/09 19:11:39 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_1098t_data%ROWTYPE;

Line 5: old_references igs_fi_1098t_data%ROWTYPE;

1: PACKAGE BODY igs_fi_1098t_data_pkg AS
2: /* $Header: IGSSIE8B.pls 120.0 2005/09/09 19:11:39 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_1098t_data%ROWTYPE;
6: new_references igs_fi_1098t_data%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_1098t_data%ROWTYPE;

2: /* $Header: IGSSIE8B.pls 120.0 2005/09/09 19:11:39 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_1098t_data%ROWTYPE;
6: new_references igs_fi_1098t_data%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 67: FROM igs_fi_1098t_data

63: */
64:
65: CURSOR cur_old_ref_values IS
66: SELECT *
67: FROM igs_fi_1098t_data
68: WHERE rowid = x_rowid;
69:
70: BEGIN
71:

Line 220: FROM igs_fi_1098t_data

216: || (reverse chronological order - newest change first)
217: */
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM igs_fi_1098t_data
221: WHERE stu_1098t_id = x_stu_1098t_id
222: FOR UPDATE NOWAIT;
223:
224: lv_rowid cur_rowid%RowType;

Line 470: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_DATA_PKG.INSERT_ROW');

466: x_program_update_date := SYSDATE;
467: END IF;
468: ELSE
469: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
470: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_DATA_PKG.INSERT_ROW');
471: igs_ge_msg_stack.add;
472: app_exception.raise_exception;
473: END IF;
474:

Line 525: INSERT INTO igs_fi_1098t_data (

521: x_last_updated_by => x_last_updated_by,
522: x_last_update_login => x_last_update_login
523: );
524:
525: INSERT INTO igs_fi_1098t_data (
526: object_version_number,
527: stu_1098t_id,
528: tax_year_name,
529: party_id,

Line 575: igs_fi_1098t_data_s.NEXTVAL,

571: program_application_id,
572: program_update_date
573: ) VALUES (
574: new_references.object_version_number,
575: igs_fi_1098t_data_s.NEXTVAL,
576: new_references.tax_year_name,
577: new_references.party_id,
578: new_references.extract_date,
579: new_references.party_name,

Line 714: FROM igs_fi_1098t_data

710: fin_aid_amt,
711: fin_aid_adj_amt,
712: next_acad_flag,
713: batch_id
714: FROM igs_fi_1098t_data
715: WHERE rowid = x_rowid
716: FOR UPDATE NOWAIT;
717:
718: tlinfo c1%ROWTYPE;

Line 842: FROM igs_fi_1098t_data

838: x_program_update_date DATE;
839:
840: CURSOR cur_1098t_data(cp_rowid varchar2) IS
841: SELECT object_version_number
842: FROM igs_fi_1098t_data
843: WHERE rowid = cp_rowid
844: FOR UPDATE NOWAIT;
845:
846: l_n_object_version_number igs_fi_1098t_data.object_version_number%TYPE;

Line 846: l_n_object_version_number igs_fi_1098t_data.object_version_number%TYPE;

842: FROM igs_fi_1098t_data
843: WHERE rowid = cp_rowid
844: FOR UPDATE NOWAIT;
845:
846: l_n_object_version_number igs_fi_1098t_data.object_version_number%TYPE;
847:
848: BEGIN
849:
850: OPEN cur_1098t_data(x_rowid);

Line 869: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_DATA_PKG.UPDATE_ROW');

865: x_last_update_login := -1;
866: END IF;
867: ELSE
868: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
869: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_DATA_PKG.UPDATE_ROW');
870: igs_ge_msg_stack.add;
871: app_exception.raise_exception;
872: END IF;
873:

Line 940: UPDATE igs_fi_1098t_data

936: x_program_update_date := SYSDATE;
937: END IF;
938: END IF;
939:
940: UPDATE igs_fi_1098t_data
941: SET
942: object_version_number = new_references.object_version_number,
943: tax_year_name = new_references.tax_year_name,
944: party_id = new_references.party_id,

Line 1047: FROM igs_fi_1098t_data

1043: || (reverse chronological order - newest change first)
1044: */
1045: CURSOR c1 IS
1046: SELECT rowid
1047: FROM igs_fi_1098t_data
1048: WHERE stu_1098t_id = x_stu_1098t_id;
1049:
1050: BEGIN
1051:

Line 1166: DELETE FROM igs_fi_1098t_data

1162: p_action => 'DELETE',
1163: x_rowid => x_rowid
1164: );
1165:
1166: DELETE FROM igs_fi_1098t_data
1167: WHERE rowid = x_rowid;
1168:
1169: IF (SQL%NOTFOUND) THEN
1170: RAISE NO_DATA_FOUND;

Line 1176: END igs_fi_1098t_data_pkg;

1172:
1173: END delete_row;
1174:
1175:
1176: END igs_fi_1098t_data_pkg;