APPS.PQH_RBC_UTILITY dependencies on PQH_CRITERIA_RATE_DEFN

Line 1118: insert into pqh_criteria_rate_defn_tl(CRITERIA_RATE_DEFN_ID,NAME,LANGUAGE,

1114: cdate in date,
1115: cperson in number) is
1116: begin
1117:
1118: insert into pqh_criteria_rate_defn_tl(CRITERIA_RATE_DEFN_ID,NAME,LANGUAGE,
1119: SOURCE_LANG,CREATION_DATE,CREATED_BY)
1120: values(rateid,ratename,lang,slang,cdate,cperson);
1121: commit;
1122:

Line 1167: l_name pqh_criteria_rate_defn_vl.short_name%TYPE;

1163: PROCEDURE is_crit_rate_short_name_uniq( sname in varchar2,
1164: rateId in number,
1165: bgId in number,
1166: isValid out nocopy varchar2)is
1167: l_name pqh_criteria_rate_defn_vl.short_name%TYPE;
1168: cursor c11 is
1169: SELECT SHORT_NAME FROM pqh_criteria_rate_defn_vl
1170: where upper(short_name) = upper(sname)
1171: and CRITERIA_RATE_DEFN_ID <> rateId

Line 1169: SELECT SHORT_NAME FROM pqh_criteria_rate_defn_vl

1165: bgId in number,
1166: isValid out nocopy varchar2)is
1167: l_name pqh_criteria_rate_defn_vl.short_name%TYPE;
1168: cursor c11 is
1169: SELECT SHORT_NAME FROM pqh_criteria_rate_defn_vl
1170: where upper(short_name) = upper(sname)
1171: and CRITERIA_RATE_DEFN_ID <> rateId
1172: and business_group_id = bgId;
1173: begin

Line 1192: l_name pqh_criteria_rate_defn_vl.name%TYPE;

1188: PROCEDURE is_crit_rate_name_uniq(cname in varchar2,
1189: rateId in number,
1190: bgId in number,
1191: isValid out nocopy varchar2)is
1192: l_name pqh_criteria_rate_defn_vl.name%TYPE;
1193: cursor c11 is
1194: SELECT NAME FROM pqh_criteria_rate_defn_vl
1195: where upper(name) = upper(cname)
1196: and CRITERIA_RATE_DEFN_ID <> rateId

Line 1194: SELECT NAME FROM pqh_criteria_rate_defn_vl

1190: bgId in number,
1191: isValid out nocopy varchar2)is
1192: l_name pqh_criteria_rate_defn_vl.name%TYPE;
1193: cursor c11 is
1194: SELECT NAME FROM pqh_criteria_rate_defn_vl
1195: where upper(name) = upper(cname)
1196: and CRITERIA_RATE_DEFN_ID <> rateId
1197: and business_group_id = bgId;
1198: begin

Line 1366: l_parent pqh_criteria_rate_defn.criteria_rate_defn_id%type;

1362: l_criteria_rate_defn_id ben_copy_entity_results.information1%type;
1363: l_criteria_rate_defn_name ben_copy_entity_results.information5%type;
1364: l_curr_order_number ben_copy_entity_results.information160%type;
1365: l_new_order_number ben_copy_entity_results.information160%type := 0;
1366: l_parent pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1367: l_curr_rate_matrix_id ben_pl_f.pl_id%type;
1368: --
1369: Cursor csr_ref_crd is
1370: Select copy_entity_result_id, information1 , nvl(information5,'name') crd_name,information160

Line 1384: from pqh_criteria_rate_factors a, pqh_criteria_rate_defn_vl b

1380: AND table_alias = 'PLN';
1381: --
1382: Cursor csr_find_parent(p_rate_matrix_id in number, p_criteria_rate_defn_id in number) is
1383: select a.parent_criteria_rate_defn_id parent_id, b.name parent_name
1384: from pqh_criteria_rate_factors a, pqh_criteria_rate_defn_vl b
1385: Where a.criteria_rate_defn_id = p_criteria_rate_defn_id
1386: and (parent_rate_matrix_id is null or parent_rate_matrix_id = p_rate_matrix_id)
1387: and a.parent_criteria_rate_defn_id = b.criteria_rate_defn_id;
1388: --

Line 1704: from pqh_criteria_rate_defn

1700: l_dfl_flag varchar(2);
1701: begin
1702: select DEFINE_MAX_RATE_FLAG, DEFINE_MIN_RATE_FLAG, DEFINE_MID_RATE_FLAG, DEFINE_STD_RATE_FLAG
1703: into l_max_flag, l_min_flag, l_mid_flag, l_dfl_flag
1704: from pqh_criteria_rate_defn
1705: where CRITERIA_RATE_DEFN_ID = critId;
1706: if( (pMaxFlag = 'Y' AND l_max_flag <> pMaxFlag) OR
1707: (pMidFlag = 'Y' AND l_mid_flag <> pMidFlag) OR
1708: (pMinFlag = 'Y' AND l_min_flag <> pMinFlag) OR