APPS.IGF_AP_ISIR_CORR_PKG dependencies on IGF_AP_ISIR_CORR_ALL

Line 5: old_references igf_ap_isir_corr_all%ROWTYPE;

1: PACKAGE BODY igf_ap_isir_corr_pkg AS
2: /* $Header: IGFAI21B.pls 120.1 2005/10/28 05:41:00 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_isir_corr_all%ROWTYPE;
6: new_references igf_ap_isir_corr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_isir_corr_all%ROWTYPE;

2: /* $Header: IGFAI21B.pls 120.1 2005/10/28 05:41:00 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_isir_corr_all%ROWTYPE;
6: new_references igf_ap_isir_corr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGF_AP_ISIR_CORR_ALL

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGF_AP_ISIR_CORR_ALL
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 164: FROM igf_ap_isir_corr_all

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igf_ap_isir_corr_all
165: WHERE isirc_id = x_isirc_id
166: FOR UPDATE NOWAIT;
167:
168: lv_rowid cur_rowid%RowType;

Line 201: FROM igf_ap_isir_corr_all

197: || (reverse chronological order - newest change first)
198: */
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM igf_ap_isir_corr_all
202: WHERE isir_id = x_isir_id
203: AND ((sar_field_number = x_sar_field_number) OR (sar_field_number IS NULL AND x_sar_field_number IS NULL))
204: AND ((correction_status = x_correction_status) OR (correction_status IS NULL AND x_correction_status IS NULL))
205: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 240: FROM igf_ap_isir_corr_all

236: || (reverse chronological order - newest change first)
237: */
238: CURSOR cur_rowid IS
239: SELECT rowid
240: FROM igf_ap_isir_corr_all
241: WHERE ((isir_id = x_isir_id));
242:
243: lv_rowid cur_rowid%RowType;
244:

Line 250: FROM igf_ap_isir_corr_all

246: -- If the number is 0, all of them can be deleted.
247: -- Else, throw error.
248: CURSOR c_non_ack_corr_count(cp_isir_id NUMBER) IS
249: SELECT count(*) cnt
250: FROM igf_ap_isir_corr_all
251: WHERE isir_id = cp_isir_id
252: AND correction_status <> 'ACKNOWLEDGED';
253:
254: l_non_ack_corr_count NUMBER;

Line 296: FROM igf_ap_isir_corr_all

292: || (reverse chronological order - newest change first)
293: */
294: CURSOR cur_rowid IS
295: SELECT rowid
296: FROM igf_ap_isir_corr_all
297: WHERE ((ci_cal_type = x_cal_type) AND
298: (ci_sequence_number = x_sequence_number));
299:
300: lv_rowid cur_rowid%RowType;

Line 425: FROM igf_ap_isir_corr_all

421: || (reverse chronological order - newest change first)
422: */
423: CURSOR c IS
424: SELECT rowid
425: FROM igf_ap_isir_corr_all
426: WHERE isirc_id = x_isirc_id;
427:
428: CURSOR cur_seq IS
429: SELECT igf_ap_isir_corr_s.nextval

Line 439: l_org_id igf_ap_isir_corr_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

435: x_request_id NUMBER;
436: x_program_id NUMBER;
437: x_program_application_id NUMBER;
438: x_program_update_date DATE;
439: l_org_id igf_ap_isir_corr_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
440:
441: BEGIN
442:
443: OPEN cur_seq;

Line 497: INSERT INTO igf_ap_isir_corr_all (

493: x_last_updated_by => x_last_updated_by,
494: x_last_update_login => x_last_update_login
495: );
496:
497: INSERT INTO igf_ap_isir_corr_all (
498: isirc_id,
499: isir_id,
500: ci_sequence_number,
501: ci_cal_type,

Line 582: FROM igf_ap_isir_corr_all

578: batch_id,
579: corrected_value,
580: correction_status,
581: org_id
582: FROM igf_ap_isir_corr_all
583: WHERE rowid = x_rowid
584: FOR UPDATE NOWAIT;
585:
586: tlinfo c1%ROWTYPE;

Line 707: UPDATE igf_ap_isir_corr_all

703: x_program_update_date := SYSDATE;
704: END IF;
705: END IF;
706:
707: UPDATE igf_ap_isir_corr_all
708: SET
709: isir_id = new_references.isir_id,
710: ci_sequence_number = new_references.ci_sequence_number,
711: ci_cal_type = new_references.ci_cal_type,

Line 757: FROM igf_ap_isir_corr_all

753: || (reverse chronological order - newest change first)
754: */
755: CURSOR c1 IS
756: SELECT rowid
757: FROM igf_ap_isir_corr_all
758: WHERE isirc_id = x_isirc_id;
759:
760: BEGIN
761:

Line 820: DELETE FROM igf_ap_isir_corr_all

816: p_action => 'DELETE',
817: x_rowid => x_rowid
818: );
819:
820: DELETE FROM igf_ap_isir_corr_all
821: WHERE rowid = x_rowid;
822:
823: IF (SQL%NOTFOUND) THEN
824: RAISE NO_DATA_FOUND;