[Home] [Help]
1763: Fetch csr_col_prompt into l_col_prompt;
1764: Close csr_col_prompt;
1765:
1766:
1767: Insert Into BEN_CUSTOM_REGION_ITEMS
1768: (
1769: REGION_CODE -- task code / integrator code
1770: ,CUSTOM_KEY -- mgr_per_in_ler_id
1771: ,CUSTOM_TYPE -- integrator code
1797: --
1798: --------------------------chk_entry_in_custom_table----------------------
1799: --
1800: /* Purpose :
1801: This function checks whether data exists in table BEN_CUSTOM_REGION_ITEMS or not.
1802: If data exists in the table then returns 'Y' else 'N'
1803: */
1804:
1805: Function chk_entry_in_custom_table( p_key IN VARCHAR2
1808: IS
1809: Cursor Csr_entry
1810: IS
1811: Select '1'
1812: From BEN_CUSTOM_REGION_ITEMS
1813: Where CUSTOM_TYPE = p_integrator_code
1814: And REGION_CODE = p_integrator_code
1815: And CUSTOM_KEY = p_key;
1816:
1824: Open Csr_entry;
1825: Fetch Csr_entry into l_exists;
1826: Close Csr_entry;
1827:
1828: -- If entires are not there insert data into table BEN_CUSTOM_REGION_ITEMS
1829: If l_exists is null then
1830: l_return_val := 'N';
1831: Else
1832: l_return_val := 'Y';
1896:
1897:
1898: If l_exist_in_table = 'Y' Then
1899: hr_utility.set_location('Data Not exists in custom Table ',25);
1900: Delete From BEN_CUSTOM_REGION_ITEMS
1901: Where CUSTOM_KEY = p_key
1902: And REGION_CODE = p_integrator_code
1903: And CUSTOM_TYPE = p_integrator_code;
1904: End If;
1984: IS
1985: Select cust.ITEM_NAME inf_col_name
1986: ,infCols.SEQUENCE_NUM inf_Seq_Num
1987: ,cust.ORDR_NUM Dis_Seq_Num
1988: From BEN_CUSTOM_REGION_ITEMS cust,
1989: Bne_interface_cols_b infCols
1990: Where cust.CUSTOM_KEY = p_key
1991: And cust.REGION_CODE = p_integrator_code
1992: And cust.CUSTOM_TYPE = p_integrator_code