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 IBY_EXTERNAL_PAYEES_ALL.remit_advice_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 IBY_EXTERNAL_PAYEES_ALL.remit_advice_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 IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%type;
17:
18: l_message_lines1 varchar2(4000):='';
19: l_message_lines2 varchar2(4000):='';

Line 86: FROM ap_checks

82: INTO l_check_number,
83: l_check_date,
84: l_currency_code,
85: l_payment_amount
86: FROM ap_checks
87: WHERE check_id = l_check_id;
88:
89: OPEN c_message_lines;
90:

Line 227: FROM ap_checks

223: SELECT vendor_id,
224: vendor_site_id
225: INTO l_vendor_id,
226: l_vendor_site_id
227: FROM ap_checks
228: WHERE check_id = p_check_id;
229:
230: --bug6119080, changed the query to fetch the email address from the
231: --correct table.

Line 253: FROM ap_checks

249: BEGIN
250:
251: SELECT status_lookup_code
252: INTO p_check_status
253: FROM ap_checks
254: WHERE check_id = p_check_id;
255:
256: END get_check_status;
257:

Line 278: l_check_status ap_checks_all.status_lookup_code%type;

274:
275: l_check_id l_parameter_t.value%type;
276: l_org_id l_parameter_t.value%type;
277: l_email_address IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%type;
278: l_check_status ap_checks_all.status_lookup_code%type;
279:
280: BEGIN
281:
282: l_parameter_list := p_event.getParameterList();