[Home] [Help]
1880: Fetch csr_col_prompt into l_col_prompt;
1881: Close csr_col_prompt;
1882:
1883:
1884: Insert Into BEN_CUSTOM_REGION_ITEMS
1885: (
1886: REGION_CODE -- task code / integrator code
1887: ,CUSTOM_KEY -- mgr_per_in_ler_id
1888: ,CUSTOM_TYPE -- integrator code
1914: --
1915: --------------------------chk_entry_in_custom_table----------------------
1916: --
1917: /* Purpose :
1918: This function checks whether data exists in table BEN_CUSTOM_REGION_ITEMS or not.
1919: If data exists in the table then returns 'Y' else 'N'
1920: */
1921:
1922: Function chk_entry_in_custom_table( p_key IN VARCHAR2
1926: IS
1927: Cursor Csr_entry
1928: IS
1929: Select '1'
1930: From BEN_CUSTOM_REGION_ITEMS
1931: Where CUSTOM_TYPE = p_integrator_code
1932: And REGION_CODE = p_region_key
1933: And CUSTOM_KEY = p_key;
1934:
1942: Open Csr_entry;
1943: Fetch Csr_entry into l_exists;
1944: Close Csr_entry;
1945:
1946: -- If entires are not there insert data into table BEN_CUSTOM_REGION_ITEMS
1947: If l_exists is null then
1948: l_return_val := 'N';
1949: Else
1950: l_return_val := 'Y';
2018:
2019:
2020: If l_exist_in_table = 'Y' Then
2021: hr_utility.set_location('Data Not exists in custom Table ',25);
2022: Delete From BEN_CUSTOM_REGION_ITEMS
2023: Where CUSTOM_KEY = p_key
2024: And REGION_CODE = p_region_key
2025: And CUSTOM_TYPE = p_integrator_code;
2026: End If;
2113: IS
2114: Select cust.ITEM_NAME inf_col_name
2115: ,infCols.SEQUENCE_NUM inf_Seq_Num
2116: ,cust.ORDR_NUM Dis_Seq_Num
2117: From BEN_CUSTOM_REGION_ITEMS cust,
2118: Bne_interface_cols_b infCols
2119: Where cust.CUSTOM_KEY = p_key
2120: And cust.REGION_CODE = p_region_key --p_integrator_code
2121: And cust.CUSTOM_TYPE = p_integrator_code