eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RBC_LOAD_OBJECTS dependencies on PQH_CRITERIA_RATE_DEFN

Line 524: l_crd_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;

520: ,p_owner in varchar2
521: ) is
522:
523: --
524: l_crd_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
525: l_crd_name pqh_criteria_rate_defn.short_name%type;
526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;

Line 525: l_crd_name pqh_criteria_rate_defn.short_name%type;

521: ) is
522:
523: --
524: l_crd_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
525: l_crd_name pqh_criteria_rate_defn.short_name%type;
526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;
529: l_pl_name ben_pl_f.short_code%type;

Line 562: From pqh_criteria_rate_defn_vl

558:
559: --
560: Cursor csr_crd is
561: Select criteria_rate_defn_id,short_name
562: From pqh_criteria_rate_defn_vl
563: Where short_name = p_crit_rt_defn_short_code
564: and business_group_id = l_business_group_id;
565: --
566: -- Select activity base rate corresponding to the criteria rate defn in

Line 576: and mapping_table_name = 'PQH_CRITERIA_RATE_DEFN'

572: Where acty_typ_cd = 'RBC'
573: and l_effective_date between effective_start_date and effective_end_date
574: and business_group_id = l_business_group_id
575: and pl_id = l_pl_id
576: and mapping_table_name = 'PQH_CRITERIA_RATE_DEFN'
577: and mapping_table_pk_id = l_crd_id;
578: --
579: Cursor csr_rmr is
580: Select rate_matrix_rate_id ,object_version_number

Line 650: ,P_MAPPING_TABLE_NAME => 'PQH_CRITERIA_RATE_DEFN'

646: ,P_NAME => l_pl_name||' - '||l_crd_name
647: ,P_PL_ID => l_pl_id
648: ,P_RT_MLT_CD => 'NSVU'
649: ,P_ELE_RQD_FLAG => 'N'
650: ,P_MAPPING_TABLE_NAME => 'PQH_CRITERIA_RATE_DEFN'
651: ,P_MAPPING_TABLE_PK_ID => l_crd_id
652: ,p_object_version_number => l_ovn
653: );
654: --

Line 806: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;

802: ,p_legislation_code in varchar2 default null
803: ,p_owner in varchar2 default null
804: ) is
805: --
806: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
807: l_ovn number := 1;
808: l_effective_date date;
809: l_business_group_id hr_all_organization_units.business_group_id%type;
810: --

Line 812: l_created_by pqh_criteria_rate_defn.created_by%TYPE;

808: l_effective_date date;
809: l_business_group_id hr_all_organization_units.business_group_id%type;
810: --
811: --
812: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
813: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
814: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
815: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
816: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;

Line 813: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;

809: l_business_group_id hr_all_organization_units.business_group_id%type;
810: --
811: --
812: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
813: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
814: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
815: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
816: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
817: --

Line 814: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;

810: --
811: --
812: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
813: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
814: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
815: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
816: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
817: --
818: l_language varchar2(30) ;

Line 815: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;

811: --
812: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
813: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
814: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
815: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
816: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
817: --
818: l_language varchar2(30) ;
819:

Line 816: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;

812: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
813: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
814: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
815: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
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 ;

Line 825: select criteria_rate_defn_id from pqh_criteria_rate_defn

821: --
822: -- Check if the criteria rate defn exists
823: --
824: Cursor csr_crd is
825: select criteria_rate_defn_id from pqh_criteria_rate_defn
826: where short_name = p_short_name
827: and business_group_id = l_business_group_id;
828: --
829: Cursor csr_crd_seq is

Line 830: Select pqh_criteria_rate_defn_s.nextval

826: where short_name = p_short_name
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

Line 866: Update pqh_criteria_rate_defn

862:
863: -- No plan exists corresponding to Rate matrix short code
864: --
865: If l_criteria_rate_defn_id is not null then
866: Update pqh_criteria_rate_defn
867: set
868: short_name = p_short_name
869: ,uom = p_uom
870: ,currency_code = p_currency_code

Line 891: UPDATE pqh_criteria_rate_defn_tl

887: Where criteria_rate_defn_id = l_criteria_rate_defn_id;
888:
889: if (sql%found) then
890:
891: UPDATE pqh_criteria_rate_defn_tl
892: SET name = p_name,
893: last_updated_by = l_last_updated_by,
894: last_update_date = l_last_update_date,
895: last_update_login = l_last_update_login,

Line 904: insert into pqh_criteria_rate_defn_tl

