DBA Data[Home] [Help]

APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_CAT_GROUP_MEMBERS_PKG

Line 1637: CS_KB_CAT_GROUP_MEMBERS_PKG.INSERT_ROW (

1633: -- Category Group Member already exists
1634: RAISE DUP_CATEGORY_GROUP_MEMBER;
1635: ELSE
1636: --dbms_output.put_line('before insert-');
1637: CS_KB_CAT_GROUP_MEMBERS_PKG.INSERT_ROW (
1638: X_ROWID => l_rowid,
1639: X_CATEGORY_GROUP_ID => P_CATEGORY_GROUP_ID ,
1640: X_CATEGORY_ID => P_CATEGORY_ID ,
1641: X_CREATION_DATE => l_date,

Line 1852: CS_KB_CAT_GROUP_MEMBERS_PKG.DELETE_ROW (X_CATEGORY_GROUP_ID => P_CATEGORY_GROUP_ID,

1848: FETCH CHECK_DELETE INTO l_valid;
1849: CLOSE CHECK_DELETE;
1850:
1851: IF l_valid <> 0 THEN
1852: CS_KB_CAT_GROUP_MEMBERS_PKG.DELETE_ROW (X_CATEGORY_GROUP_ID => P_CATEGORY_GROUP_ID,
1853: X_CATEGORY_ID => P_CATEGORY_ID);
1854:
1855: OPEN CHECK_DELETE;
1856: FETCH CHECK_DELETE INTO l_valid;