APPS.BEN_CWB_WEBADI_UTILS dependencies on BEN_TRANSACTION

Line 1778: FROM ben_transaction

1774: AND integrator_app_id = 800
1775: AND application_id = 800
1776: AND layout_code <> p_base_layout_code
1777: AND layout_code NOT IN (SELECT attribute1
1778: FROM ben_transaction
1779: WHERE transaction_type = 'CWBWEBADI'
1780: AND attribute2 IS NOT NULL
1781: AND attribute1 IS NOT NULL
1782: AND DECODE(transaction_type, 'CWBWEBADI', SYSDATE - (to_number(l_layout_lock_time) /(24 * 60))

Line 1805: DELETE ben_transaction

1801:
1802: END;
1803: ELSE
1804: BEGIN
1805: DELETE ben_transaction
1806: WHERE transaction_type = 'CWBWEBADI'
1807: AND attribute1 = l_layout;
1808: EXCEPTION
1809: WHEN OTHERS THEN

Line 1813: INSERT INTO ben_transaction

1809: WHEN OTHERS THEN
1810: NULL;
1811: END;
1812:
1813: INSERT INTO ben_transaction
1814: (transaction_id
1815: ,transaction_type
1816: ,attribute1
1817: ,attribute2)

Line 1818: VALUES (ben_transaction_s.NEXTVAL

1814: (transaction_id
1815: ,transaction_type
1816: ,attribute1
1817: ,attribute2)
1818: VALUES (ben_transaction_s.NEXTVAL
1819: ,'CWBWEBADI'
1820: ,l_layout
1821: ,TO_CHAR(SYSDATE, 'yyyy/mm/dd:hh:mi'));
1822: END IF;

Line 1836: DELETE ben_transaction

1832:
1833: PROCEDURE unlock_cwb_layout( p_layout_code IN VARCHAR2)
1834: IS
1835: BEGIN
1836: DELETE ben_transaction
1837: WHERE transaction_type = 'CWBWEBADI'
1838: AND attribute1 = p_layout_code;
1839: EXCEPTION
1840: WHEN OTHERS THEN

Line 3384: ,ben_transaction atxn

3380: ,nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.mid_value) proposed_grade_mid
3381: ,get_new_salary(p_group_per_in_ler_id) * 100 / (nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.mid_value)) proposed_grade_comparatio
3382: from ben_cwb_pl_dsgn pl
3383: ,pay_grade_rules_f pgr
3384: ,ben_transaction atxn
3385: ,ben_cwb_person_info per
3386: WHERE per.group_per_in_ler_id = p_group_per_in_ler_id
3387: and atxn.transaction_id = per.assignment_id
3388: AND atxn.transaction_type = 'CWBASG' || p_asg_updt_eff_date