APPS.AP_PAYMENT_EVENT_WF_PKG dependencies on AP_CHECKS

Line 10: l_check_id ap_checks_all.check_id%type;

6: p_actid IN NUMBER,
7: p_funmode IN VARCHAR2,
8: p_result OUT NOCOPY VARCHAR2) IS
9:
10: l_check_id ap_checks_all.check_id%type;
11: l_org_id ap_checks_all.org_id%type;
12: l_check_number ap_checks_all.check_number%type;
13: l_check_date varchar2(20);
14: l_currency_code ap_checks_all.currency_code%type;

Line 11: l_org_id ap_checks_all.org_id%type;

7: p_funmode IN VARCHAR2,
8: p_result OUT NOCOPY VARCHAR2) IS
9:
10: l_check_id ap_checks_all.check_id%type;
11: l_org_id ap_checks_all.org_id%type;
12: l_check_number ap_checks_all.check_number%type;
13: l_check_date varchar2(20);
14: l_currency_code ap_checks_all.currency_code%type;
15: l_payment_amount ap_checks_all.amount%type;

Line 12: l_check_number ap_checks_all.check_number%type;

8: p_result OUT NOCOPY VARCHAR2) IS
9:
10: l_check_id ap_checks_all.check_id%type;
11: l_org_id ap_checks_all.org_id%type;
12: l_check_number ap_checks_all.check_number%type;
13: l_check_date varchar2(20);
14: l_currency_code ap_checks_all.currency_code%type;
15: l_payment_amount ap_checks_all.amount%type;
16: l_email_address po_vendor_sites_all.remittance_email%type;

Line 14: l_currency_code ap_checks_all.currency_code%type;

10: l_check_id ap_checks_all.check_id%type;
11: l_org_id ap_checks_all.org_id%type;
12: l_check_number ap_checks_all.check_number%type;
13: l_check_date varchar2(20);
14: l_currency_code ap_checks_all.currency_code%type;
15: l_payment_amount ap_checks_all.amount%type;
16: l_email_address po_vendor_sites_all.remittance_email%type;
17:
18: l_message_lines1 varchar2(4000):='';

Line 15: l_payment_amount ap_checks_all.amount%type;

11: l_org_id ap_checks_all.org_id%type;
12: l_check_number ap_checks_all.check_number%type;
13: l_check_date varchar2(20);
14: l_currency_code ap_checks_all.currency_code%type;
15: l_payment_amount ap_checks_all.amount%type;
16: l_email_address po_vendor_sites_all.remittance_email%type;
17:
18: l_message_lines1 varchar2(4000):='';
19: l_message_lines2 varchar2(4000):='';

Line 76: FROM ap_checks

72: INTO l_check_number,
73: l_check_date,
74: l_currency_code,
75: l_payment_amount
76: FROM ap_checks
77: WHERE check_id = l_check_id;
78:
79: OPEN c_message_lines;
80:

Line 217: FROM ap_checks

213: SELECT vendor_id,
214: vendor_site_id
215: INTO l_vendor_id,
216: l_vendor_site_id
217: FROM ap_checks
218: WHERE check_id = p_check_id;
219:
220: --bug6119080, changed the query to fetch the email address from the
221: --correct table.

Line 243: FROM ap_checks

239: BEGIN
240:
241: SELECT status_lookup_code
242: INTO p_check_status
243: FROM ap_checks
244: WHERE check_id = p_check_id;
245:
246: END get_check_status;
247:

Line 268: l_check_status ap_checks_all.status_lookup_code%type;

264:
265: l_check_id l_parameter_t.value%type;
266: l_org_id l_parameter_t.value%type;
267: l_email_address po_vendor_sites_all.remittance_email%type;
268: l_check_status ap_checks_all.status_lookup_code%type;
269:
270: BEGIN
271:
272: l_parameter_list := p_event.getParameterList();