APPS.IGF_AW_GEN_005 dependencies on IGF_AW_AWD_DIST_PLANS

Line 38: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

34: | |
35: *======================================================================*/
36:
37: PROCEDURE update_plan(
38: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
39: p_method_code IN VARCHAR2,
40: p_result OUT NOCOPY VARCHAR2
41: ) AS
42: ------------------------------------------------------------------

Line 56: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

52: --Who When What
53: -------------------------------------------------------------------
54: -- Get all terms associated with the plan ID
55: CURSOR c_terms(
56: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
57: ) IS
58: SELECT rowid row_id,terms.*
59: FROM igf_aw_dp_terms terms
60: WHERE adplans_id = cp_adplans_id

Line 181: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

177: app_exception.raise_exception;
178: END update_dist_plan;
179:
180: PROCEDURE check_plan_code(
181: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
182: p_result OUT NOCOPY VARCHAR2
183: ) AS
184: ------------------------------------------------------------------
185: --Created by : veramach, Oracle India

Line 199: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

195: -------------------------------------------------------------------
196:
197: -- check if a distribution plan is associated with a award group
198: CURSOR c_check_agrp(
199: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
200: ) IS
201: SELECT adplans_id
202: FROM igf_aw_target_grp
203: WHERE adplans_id = cp_adplans_id;

Line 207: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

203: WHERE adplans_id = cp_adplans_id;
204:
205: -- check if a distribution plan is associated with a target group
206: CURSOR c_check_frml(
207: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
208: ) IS
209: SELECT adplans_id
210: FROM igf_aw_awd_frml_det
211: WHERE adplans_id = cp_adplans_id;

Line 215: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

211: WHERE adplans_id = cp_adplans_id;
212:
213: -- check if a distribution plan is associated with a award
214: CURSOR c_check_awd(
215: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
216: ) IS
217: SELECT adplans_id
218: FROM igf_aw_award
219: WHERE adplans_id = cp_adplans_id;

Line 271: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

267: app_exception.raise_exception;
268: END check_plan_code;
269:
270: PROCEDURE delete_plan(
271: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
272: p_adterms_id igf_aw_dp_terms.adterms_id%TYPE
273: ) AS
274: ------------------------------------------------------------------
275: --Created by : veramach, Oracle India

Line 288: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

284: --Who When What
285: -------------------------------------------------------------------
286: -- Get all terms attached to a distribution plan
287: CURSOR c_terms(
288: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
289: cp_adterms_id igf_aw_dp_terms.adterms_id%TYPE
290: ) IS
291: SELECT rowid row_id,terms.adterms_id adterms_id
292: FROM igf_aw_dp_terms terms