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.

APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_AWD_DIST_PLANS

Line 1414: FUNCTION create_new_plan ( p_plan_rec IN igf_aw_awd_dist_plans%ROWTYPE,

1410:
1411:
1412:
1413: -- Procedure to create a new award distribution plan for the target award year
1414: FUNCTION create_new_plan ( p_plan_rec IN igf_aw_awd_dist_plans%ROWTYPE,
1415: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1416: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1417: )
1418: RETURN igf_aw_awd_dist_plans.adplans_id%TYPE IS

Line 1418: RETURN igf_aw_awd_dist_plans.adplans_id%TYPE IS

1414: FUNCTION create_new_plan ( p_plan_rec IN igf_aw_awd_dist_plans%ROWTYPE,
1415: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1416: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1417: )
1418: RETURN igf_aw_awd_dist_plans.adplans_id%TYPE IS
1419: --------------------------------------------------------------------------------
1420: -- Created by : ridas, Oracle India
1421: -- Date created: 20-MAY-2005
1422:

Line 1429: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;

1425: --
1426: --------------------------------------------------------------------------------
1427:
1428: l_rowid VARCHAR2(25):= NULL;
1429: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
1430:
1431: BEGIN
1432:
1433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1437: igf_aw_awd_dist_plans_pkg.insert_row (

1433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan.debug','Insert an Award Distribution Plan');
1435: END IF;
1436:
1437: igf_aw_awd_dist_plans_pkg.insert_row (
1438: x_mode => 'R',
1439: x_rowid => l_rowid,
1440: x_adplans_id => l_adplans_id,
1441: x_awd_dist_plan_cd => p_plan_rec.awd_dist_plan_cd,

Line 1455: FUNCTION create_new_plan_term ( p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

1451: END create_new_plan;
1452:
1453:
1454: -- Procedure to create a new distribution plan term for the target award year
1455: FUNCTION create_new_plan_term ( p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1456: p_plan_term_rec IN igf_aw_dp_terms%ROWTYPE,
1457: p_to_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1458: p_to_ld_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1459: )

Line 1557: FROM igf_aw_awd_dist_plans plan

1553: CURSOR c_distb_plan_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1554: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1555: ) IS
1556: SELECT plan.*
1557: FROM igf_aw_awd_dist_plans plan
1558: WHERE plan.cal_type = cp_frm_cal_type
1559: AND plan.sequence_number = cp_frm_sequence_number
1560: ORDER BY plan.awd_dist_plan_cd;
1561:

Line 1565: cp_awd_dist_plan_cd igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE

1561:
1562: -- Check whether the fund already exists or not
1563: CURSOR c_plan_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1564: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1565: cp_awd_dist_plan_cd igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE
1566: ) IS
1567: SELECT 'X' exist
1568: FROM igf_aw_awd_dist_plans plan
1569: WHERE plan.cal_type = cp_to_cal_type

Line 1568: FROM igf_aw_awd_dist_plans plan

1564: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1565: cp_awd_dist_plan_cd igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE
1566: ) IS
1567: SELECT 'X' exist
1568: FROM igf_aw_awd_dist_plans plan
1569: WHERE plan.cal_type = cp_to_cal_type
1570: AND plan.sequence_number = cp_to_sequence_number
1571: AND plan.awd_dist_plan_cd = cp_awd_dist_plan_cd;
1572:

Line 1576: CURSOR c_distb_plan_term( cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

1572:
1573: l_plan_exists c_plan_exists%ROWTYPE;
1574:
1575: -- Get the Award Distribution Plan Terms attached to the Plan Id
1576: CURSOR c_distb_plan_term( cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1577: ) IS
1578: SELECT plan_term.*
1579: FROM igf_aw_dp_terms plan_term
1580: WHERE plan_term.adplans_id = cp_adplans_id

Line 1598: l_new_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;

1594: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1595: l_to_tp_cal_type igs_ca_inst_all.cal_type%TYPE;
1596: l_to_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1597: l_rowid VARCHAR2(25);
1598: l_new_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
1599: l_adterms_id igf_aw_dp_terms.adterms_id%TYPE := NULL;
1600: l_adteach_id igf_aw_dp_teach_prds.adteach_id%TYPE := NULL;
1601: E_SKIP_PLAN EXCEPTION;
1602: l_error_occurred VARCHAR2(1) := 'N';

Line 2248: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

2244:
2245:
2246: --Function to return Award Distribution Plan Code
2247: FUNCTION get_plan_cd(
2248: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
2249: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2250: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2251: )
2252: RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE AS

Line 2252: RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE AS

2248: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
2249: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2250: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
2251: )
2252: RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE AS
2253: ------------------------------------------------------------------
2254: --Created by : ridas, Oracle India
2255: --Date created: 24-MAY-2005
2256: --

Line 2268: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

2264: -------------------------------------------------------------------
2265:
2266: -- Get plan code
2267: CURSOR c_plan(
2268: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
2269: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2270: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
2271: ) IS
2272: SELECT awd_dist_plan_cd

Line 2273: FROM igf_aw_awd_dist_plans

2269: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2270: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
2271: ) IS
2272: SELECT awd_dist_plan_cd
2273: FROM igf_aw_awd_dist_plans
2274: WHERE adplans_id = cp_adplans_id
2275: AND cal_type = cp_cal_type
2276: AND sequence_number = cp_sequence_number;
2277:

Line 2391: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

2387: CURSOR c_plan_exists (cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2388: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2389: cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2390: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2391: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
2392: ) IS
2393: SELECT plan.adplans_id
2394: FROM igf_aw_awd_dist_plans plan
2395: WHERE plan.cal_type = cp_to_cal_type

Line 2394: FROM igf_aw_awd_dist_plans plan

2390: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2391: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
2392: ) IS
2393: SELECT plan.adplans_id
2394: FROM igf_aw_awd_dist_plans plan
2395: WHERE plan.cal_type = cp_to_cal_type
2396: AND plan.sequence_number = cp_to_sequence_number
2397: AND plan.awd_dist_plan_cd IN
2398: ( SELECT plan_cd.awd_dist_plan_cd

Line 2399: FROM igf_aw_awd_dist_plans plan_cd

2395: WHERE plan.cal_type = cp_to_cal_type
2396: AND plan.sequence_number = cp_to_sequence_number
2397: AND plan.awd_dist_plan_cd IN
2398: ( SELECT plan_cd.awd_dist_plan_cd
2399: FROM igf_aw_awd_dist_plans plan_cd
2400: WHERE plan_cd.cal_type = cp_frm_cal_type
2401: AND plan_cd.sequence_number = cp_frm_sequence_number
2402: AND plan_cd.adplans_id = cp_adplans_id
2403: );

Line 2436: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;

2432: l_rowid VARCHAR2(25):= NULL;
2433: l_tgrp_id igf_aw_target_grp_all.tgrp_id%TYPE;
2434: E_SKIP_AWARD_GRP EXCEPTION;
2435: l_error_occurred VARCHAR2(1) := 'N';
2436: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
2437:
2438: BEGIN
2439:
2440: fnd_file.new_line(fnd_file.log,1);