APPS.AP_WEB_CC_UPGRADE_PKG dependencies on AP_CARDS_ALL

Line 9: and updating with correct reference of card_reference_id in ap_cards_all.

5: /*
6: Procedure : Upgrade_Cards
7: Purpose : Successful upgrade for a card signifies encryption of a card number,
8: Cardmember Name, and Expiration Date using Oracle Payments api
9: and updating with correct reference of card_reference_id in ap_cards_all.
10: */
11: PROCEDURE Upgrade_Cards
12: (x_errbuf OUT NOCOPY VARCHAR2,
13: x_retcode OUT NOCOPY VARCHAR2,

Line 54: l_table_name varchar2(30) := 'AP_CARDS_ALL';

50: l_batch_size varchar2(30) := x_batch_size;
51: l_worker_id number := x_worker_id;
52: l_num_workers number := x_num_workers;
53: l_any_rows_to_process boolean;
54: l_table_name varchar2(30) := 'AP_CARDS_ALL';
55: l_update_name varchar2(30) := x_script_name || 'UpgCard';
56:
57:
58: l_status varchar2(1);

Line 71: from ap_cards_all aca,

67: card_program_id,
68: card_reference_id,
69: card_expiration_date,
70: cardmember_name
71: from ap_cards_all aca,
72: per_all_people_f p
73: where trunc(sysdate) between p.effective_start_date(+) and p.effective_end_date(+)
74: and aca.employee_id = p.person_id(+)
75: and (card_number is not null

Line 152: update ap_cards_all

148: end loop;
149:
150: -- updating cards table
151: forall k in 1..h_card_id.count
152: update ap_cards_all
153: set card_reference_id = v_instr_id(k)
154: , card_number = null
155: , cardmember_name = null
156: , card_expiration_date = null