APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_DP_TEACH_PRDS

Line 1496: p_plan_tp_rec IN igf_aw_dp_teach_prds%ROWTYPE,

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: )
1500: RETURN igf_aw_dp_teach_prds.adteach_id%TYPE IS

Line 1500: RETURN igf_aw_dp_teach_prds.adteach_id%TYPE IS

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: )
1500: RETURN igf_aw_dp_teach_prds.adteach_id%TYPE IS
1501: --------------------------------------------------------------------------------
1502: -- Created by : ridas, Oracle India
1503: -- Date created: 20-MAY-2005
1504:

Line 1511: l_adteach_id igf_aw_dp_teach_prds.adteach_id%TYPE := NULL;

1507: --
1508: --------------------------------------------------------------------------------
1509:
1510: l_rowid VARCHAR2(25):= NULL;
1511: l_adteach_id igf_aw_dp_teach_prds.adteach_id%TYPE := NULL;
1512:
1513: BEGIN
1514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_tp.debug','Insert teaching period attached to the term');

Line 1518: igf_aw_dp_teach_prds_pkg.insert_row (

1514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_tp.debug','Insert teaching period attached to the term');
1516: END IF;
1517:
1518: igf_aw_dp_teach_prds_pkg.insert_row (
1519: x_mode => 'R',
1520: x_rowid => l_rowid,
1521: x_adteach_id => l_adteach_id,
1522: x_adterms_id => p_adterms_id,

Line 1588: FROM igf_aw_dp_teach_prds plan_tp

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
1590: ORDER BY plan_tp.adteach_id;
1591:
1592:

Line 1600: l_adteach_id igf_aw_dp_teach_prds.adteach_id%TYPE := NULL;

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:
1604: BEGIN