APPS.PQH_RBC_RATE_RETRIEVAL dependencies on PQH_POPL_CRITERIA_OVRRD

Line 1095: (p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl ,

1091: --
1092: ----------------------------------------------------------------------------------------------------
1093: --
1094: Procedure popl_crit_list_in_ovrrd_tbl
1095: (p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl ,
1096: p_business_group_id IN number,
1097: p_effective_date IN date) is
1098: --
1099: l_proc varchar2(72) := g_package||'popl_crit_list_in_ovrrd_tbl';

Line 1100: l_crit_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;

1096: p_business_group_id IN number,
1097: p_effective_date IN date) is
1098: --
1099: l_proc varchar2(72) := g_package||'popl_crit_list_in_ovrrd_tbl';
1100: l_crit_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;
1101: cnt number(15) := 0;
1102: --
1103: Begin
1104: --

Line 1110: pqh_popl_criteria_ovrrd.init_criteria_override_tbl;

1106: --
1107: -- If the override list is already populated , populate the global override table for BEN to read.
1108: --
1109:
1110: pqh_popl_criteria_ovrrd.init_criteria_override_tbl;
1111:
1112: For cnt in 1.. p_criteria_list.count loop
1113: l_crit_val_rec.criteria_short_code := p_criteria_list(cnt).criteria_short_code;
1114: l_crit_val_rec.number_value1 := p_criteria_list(cnt).number_value1;

Line 1129: pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);

1125: l_crit_val_rec.date_value2 := p_criteria_list(cnt).date_value2;
1126: -- l_crit_val_rec.date_value3 := p_criteria_list(cnt).date_value3;
1127: -- l_crit_val_rec.date_value4 := p_criteria_list(cnt).date_value4;
1128:
1129: pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);
1130:
1131: End loop;
1132: --
1133: --

Line 1163: l_crit_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;

1159: --
1160: l_temp_cnt number := 0;
1161: l_crit_cnt number := 0;
1162: l_val_cnt number := 0;
1163: l_crit_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;
1164: --
1165: l_dummy_value1 varchar2(30);
1166: l_dummy_value2 varchar2(30);
1167: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%type;

Line 1286: pqh_popl_criteria_ovrrd.init_criteria_override_tbl;

1282: End loop;
1283: --
1284: End if;
1285: --
1286: pqh_popl_criteria_ovrrd.init_criteria_override_tbl;
1287:
1288: For l_temp_cnt in 1..l_crit_cnt loop
1289: --
1290: -- Assign the criteria short code.

Line 1335: pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);

1331: End if;
1332: --
1333: If l_dummy_value1 is not null or l_dummy_value2 is not null then
1334: --
1335: pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);
1336: --
1337: End if;
1338: --
1339: End loop;

Line 1523: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;

1519: Where assignment_id = p_assignment_id
1520: and p_effective_date between effective_start_date and effective_end_date;
1521: --
1522: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1523: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
1524: l_assignment_id per_all_assignments_f.assignment_id%type;
1525: l_person_id per_all_people_f.person_id%type;
1526: l_proc varchar2(72) := g_package||'determine_rbc_rate';
1527: --

Line 1672: p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl,

1668: Procedure determine_rbc_rate
1669: (p_element_type_id IN number default null,
1670: p_crit_rt_defn_id IN number default null,
1671: p_business_group_id IN number,
1672: p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl,
1673: p_effective_date IN date,
1674: p_rate_factors OUT nocopy g_rbc_factor_tbl,
1675: p_rate_factor_cnt OUT nocopy number,
1676: p_min_rate OUT nocopy number,

Line 1682: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;

1678: p_max_rate OUT nocopy number,
1679: p_rate OUT nocopy number) is
1680: --
1681: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1682: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
1683: --
1684: cursor csr_linked_crd is
1685: Select criteria_rate_defn_id
1686: from pqh_criteria_rate_elements

Line 1815: p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl,

1811: Function get_persons_rbc_rate
1812: (p_element_type_id IN number default null,
1813: p_crit_rt_defn_id IN number default null,
1814: p_business_group_id IN number,
1815: p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl,
1816: p_effective_date IN date)
1817: return number is
1818: --
1819: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;