DBA Data[Home] [Help]

APPS.AP_PAYMENT_EVENT_WF_PKG dependencies on AP_CHECKS_ALL

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 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();