900: If (sql%notfound) then
901: -- no row in TL table so insert row
902:
903: --
904: insert into pqh_criteria_rate_defn_tl
905: ( criteria_rate_defn_id,
906: name,
907: language,
908: source_lang,

Line 928: from pqh_criteria_rate_defn_tl crl

924: l_last_update_login
925: from fnd_languages l
926: where l.installed_flag in ('I','B')
927: and not exists (select null
928: from pqh_criteria_rate_defn_tl crl
929: where crl.criteria_rate_defn_id = l_criteria_rate_defn_id
930: and crl.language = l.language_code );
931: --
932: End if;

Line 943: Insert into pqh_criteria_rate_defn

939: Open csr_crd_seq;
940: Fetch csr_crd_seq into l_criteria_rate_defn_id;
941: Close csr_crd_seq;
942: --
943: Insert into pqh_criteria_rate_defn
944: (criteria_rate_defn_id
945: ,short_name
946: ,uom
947: ,currency_code

Line 994: insert into pqh_criteria_rate_defn_tl

990: ,l_last_update_login
991: ,l_ovn
992: );
993:
994: insert into pqh_criteria_rate_defn_tl
995: ( criteria_rate_defn_id,
996: name,
997: language,
998: source_lang,

Line 1018: from pqh_criteria_rate_defn_tl crl

1014: l_last_update_login
1015: from fnd_languages l
1016: where l.installed_flag in ('I','B')
1017: and not exists (select null
1018: from pqh_criteria_rate_defn_tl crl
1019: where crl.criteria_rate_defn_id = l_criteria_rate_defn_id
1020: and crl.language = l.language_code );
1021:
1022: End if;

Line 1038: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;

1034: ,p_legislation_code in VARCHAR2
1035: ,p_effective_start_date in varchar2
1036: ) is
1037:
1038: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1039: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1040: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1041: l_parent_rate_matrix_id pqh_criteria_rate_factors.parent_rate_matrix_id%type ;
1042:

Line 1039: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;

1035: ,p_effective_start_date in varchar2
1036: ) is
1037:
1038: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1039: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1040: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1041: l_parent_rate_matrix_id pqh_criteria_rate_factors.parent_rate_matrix_id%type ;
1042:
1043: l_effective_date Date;

Line 1061: select criteria_rate_defn_id from pqh_criteria_rate_defn

1057: --
1058: -- Check if the criteria rate defn exists
1059: --
1060: Cursor csr_crd is
1061: select criteria_rate_defn_id from pqh_criteria_rate_defn
1062: where short_name = p_crit_rt_defn_short_name
1063: and business_group_id = l_business_group_id;
1064: --
1065: Cursor csr_crdp is

Line 1066: select criteria_rate_defn_id from pqh_criteria_rate_defn

1062: where short_name = p_crit_rt_defn_short_name
1063: and business_group_id = l_business_group_id;
1064: --
1065: Cursor csr_crdp is
1066: select criteria_rate_defn_id from pqh_criteria_rate_defn
1067: where short_name = p_parent_crit_rt_def_name
1068: and business_group_id = l_business_group_id;
1069:
1070: Cursor csr_crf(crd_id in number,crdp_id in number)is

Line 1183: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;

1179: ,p_legislation_code in VARCHAR2
1180: ,p_effective_start_date in VARCHAR2
1181: ) is
1182:
1183: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1184: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1185: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1186:
1187: l_element_type_id pay_element_types_f.element_type_id%type;

Line 1184: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;

1180: ,p_effective_start_date in VARCHAR2
1181: ) is
1182:
1183: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1184: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1185: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1186:
1187: l_element_type_id pay_element_types_f.element_type_id%type;
1188: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;

Line 1211: select criteria_rate_defn_id from pqh_criteria_rate_defn

1207: --
1208: -- Check if the criteria rate defn exists
1209: --
1210: Cursor csr_crd is
1211: select criteria_rate_defn_id from pqh_criteria_rate_defn
1212: where short_name = p_crit_rt_defn_short_name
1213: and business_group_id = l_business_group_id;
1214: --
1215: Cursor csr_crdp is

Line 1216: select criteria_rate_defn_id from pqh_criteria_rate_defn

1212: where short_name = p_crit_rt_defn_short_name
1213: and business_group_id = l_business_group_id;
1214: --
1215: Cursor csr_crdp is
1216: select criteria_rate_defn_id from pqh_criteria_rate_defn
1217: where short_name = p_parent_crit_rt_def_name
1218: and business_group_id = l_business_group_id;
1219:
1220: Cursor csr_crf(crd_id in number,crdp_id in number)is

Line 1378: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;

1374: ,p_legislation_code in VARCHAR2
1375: ,p_effective_start_date in VARCHAR2
1376: ) is
1377:
1378: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1379: l_element_type_id pay_element_types_f.element_type_id%type;
1380: l_input_value_id pay_input_values_f.input_value_id%type;
1381: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1382: l_effective_date Date;

Line 1396: select criteria_rate_defn_id from pqh_criteria_rate_defn

