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