APPS.IGF_AW_REPKG_PRTY_PKG dependencies on IGF_AW_REPKG_PRTY

Line 1: PACKAGE BODY igf_aw_repkg_prty_pkg AS

1: PACKAGE BODY igf_aw_repkg_prty_pkg AS
2: /* $Header: IGFWI66B.pls 120.0 2005/06/01 15:52:03 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_repkg_prty%ROWTYPE;

Line 5: old_references igf_aw_repkg_prty%ROWTYPE;

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

Line 6: new_references igf_aw_repkg_prty%ROWTYPE;

2: /* $Header: IGFWI66B.pls 120.0 2005/06/01 15:52:03 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_repkg_prty%ROWTYPE;
6: new_references igf_aw_repkg_prty%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igf_aw_repkg_prty

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

Line 114: FROM igf_aw_repkg_prty

110: || (reverse chronological order - newest change first)
111: */
112: CURSOR cur_rowid IS
113: SELECT rowid
114: FROM igf_aw_repkg_prty
115: WHERE fund_order_num = x_fund_order_num
116: FOR UPDATE NOWAIT;
117:
118: lv_rowid cur_rowid%RowType;

Line 151: FROM igf_aw_repkg_prty

147: || (reverse chronological order - newest change first)
148: */
149: CURSOR cur_rowid IS
150: SELECT rowid
151: FROM igf_aw_repkg_prty
152: WHERE sys_fund_type_code = x_sys_fund_type_code
153: AND fund_source_code = x_fund_source_code
154: AND sys_fund_code = x_sys_fund_code
155: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 284: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.INSERT_ROW');

280: x_last_update_login := -1;
281: END IF;
282: ELSE
283: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
284: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.INSERT_ROW');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288:

Line 305: INSERT INTO igf_aw_repkg_prty (

301: x_last_updated_by => x_last_updated_by,
302: x_last_update_login => x_last_update_login
303: );
304:
305: INSERT INTO igf_aw_repkg_prty (
306: fund_order_num,
307: sys_fund_type_code,
308: fund_source_code,
309: sys_fund_code,

Line 351: FROM igf_aw_repkg_prty

347: SELECT
348: sys_fund_type_code,
349: fund_source_code,
350: sys_fund_code
351: FROM igf_aw_repkg_prty
352: WHERE rowid = x_rowid
353: FOR UPDATE NOWAIT;
354:
355: tlinfo c1%ROWTYPE;

Line 425: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.UPDATE_ROW');

421: x_last_update_login := -1;
422: END IF;
423: ELSE
424: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
425: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.UPDATE_ROW');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429:

Line 444: UPDATE igf_aw_repkg_prty

440: x_last_updated_by => x_last_updated_by,
441: x_last_update_login => x_last_update_login
442: );
443:
444: UPDATE igf_aw_repkg_prty
445: SET
446: fund_order_num = new_references.fund_order_num,
447: sys_fund_type_code = new_references.sys_fund_type_code,
448: fund_source_code = new_references.fund_source_code,

Line 481: FROM igf_aw_repkg_prty

477: || (reverse chronological order - newest change first)
478: */
479: CURSOR c1 IS
480: SELECT rowid
481: FROM igf_aw_repkg_prty
482: WHERE fund_order_num = x_fund_order_num;
483:
484: BEGIN
485:

Line 534: DELETE FROM igf_aw_repkg_prty

530: p_action => 'DELETE',
531: x_rowid => x_rowid
532: );
533:
534: DELETE FROM igf_aw_repkg_prty
535: WHERE rowid = x_rowid;
536:
537: IF (SQL%NOTFOUND) THEN
538: RAISE NO_DATA_FOUND;

Line 544: END igf_aw_repkg_prty_pkg;

540:
541: END delete_row;
542:
543:
544: END igf_aw_repkg_prty_pkg;