816: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
817: --
818: l_language varchar2(30) ;
819:
820: Cursor c1 is select userenv('LANG') from dual ;
821: --
822: -- Check if the criteria rate defn exists
823: --
824: Cursor csr_crd is
827: and business_group_id = l_business_group_id;
828: --
829: Cursor csr_crd_seq is
830: Select pqh_criteria_rate_defn_s.nextval
831: From dual;
832: Begin
833: --
834: -- populate WHO columns
835: --
1052: l_last_update_login pqh_criteria_rate_factors.last_update_login%TYPE;
1053: --
1054: l_language varchar2(30) ;
1055:
1056: Cursor c1 is select userenv('LANG') from dual ;
1057: --
1058: -- Check if the criteria rate defn exists
1059: --
1060: Cursor csr_crd is
1074: and business_group_id = l_business_group_id;
1075: --
1076: Cursor csr_crf_seq is
1077: Select pqh_criteria_rate_factors_s.nextval
1078: From dual;
1079:
1080: /* Cursor csr_prm is
1081: select pl_id from ben_pl_f
1082: where short_code = p_parent_rate_matrix_code
1202: l_last_update_login pqh_rate_factor_on_elmnts.last_update_login%TYPE;
1203: --
1204: l_language varchar2(30) ;
1205:
1206: Cursor c1 is select userenv('LANG') from dual ;
1207: --
1208: -- Check if the criteria rate defn exists
1209: --
1210: Cursor csr_crd is
1262:
1263:
1264: Cursor csr_rfe_seq is
1265: Select pqh_rate_factor_on_elmnts_s.nextval
1266: From dual;
1267:
1268: Begin
1269: --
1270: -- populate WHO columns
1425: and business_group_id = l_business_group_id;
1426: --
1427: Cursor csr_cre_seq is
1428: Select pqh_criteria_rate_elements_s.nextval
1429: From dual;
1430:
1431:
1432: Cursor c1 is select userenv('LANG') from dual ;
1433:
1428: Select pqh_criteria_rate_elements_s.nextval
1429: From dual;
1430:
1431:
1432: Cursor c1 is select userenv('LANG') from dual ;
1433:
1434: Begin
1435: --
1436: -- populate WHO columns
1548: l_language varchar2(30) ;
1549:
1550:
1551:
1552: Cursor c1 is select userenv('LANG') from dual ;
1553:
1554: Cursor csr_crd is
1555: select criteria_rate_defn_id from pqh_criteria_rate_defn
1556: where short_name = p_crit_rt_defn_short_name
1601: --
1602: --
1603: Cursor csr_rer_seq is
1604: Select pqh_rate_element_relations_s.nextval
1605: From dual;
1606:
1607:
1608: Begin
1609: --