APPS.IGF_AW_FN_RPKG_PRTY_PKG dependencies on IGF_AW_FN_RPKG_PRTY

Line 1: PACKAGE BODY igf_aw_fn_rpkg_prty_pkg AS

1: PACKAGE BODY igf_aw_fn_rpkg_prty_pkg AS
2: /* $Header: IGFWI67B.pls 120.0 2005/06/01 15:20:43 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fn_rpkg_prty%ROWTYPE;

Line 5: old_references igf_aw_fn_rpkg_prty%ROWTYPE;

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

Line 6: new_references igf_aw_fn_rpkg_prty%ROWTYPE;

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

Line 33: FROM igf_aw_fn_rpkg_prty

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

Line 116: FROM igf_aw_fn_rpkg_prty

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igf_aw_fn_rpkg_prty
117: WHERE ci_cal_type = x_ci_cal_type
118: AND ci_sequence_number = x_ci_sequence_number
119: AND fund_order_num = x_fund_order_num
120: FOR UPDATE NOWAIT;

Line 155: FROM igf_aw_fn_rpkg_prty

151: || (reverse chronological order - newest change first)
152: */
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM igf_aw_fn_rpkg_prty
156: WHERE ci_cal_type = x_ci_cal_type
157: AND ci_sequence_number = x_ci_sequence_number
158: AND fund_id = x_fund_id
159: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 292: fnd_message.set_token ('ROUTINE', 'IGF_AW_FN_RPKG_PRTY_PKG.INSERT_ROW');

288: x_last_update_login := -1;
289: END IF;
290: ELSE
291: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
292: fnd_message.set_token ('ROUTINE', 'IGF_AW_FN_RPKG_PRTY_PKG.INSERT_ROW');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296:

Line 311: INSERT INTO igf_aw_fn_rpkg_prty (

307: x_last_updated_by => x_last_updated_by,
308: x_last_update_login => x_last_update_login
309: );
310:
311: INSERT INTO igf_aw_fn_rpkg_prty (
312: ci_cal_type,
313: ci_sequence_number,
314: fund_order_num,
315: fund_id,

Line 355: FROM igf_aw_fn_rpkg_prty

351: */
352: CURSOR c1 IS
353: SELECT
354: fund_id
355: FROM igf_aw_fn_rpkg_prty
356: WHERE rowid = x_rowid
357: FOR UPDATE NOWAIT;
358:
359: tlinfo c1%ROWTYPE;

Line 427: fnd_message.set_token ('ROUTINE', 'IGF_AW_FN_RPKG_PRTY_PKG.UPDATE_ROW');

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

Line 446: UPDATE igf_aw_fn_rpkg_prty

442: x_last_updated_by => x_last_updated_by,
443: x_last_update_login => x_last_update_login
444: );
445:
446: UPDATE igf_aw_fn_rpkg_prty
447: SET
448: fund_id = new_references.fund_id,
449: fund_order_num = new_references.fund_order_num,
450: last_update_date = x_last_update_date,

Line 481: FROM igf_aw_fn_rpkg_prty

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

Line 536: DELETE FROM igf_aw_fn_rpkg_prty

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

Line 546: END igf_aw_fn_rpkg_prty_pkg;

542:
543: END delete_row;
544:
545:
546: END igf_aw_fn_rpkg_prty_pkg;