eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_AW_AWD_DIST_PLANS_PKG dependencies on IGF_AW_AWD_DIST_PLANS

Line 1: PACKAGE BODY igf_aw_awd_dist_plans_pkg AS

1: PACKAGE BODY igf_aw_awd_dist_plans_pkg AS
2: /* $Header: IGFWI59B.pls 115.5 2003/11/21 06:38:29 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_dist_plans%ROWTYPE;

Line 5: old_references igf_aw_awd_dist_plans%ROWTYPE;

1: PACKAGE BODY igf_aw_awd_dist_plans_pkg AS
2: /* $Header: IGFWI59B.pls 115.5 2003/11/21 06:38:29 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_dist_plans%ROWTYPE;
6: new_references igf_aw_awd_dist_plans%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_awd_dist_plans%ROWTYPE;

2: /* $Header: IGFWI59B.pls 115.5 2003/11/21 06:38:29 veramach noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_dist_plans%ROWTYPE;
6: new_references igf_aw_awd_dist_plans%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM igf_aw_awd_dist_plans

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

Line 119: || Added call to igf_aw_award_pkg.get_fk_igf_aw_awd_dist_plans

115: || Change History :
116: || Who When What
117: || (reverse chronological order - newest change first)
118: || veramach 10-NOV-2003 FA 125 Multiple Distr methods
119: || Added call to igf_aw_award_pkg.get_fk_igf_aw_awd_dist_plans
120: */
121: BEGIN
122:
123: igf_aw_dp_terms_pkg.get_fk_igf_aw_awd_dist_plans (

Line 123: igf_aw_dp_terms_pkg.get_fk_igf_aw_awd_dist_plans (

119: || Added call to igf_aw_award_pkg.get_fk_igf_aw_awd_dist_plans
120: */
121: BEGIN
122:
123: igf_aw_dp_terms_pkg.get_fk_igf_aw_awd_dist_plans (
124: old_references.adplans_id
125: );
126:
127: igf_aw_award_pkg.get_fk_igf_aw_awd_dist_plans (

Line 127: igf_aw_award_pkg.get_fk_igf_aw_awd_dist_plans (

123: igf_aw_dp_terms_pkg.get_fk_igf_aw_awd_dist_plans (
124: old_references.adplans_id
125: );
126:
127: igf_aw_award_pkg.get_fk_igf_aw_awd_dist_plans (
128: old_references.adplans_id
129: );
130:
131: igf_aw_target_grp_pkg.get_fk_igf_aw_awd_dist_plans (

Line 131: igf_aw_target_grp_pkg.get_fk_igf_aw_awd_dist_plans (

127: igf_aw_award_pkg.get_fk_igf_aw_awd_dist_plans (
128: old_references.adplans_id
129: );
130:
131: igf_aw_target_grp_pkg.get_fk_igf_aw_awd_dist_plans (
132: old_references.adplans_id
133: );
134:
135: igf_aw_awd_frml_det_pkg.get_fk_igf_aw_awd_dist_plans (

Line 135: igf_aw_awd_frml_det_pkg.get_fk_igf_aw_awd_dist_plans (

131: igf_aw_target_grp_pkg.get_fk_igf_aw_awd_dist_plans (
132: old_references.adplans_id
133: );
134:
135: igf_aw_awd_frml_det_pkg.get_fk_igf_aw_awd_dist_plans (
136: old_references.adplans_id
137: );
138:
139: END check_child_existance;

Line 183: FROM igf_aw_awd_dist_plans

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igf_aw_awd_dist_plans
184: WHERE ((cal_type = x_cal_type) AND
185: (sequence_number = x_sequence_number));
186:
187: lv_rowid cur_rowid%ROWTYPE;

Line 218: FROM igf_aw_awd_dist_plans

214: || (reverse chronological order - newest change first)
215: */
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM igf_aw_awd_dist_plans
219: WHERE adplans_id = x_adplans_id
220: FOR UPDATE NOWAIT;
221:
222: lv_rowid cur_rowid%RowType;

Line 259: FROM igf_aw_awd_dist_plans

255: -------------------------------------------------------------------
256:
257: CURSOR cur_rowid IS
258: SELECT rowid
259: FROM igf_aw_awd_dist_plans
260: WHERE awd_dist_plan_cd = x_awd_dist_plan_cd
261: AND cal_type = x_cal_type
262: AND sequence_number = x_sequence_number
263: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 407: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_DIST_PLANS_PKG.INSERT_ROW');

403: x_last_update_login := -1;
404: END IF;
405: ELSE
406: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
407: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_DIST_PLANS_PKG.INSERT_ROW');
408: igs_ge_msg_stack.add;
409: app_exception.raise_exception;
410: END IF;
411:

Line 431: INSERT INTO igf_aw_awd_dist_plans (

427: x_last_updated_by => x_last_updated_by,
428: x_last_update_login => x_last_update_login
429: );
430:
431: INSERT INTO igf_aw_awd_dist_plans (
432: adplans_id,
433: awd_dist_plan_cd,
434: cal_type,
435: sequence_number,

Line 445: igf_aw_awd_dist_plans_s.NEXTVAL,

441: last_update_date,
442: last_updated_by,
443: last_update_login
444: ) VALUES (
445: igf_aw_awd_dist_plans_s.NEXTVAL,
446: new_references.awd_dist_plan_cd,
447: new_references.cal_type,
448: new_references.sequence_number,
449: new_references.awd_dist_plan_cd_desc,

Line 489: FROM igf_aw_awd_dist_plans

485: sequence_number,
486: awd_dist_plan_cd_desc,
487: active_flag,
488: dist_plan_method_code
489: FROM igf_aw_awd_dist_plans
490: WHERE rowid = x_rowid
491: FOR UPDATE NOWAIT;
492:
493: tlinfo c1%ROWTYPE;

Line 569: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_DIST_PLANS_PKG.UPDATE_ROW');

565: x_last_update_login := -1;
566: END IF;
567: ELSE
568: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
569: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_DIST_PLANS_PKG.UPDATE_ROW');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:

Line 591: UPDATE igf_aw_awd_dist_plans

587: x_last_updated_by => x_last_updated_by,
588: x_last_update_login => x_last_update_login
589: );
590:
591: UPDATE igf_aw_awd_dist_plans
592: SET
593: awd_dist_plan_cd = new_references.awd_dist_plan_cd,
594: cal_type = new_references.cal_type,
595: sequence_number = new_references.sequence_number,

Line 633: FROM igf_aw_awd_dist_plans

629: || (reverse chronological order - newest change first)
630: */
631: CURSOR c1 IS
632: SELECT rowid
633: FROM igf_aw_awd_dist_plans
634: WHERE adplans_id = x_adplans_id;
635:
636: BEGIN
637:

Line 692: DELETE FROM igf_aw_awd_dist_plans

688: p_action => 'DELETE',
689: x_rowid => x_rowid
690: );
691:
692: DELETE FROM igf_aw_awd_dist_plans
693: WHERE rowid = x_rowid;
694:
695: IF (SQL%NOTFOUND) THEN
696: RAISE NO_DATA_FOUND;

Line 702: END igf_aw_awd_dist_plans_pkg;

698:
699: END delete_row;
700:
701:
702: END igf_aw_awd_dist_plans_pkg;