1392: --
1393: l_language varchar2(30) ;
1394:
1395: Cursor csr_crd is
1396: select criteria_rate_defn_id from pqh_criteria_rate_defn
1397: where short_name = p_crit_rt_defn_short_name
1398: and business_group_id = l_business_group_id;
1399: --
1400:

Line 1529: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;

1525: ,p_legislation_code in VARCHAR2
1526: ,p_effective_start_date in varchar2
1527: ) is
1528: --
1529: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1530: l_element_type_id pay_element_types_f.element_type_id%type;
1531: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1532: l_rel_element_type_id pqh_rate_element_relations.rel_element_type_id%type;
1533: l_rel_input_value_id pqh_rate_element_relations.rel_input_value_id%type;

Line 1555: select criteria_rate_defn_id from pqh_criteria_rate_defn

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
1557: and business_group_id = l_business_group_id;
1558: --
1559:

Line 1885: delete from PQH_CRITERIA_RATE_DEFN_TL T

1881:
1882: Procedure ADD_LANGUAGE
1883: is
1884: begin
1885: delete from PQH_CRITERIA_RATE_DEFN_TL T
1886: where not exists
1887: (select NULL
1888: from PQH_CRITERIA_RATE_DEFN B
1889: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID

Line 1888: from PQH_CRITERIA_RATE_DEFN B

1884: begin
1885: delete from PQH_CRITERIA_RATE_DEFN_TL T
1886: where not exists
1887: (select NULL
1888: from PQH_CRITERIA_RATE_DEFN B
1889: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID
1890: );
1891:
1892: update PQH_CRITERIA_RATE_DEFN_TL T set (

Line 1892: update PQH_CRITERIA_RATE_DEFN_TL T set (

1888: from PQH_CRITERIA_RATE_DEFN B
1889: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID
1890: );
1891:
1892: update PQH_CRITERIA_RATE_DEFN_TL T set (
1893: NAME
1894: ) = (select
1895: B.NAME
1896: from PQH_CRITERIA_RATE_DEFN_TL B

Line 1896: from PQH_CRITERIA_RATE_DEFN_TL B

1892: update PQH_CRITERIA_RATE_DEFN_TL T set (
1893: NAME
1894: ) = (select
1895: B.NAME
1896: from PQH_CRITERIA_RATE_DEFN_TL B
1897: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID
1898: and B.LANGUAGE = T.SOURCE_LANG)
1899: where (
1900: T.CRITERIA_RATE_DEFN_ID,

Line 1905: from PQH_CRITERIA_RATE_DEFN_TL SUBB, PQH_CRITERIA_RATE_DEFN_TL SUBT

1901: T.LANGUAGE
1902: ) in (select
1903: SUBT.CRITERIA_RATE_DEFN_ID,
1904: SUBT.LANGUAGE
1905: from PQH_CRITERIA_RATE_DEFN_TL SUBB, PQH_CRITERIA_RATE_DEFN_TL SUBT
1906: where SUBB.CRITERIA_RATE_DEFN_ID = SUBT.CRITERIA_RATE_DEFN_ID
1907: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1908: and (SUBB.NAME <> SUBT.NAME
1909: ));

Line 1911: insert into PQH_CRITERIA_RATE_DEFN_TL (

1907: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1908: and (SUBB.NAME <> SUBT.NAME
1909: ));
1910:
1911: insert into PQH_CRITERIA_RATE_DEFN_TL (
1912: CRITERIA_RATE_DEFN_ID,
1913: NAME,
1914: LAST_UPDATE_DATE,
1915: CREATION_DATE,

Line 1931: from PQH_CRITERIA_RATE_DEFN_TL B, FND_LANGUAGES L

1927: B.LAST_UPDATE_LOGIN,
1928: B.LAST_UPDATED_BY,
1929: L.LANGUAGE_CODE,
1930: B.SOURCE_LANG
1931: from PQH_CRITERIA_RATE_DEFN_TL B, FND_LANGUAGES L
1932: where L.INSTALLED_FLAG in ('I', 'B')
1933: and B.LANGUAGE = userenv('LANG')
1934: and not exists
1935: (select NULL

Line 1936: from PQH_CRITERIA_RATE_DEFN_TL T

1932: where L.INSTALLED_FLAG in ('I', 'B')
1933: and B.LANGUAGE = userenv('LANG')
1934: and not exists
1935: (select NULL
1936: from PQH_CRITERIA_RATE_DEFN_TL T
1937: where T.CRITERIA_RATE_DEFN_ID = B.CRITERIA_RATE_DEFN_ID
1938: and T.LANGUAGE = L.LANGUAGE_CODE);
1939: end ADD_LANGUAGE;
1940: -- --