APPS.AP_WEB_MATCHING_RULE_PKG dependencies on AP_CARD_EMP_CANDIDATES

Line 94: -- It essentially protects ap_card_emp_candidates table.

90:
91: --
92: -- Locks the card so that multiple calls won't get in the way
93: -- of each other.
94: -- It essentially protects ap_card_emp_candidates table.
95: PROCEDURE LOCK_CARD(p_card_id NUMBER) IS
96: l_card_id number;
97: BEGIN
98: OPEN ccard(p_card_id);

Line 101: delete from ap_card_emp_candidates where card_id = p_card_id;

97: BEGIN
98: OPEN ccard(p_card_id);
99: FETCH ccard INTO l_card_id;
100:
101: delete from ap_card_emp_candidates where card_id = p_card_id;
102: EXCEPTION
103: WHEN OTHERS THEN
104: IF ccard%ISOPEN then
105: close ccard;

Line 159: 'INSERT INTO ap_card_emp_candidates(card_id, employee_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)

155:
156: IF (l_execute) THEN
157: lock_card(p_card_id);
158: execute immediate
159: 'INSERT INTO ap_card_emp_candidates(card_id, employee_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
160: SELECT card.card_id,
161: pap.person_id,
162: fnd_global.user_id,
163: trunc(sysdate),