APPS.IGF_AP_OUTCORR_WF_PKG dependencies on IGF_AP_OUTCORR_WF

Line 1: PACKAGE BODY igf_ap_outcorr_wf_pkg AS

1: PACKAGE BODY igf_ap_outcorr_wf_pkg AS
2: /* $Header: IGFAI52B.pls 120.0 2005/06/01 14:03:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_outcorr_wf%ROWTYPE;

Line 5: old_references igf_ap_outcorr_wf%ROWTYPE;

1: PACKAGE BODY igf_ap_outcorr_wf_pkg AS
2: /* $Header: IGFAI52B.pls 120.0 2005/06/01 14:03:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_outcorr_wf%ROWTYPE;
6: new_references igf_ap_outcorr_wf%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_outcorr_wf%ROWTYPE;

2: /* $Header: IGFAI52B.pls 120.0 2005/06/01 14:03:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_outcorr_wf%ROWTYPE;
6: new_references igf_ap_outcorr_wf%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGF_AP_OUTCORR_WF

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

Line 90: FROM igf_ap_outcorr_wf

86: || (reverse chronological order - newest change first)
87: */
88: CURSOR cur_rowid IS
89: SELECT rowid
90: FROM igf_ap_outcorr_wf
91: WHERE ow_id = x_ow_id
92: FOR UPDATE NOWAIT;
93:
94: lv_rowid cur_rowid%RowType;

Line 190: FROM igf_ap_outcorr_wf

186: || (reverse chronological order - newest change first)
187: */
188: CURSOR c IS
189: SELECT rowid
190: FROM igf_ap_outcorr_wf
191: WHERE ow_id = x_ow_id;
192:
193:
194: x_last_update_date DATE;

Line 219: select igf_ap_outcorr_wf_s.nextval INTO x_ow_id FROM dual;

215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218:
219: select igf_ap_outcorr_wf_s.nextval INTO x_ow_id FROM dual;
220:
221: before_dml(
222: p_action => 'INSERT',
223: x_rowid => x_rowid,

Line 236: INSERT INTO igf_ap_outcorr_wf (

232: x_last_updated_by => x_last_updated_by,
233: x_last_update_login => x_last_update_login
234: );
235:
236: INSERT INTO igf_ap_outcorr_wf (
237: person_number,
238: given_names,
239: transaction_number,
240: item_key,

Line 296: FROM igf_ap_outcorr_wf

292: given_names,
293: transaction_number,
294: item_key,
295: ow_id
296: FROM igf_ap_outcorr_wf
297: WHERE rowid = x_rowid
298: FOR UPDATE NOWAIT;
299:
300: tlinfo c1%ROWTYPE;

Line 393: UPDATE igf_ap_outcorr_wf

389: x_last_updated_by => x_last_updated_by,
390: x_last_update_login => x_last_update_login
391: );
392:
393: UPDATE igf_ap_outcorr_wf
394: SET
395: person_number = new_references.person_number,
396: given_names = new_references.given_names,
397: transaction_number = new_references.transaction_number,

Line 433: FROM igf_ap_outcorr_wf

429: || (reverse chronological order - newest change first)
430: */
431: CURSOR c1 IS
432: SELECT rowid
433: FROM igf_ap_outcorr_wf
434: WHERE ow_id = x_ow_id;
435:
436:
437: BEGIN

Line 489: DELETE FROM igf_ap_outcorr_wf

485: p_action => 'DELETE',
486: x_rowid => x_rowid
487: );
488:
489: DELETE FROM igf_ap_outcorr_wf
490: WHERE rowid = x_rowid;
491:
492: IF (SQL%NOTFOUND) THEN
493: RAISE NO_DATA_FOUND;

Line 499: END igf_ap_outcorr_wf_pkg;

495:
496: END delete_row;
497:
498:
499: END igf_ap_outcorr_wf_pkg;