APPS.BEN_CWB_WEBADI_UTILS dependencies on BEN_TRANSACTION

Line 1662: FROM ben_transaction

1658: AND integrator_app_id = 800
1659: AND application_id = 800
1660: AND layout_code <> p_base_layout_code
1661: AND layout_code NOT IN (SELECT attribute1
1662: FROM ben_transaction
1663: WHERE transaction_type = 'CWBWEBADI'
1664: AND attribute2 IS NOT NULL
1665: AND attribute1 IS NOT NULL
1666: AND DECODE(transaction_type, 'CWBWEBADI', SYSDATE - (to_number(l_layout_lock_time) /(24 * 60))

Line 1689: DELETE ben_transaction

1685:
1686: END;
1687: ELSE
1688: BEGIN
1689: DELETE ben_transaction
1690: WHERE transaction_type = 'CWBWEBADI'
1691: AND attribute1 = l_layout;
1692: EXCEPTION
1693: WHEN OTHERS THEN

Line 1697: INSERT INTO ben_transaction

1693: WHEN OTHERS THEN
1694: NULL;
1695: END;
1696:
1697: INSERT INTO ben_transaction
1698: (transaction_id
1699: ,transaction_type
1700: ,attribute1
1701: ,attribute2)

Line 1702: VALUES (ben_transaction_s.NEXTVAL

1698: (transaction_id
1699: ,transaction_type
1700: ,attribute1
1701: ,attribute2)
1702: VALUES (ben_transaction_s.NEXTVAL
1703: ,'CWBWEBADI'
1704: ,l_layout
1705: ,TO_CHAR(SYSDATE, 'yyyy/mm/dd:hh:mi'));
1706: END IF;

Line 1720: DELETE ben_transaction

1716:
1717: PROCEDURE unlock_cwb_layout( p_layout_code IN VARCHAR2)
1718: IS
1719: BEGIN
1720: DELETE ben_transaction
1721: WHERE transaction_type = 'CWBWEBADI'
1722: AND attribute1 = p_layout_code;
1723: EXCEPTION
1724: WHEN OTHERS THEN