APPS.IGF_AP_ST_INST_APPL_PKG dependencies on IGF_AP_ST_INST_APPL_ALL

Line 14: old_references igf_ap_st_inst_appl_all%ROWTYPE;

10: || (reverse chronological order - newest change first)
11: */
12:
13: l_rowid VARCHAR2(25);
14: old_references igf_ap_st_inst_appl_all%ROWTYPE;
15: new_references igf_ap_st_inst_appl_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,

Line 15: new_references igf_ap_st_inst_appl_all%ROWTYPE;

11: */
12:
13: l_rowid VARCHAR2(25);
14: old_references igf_ap_st_inst_appl_all%ROWTYPE;
15: new_references igf_ap_st_inst_appl_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 43: FROM IGF_AP_ST_INST_APPL_ALL

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

Line 162: FROM igf_ap_st_inst_appl_all

158: || (reverse chronological order - newest change first)
159: */
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM igf_ap_st_inst_appl_all
163: WHERE inst_app_id = x_inst_app_id
164: FOR UPDATE NOWAIT;
165:
166: lv_rowid cur_rowid%RowType;

Line 199: FROM igf_ap_st_inst_appl_all

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igf_ap_st_inst_appl_all
200: WHERE base_id = x_base_id
201: AND question_id = x_question_id
202: AND application_code = x_application_code
203: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 236: FROM igf_ap_st_inst_appl_all

232: || (reverse chronological order - newest change first)
233: */
234: CURSOR cur_rowid IS
235: SELECT rowid
236: FROM igf_ap_st_inst_appl_all
237: WHERE ((question_id = x_question_id));
238:
239: lv_rowid cur_rowid%RowType;
240:

Line 271: FROM igf_ap_st_inst_appl_all

267: || (reverse chronological order - newest change first)
268: */
269: CURSOR cur_rowid IS
270: SELECT rowid
271: FROM igf_ap_st_inst_appl_all
272: WHERE ((base_id = x_base_id));
273:
274: lv_rowid cur_rowid%RowType;
275:

Line 306: FROM igf_ap_st_inst_appl_all

302: || (reverse chronological order - newest change first)
303: */
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM igf_ap_st_inst_appl_all
307: WHERE ((base_id = x_base_id)
308: AND (application_code=x_application_code));
309:
310: lv_rowid cur_rowid%RowType;

Line 423: FROM igf_ap_st_inst_appl_all

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

Line 430: l_org_id igf_ap_st_inst_appl_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

426: x_last_update_date DATE;
427: x_last_updated_by NUMBER;
428: x_last_update_login NUMBER;
429:
430: l_org_id igf_ap_st_inst_appl_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
431:
432: BEGIN
433:
434: x_last_update_date := SYSDATE;

Line 468: INSERT INTO igf_ap_st_inst_appl_all (

464: x_last_update_login => x_last_update_login,
465: x_application_code => x_application_code
466: );
467:
468: INSERT INTO igf_ap_st_inst_appl_all (
469: inst_app_id,
470: base_id,
471: question_id,
472: question_value,

Line 529: FROM igf_ap_st_inst_appl_all

525: question_id,
526: question_value,
527: org_id,
528: application_code
529: FROM igf_ap_st_inst_appl_all
530: WHERE rowid = x_rowid
531: FOR UPDATE NOWAIT;
532:
533: tlinfo c1%ROWTYPE;

Line 626: UPDATE igf_ap_st_inst_appl_all

622: x_last_update_login => x_last_update_login,
623: x_application_code => x_application_code
624: );
625:
626: UPDATE igf_ap_st_inst_appl_all
627: SET
628: base_id = new_references.base_id,
629: question_id = new_references.question_id,
630: question_value = new_references.question_value,

Line 664: FROM igf_ap_st_inst_appl_all

660: || (reverse chronological order - newest change first)
661: */
662: CURSOR c1 IS
663: SELECT rowid
664: FROM igf_ap_st_inst_appl_all
665: WHERE inst_app_id = x_inst_app_id;
666:
667: BEGIN
668:

Line 719: DELETE FROM igf_ap_st_inst_appl_all

715: p_action => 'DELETE',
716: x_rowid => x_rowid
717: );
718:
719: DELETE FROM igf_ap_st_inst_appl_all
720: WHERE rowid = x_rowid;
721:
722: IF (SQL%NOTFOUND) THEN
723: RAISE NO_DATA_FOUND;