APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_DP_TERMS

Line 1456: p_plan_term_rec IN igf_aw_dp_terms%ROWTYPE,

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: )
1460: RETURN igf_aw_dp_terms.adterms_id%TYPE IS

Line 1460: RETURN igf_aw_dp_terms.adterms_id%TYPE IS

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: )
1460: RETURN igf_aw_dp_terms.adterms_id%TYPE IS
1461: --------------------------------------------------------------------------------
1462: -- Created by : ridas, Oracle India
1463: -- Date created: 20-MAY-2005
1464:

Line 1471: l_adterms_id igf_aw_dp_terms.adterms_id%TYPE := NULL;

1467: --
1468: --------------------------------------------------------------------------------
1469:
1470: l_rowid VARCHAR2(25):= NULL;
1471: l_adterms_id igf_aw_dp_terms.adterms_id%TYPE := NULL;
1472:
1473: BEGIN
1474:
1475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1479: igf_aw_dp_terms_pkg.insert_row (

1475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1476: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_term.debug','Insert term attached to the plan');
1477: END IF;
1478:
1479: igf_aw_dp_terms_pkg.insert_row (
1480: x_mode => 'R',
1481: x_rowid => l_rowid,
1482: x_adterms_id => l_adterms_id,
1483: x_adplans_id => p_adplans_id,

Line 1495: FUNCTION create_new_plan_tp ( p_adterms_id IN igf_aw_dp_terms.adterms_id%TYPE,

1491: END create_new_plan_term;
1492:
1493:
1494: -- Procedure to create a new distribution plan teaching period for the target award year
1495: FUNCTION create_new_plan_tp ( p_adterms_id IN igf_aw_dp_terms.adterms_id%TYPE,
1496: p_plan_tp_rec IN igf_aw_dp_teach_prds%ROWTYPE,
1497: p_to_tp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1498: p_to_tp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1499: )

Line 1579: FROM igf_aw_dp_terms plan_term

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
1581: ORDER BY plan_term.adterms_id;
1582:
1583:

Line 1585: CURSOR c_distb_plan_tp( cp_adterms_id igf_aw_dp_terms.adterms_id%TYPE

1581: ORDER BY plan_term.adterms_id;
1582:
1583:
1584: -- Get the Award Distribution Plan Teaching Periods attached to the Plan Term Id
1585: CURSOR c_distb_plan_tp( cp_adterms_id igf_aw_dp_terms.adterms_id%TYPE
1586: ) IS
1587: SELECT plan_tp.*
1588: FROM igf_aw_dp_teach_prds plan_tp
1589: WHERE plan_tp.adterms_id = cp_adterms_id

Line 1599: l_adterms_id igf_aw_dp_terms.adterms_id%TYPE := NULL;

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';
1603: