41: FROM DUAL;
42:
43: CURSOR c_cust_setup_count(cust_setup_id IN NUMBER) IS
44: SELECT COUNT(*)
45: FROM AMS_CUSTOM_SETUPS_VL
46: WHERE custom_setup_id = cust_setup_id;
47:
48: BEGIN
49: -- initialize
1502: AND p_cust_setup_rec.custom_setup_id IS NOT NULL
1503: THEN
1504: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1505: (
1506: 'AMS_CUSTOM_SETUPS_VL',
1507: 'custom_setup_id = ' || p_cust_setup_rec.custom_setup_id
1508: );
1509: END IF;
1510:
1683: )
1684: IS
1685:
1686: CURSOR c_cust_setup IS
1687: SELECT * FROM AMS_CUSTOM_SETUPS_VL
1688: WHERE custom_setup_id = p_cust_setup_rec.custom_setup_id;
1689:
1690: l_cust_setup_rec c_cust_setup%ROWTYPE;
1691: