APPS.IGF_GR_YTD_ORIG_PKG dependencies on IGF_GR_YTD_ORIG_ALL

Line 5: old_references igf_gr_ytd_orig_all%ROWTYPE;

1: PACKAGE BODY igf_gr_ytd_orig_pkg AS
2: /* $Header: IGFGI13B.pls 120.1 2006/04/06 06:08:20 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_ytd_orig_all%ROWTYPE;
6: new_references igf_gr_ytd_orig_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_ytd_orig_all%ROWTYPE;

2: /* $Header: IGFGI13B.pls 120.1 2006/04/06 06:08:20 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_ytd_orig_all%ROWTYPE;
6: new_references igf_gr_ytd_orig_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 79: FROM igf_gr_ytd_orig_all

75: */
76:
77: CURSOR cur_old_ref_values IS
78: SELECT *
79: FROM igf_gr_ytd_orig_all
80: WHERE rowid = x_rowid;
81:
82: BEGIN
83:

Line 180: FROM igf_gr_ytd_orig_all

176: || (reverse chronological order - newest change first)
177: */
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igf_gr_ytd_orig_all
181: WHERE ytdor_id = x_ytdor_id
182: FOR UPDATE NOWAIT;
183:
184: lv_rowid cur_rowid%RowType;

Line 422: FROM igf_gr_ytd_orig_all

418: || (reverse chronological order - newest change first)
419: */
420: CURSOR c IS
421: SELECT rowid
422: FROM igf_gr_ytd_orig_all
423: WHERE ytdor_id = x_ytdor_id;
424:
425: x_last_update_date DATE;
426: x_last_updated_by NUMBER;

Line 432: l_org_id igf_gr_ytd_orig_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

428: x_request_id NUMBER;
429: x_program_id NUMBER;
430: x_program_application_id NUMBER;
431: x_program_update_date DATE;
432: l_org_id igf_gr_ytd_orig_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
433:
434: BEGIN
435:
436: x_last_update_date := SYSDATE;

Line 529: INSERT INTO igf_gr_ytd_orig_all (

525: x_ci_cal_type => x_ci_cal_type,
526: x_ci_sequence_number => x_ci_sequence_number
527: );
528:
529: INSERT INTO igf_gr_ytd_orig_all (
530: ytdor_id,
531: origination_id,
532: original_ssn,
533: original_name_cd,

Line 777: FROM igf_gr_ytd_orig_all

773: batch_id,
774: process_date,
775: ci_cal_type,
776: ci_sequence_number
777: FROM igf_gr_ytd_orig_all
778: WHERE rowid = x_rowid
779: FOR UPDATE NOWAIT;
780:
781: tlinfo c1%ROWTYPE;

Line 1025: UPDATE igf_gr_ytd_orig_all

1021: x_program_update_date := SYSDATE;
1022: END IF;
1023: END IF;
1024:
1025: UPDATE igf_gr_ytd_orig_all
1026: SET
1027: origination_id = new_references.origination_id,
1028: original_ssn = new_references.original_ssn,
1029: original_name_cd = new_references.original_name_cd,

Line 1157: FROM igf_gr_ytd_orig_all

1153: || (reverse chronological order - newest change first)
1154: */
1155: CURSOR c1 IS
1156: SELECT rowid
1157: FROM igf_gr_ytd_orig_all
1158: WHERE ytdor_id = x_ytdor_id;
1159:
1160: BEGIN
1161:

Line 1302: DELETE FROM igf_gr_ytd_orig_all

1298: p_action => 'DELETE',
1299: x_rowid => x_rowid
1300: );
1301:
1302: DELETE FROM igf_gr_ytd_orig_all
1303: WHERE rowid = x_rowid;
1304:
1305: IF (SQL%NOTFOUND) THEN
1306: RAISE NO_DATA_FOUND;