APPS.IGF_AP_ST_CORR_TEXT_PKG dependencies on IGF_AP_ST_CORR_TEXT

Line 1: PACKAGE BODY igf_ap_st_corr_text_pkg AS

1: PACKAGE BODY igf_ap_st_corr_text_pkg AS
2: /* $Header: IGFAI39B.pls 115.4 2002/11/28 13:59:58 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_st_corr_text%ROWTYPE;

Line 5: old_references igf_ap_st_corr_text%ROWTYPE;

1: PACKAGE BODY igf_ap_st_corr_text_pkg AS
2: /* $Header: IGFAI39B.pls 115.4 2002/11/28 13:59:58 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_st_corr_text%ROWTYPE;
6: new_references igf_ap_st_corr_text%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,

Line 6: new_references igf_ap_st_corr_text%ROWTYPE;

2: /* $Header: IGFAI39B.pls 115.4 2002/11/28 13:59:58 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_st_corr_text%ROWTYPE;
6: new_references igf_ap_st_corr_text%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,
10: x_rowid IN VARCHAR2 ,

Line 34: FROM IGF_AP_ST_CORR_TEXT

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGF_AP_ST_CORR_TEXT
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 116: FROM igf_ap_st_corr_text

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igf_ap_st_corr_text
117: WHERE corsp_id = x_corsp_id
118: FOR UPDATE NOWAIT;
119:
120: lv_rowid cur_rowid%RowType;

Line 151: FROM igf_ap_st_corr_text

147: || (reverse chronological order - newest change first)
148: */
149: CURSOR cur_rowid IS
150: SELECT rowid
151: FROM igf_ap_st_corr_text
152: WHERE ((base_id = x_base_id));
153:
154: lv_rowid cur_rowid%RowType;
155:

Line 262: FROM igf_ap_st_corr_text

258: || (reverse chronological order - newest change first)
259: */
260: CURSOR c IS
261: SELECT rowid
262: FROM igf_ap_st_corr_text
263: WHERE corsp_id = x_corsp_id;
264:
265: x_last_update_date DATE;
266: x_last_updated_by NUMBER;

Line 290: SELECT igf_ap_st_corr_text_s.NEXTVAL

286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: END IF;
289:
290: SELECT igf_ap_st_corr_text_s.NEXTVAL
291: INTO x_corsp_id
292: FROM dual;
293:
294: before_dml(

Line 309: INSERT INTO igf_ap_st_corr_text (

305: x_last_updated_by => x_last_updated_by,
306: x_last_update_login => x_last_update_login
307: );
308:
309: INSERT INTO igf_ap_st_corr_text (
310: corsp_id,
311: base_id,
312: custom_text,
313: run_date,

Line 367: FROM igf_ap_st_corr_text

363: base_id,
364: custom_text,
365: run_date,
366: active
367: FROM igf_ap_st_corr_text
368: WHERE rowid = x_rowid
369: FOR UPDATE NOWAIT;
370:
371: tlinfo c1%ROWTYPE;

Line 462: UPDATE igf_ap_st_corr_text

458: x_last_updated_by => x_last_updated_by,
459: x_last_update_login => x_last_update_login
460: );
461:
462: UPDATE igf_ap_st_corr_text
463: SET
464: base_id = new_references.base_id,
465: custom_text = new_references.custom_text,
466: run_date = new_references.run_date,

Line 500: FROM igf_ap_st_corr_text

496: || (reverse chronological order - newest change first)
497: */
498: CURSOR c1 IS
499: SELECT rowid
500: FROM igf_ap_st_corr_text
501: WHERE corsp_id = x_corsp_id;
502:
503: BEGIN
504:

Line 555: DELETE FROM igf_ap_st_corr_text

551: p_action => 'DELETE',
552: x_rowid => x_rowid
553: );
554:
555: DELETE FROM igf_ap_st_corr_text
556: WHERE rowid = x_rowid;
557:
558: IF (SQL%NOTFOUND) THEN
559: RAISE NO_DATA_FOUND;

Line 565: END igf_ap_st_corr_text_pkg;

561:
562: END delete_row;
563:
564:
565: END igf_ap_st_corr_text_pkg;