APPS.IGF_AP_INST_VER_ITEM_PKG dependencies on IGF_AP_INST_VER_ITEM_ALL

Line 5: old_references igf_ap_inst_ver_item_all%ROWTYPE;

1: PACKAGE BODY igf_ap_inst_ver_item_pkg AS
2: /* $Header: IGFAI05B.pls 115.11 2003/10/17 05:40:58 rasahoo ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_inst_ver_item_all%ROWTYPE;
6: new_references igf_ap_inst_ver_item_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_inst_ver_item_all%ROWTYPE;

2: /* $Header: IGFAI05B.pls 115.11 2003/10/17 05:40:58 rasahoo ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_inst_ver_item_all%ROWTYPE;
6: new_references igf_ap_inst_ver_item_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 37: FROM IGF_AP_INST_VER_ITEM_ALL

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

Line 123: FROM igf_ap_inst_ver_item_all

119: || (reverse chronological order - newest change first)
120: */
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igf_ap_inst_ver_item_all
124: WHERE isir_map_col = x_isir_map_col
125: AND base_id = x_base_id
126: FOR UPDATE NOWAIT;
127:

Line 159: FROM igf_ap_inst_ver_item_all

155: || (reverse chronological order - newest change first)
156: */
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM igf_ap_inst_ver_item_all
160: WHERE ((base_id = x_base_id));
161:
162: lv_rowid cur_rowid%RowType;
163:

Line 280: FROM igf_ap_inst_ver_item_all

276: || (reverse chronological order - newest change first)
277: */
278: CURSOR c IS
279: SELECT rowid
280: FROM igf_ap_inst_ver_item_all
281: WHERE isir_map_col = x_isir_map_col
282: AND base_id = x_base_id;
283:
284: x_last_update_date DATE;

Line 288: l_org_id igf_ap_inst_ver_item_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

284: x_last_update_date DATE;
285: x_last_updated_by NUMBER;
286: x_last_update_login NUMBER;
287:
288: l_org_id igf_ap_inst_ver_item_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
289:
290: BEGIN
291:
292: x_last_update_date := SYSDATE;

Line 329: INSERT INTO igf_ap_inst_ver_item_all (

325: x_last_updated_by => x_last_updated_by,
326: x_last_update_login => x_last_update_login
327: );
328:
329: INSERT INTO igf_ap_inst_ver_item_all (
330: base_id,
331: udf_vern_item_seq_num,
332: item_value,
333: waive_flag,

Line 402: FROM igf_ap_inst_ver_item_all

398: incl_in_tolerance,
399: legacy_record_flag,
400: use_blank_flag,
401: org_id
402: FROM igf_ap_inst_ver_item_all
403: WHERE rowid = x_rowid
404: FOR UPDATE NOWAIT;
405:
406: tlinfo c1%ROWTYPE;

Line 507: UPDATE igf_ap_inst_ver_item_all

503: x_last_updated_by => x_last_updated_by,
504: x_last_update_login => x_last_update_login
505: );
506:
507: UPDATE igf_ap_inst_ver_item_all
508: SET
509: item_value = new_references.item_value,
510: waive_flag = new_references.waive_flag,
511: isir_map_col = new_references.isir_map_col,

Line 550: FROM igf_ap_inst_ver_item_all

546: || (reverse chronological order - newest change first)
547: */
548: CURSOR c1 IS
549: SELECT rowid
550: FROM igf_ap_inst_ver_item_all
551: WHERE isir_map_col = x_isir_map_col
552: AND base_id = x_base_id;
553:
554: BEGIN

Line 625: DELETE FROM igf_ap_inst_ver_item_all

621: x_last_updated_by => NULL,
622: x_last_update_login => NULL
623: );
624:
625: DELETE FROM igf_ap_inst_ver_item_all
626: WHERE rowid = x_rowid;
627:
628: IF (SQL%NOTFOUND) THEN
629: RAISE NO_DATA_FOUND;