APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on JL_AR_AP_AWT_CERTIF

Line 68: UPDATE jl_ar_ap_awt_certif

64: OPEN c_void_certificates(P_PAYMENT_ID);
65: FETCH c_void_certificates INTO l_checkrun_id, l_check_number;
66:
67:
68: UPDATE jl_ar_ap_awt_certif
69: set status = 'VOID'
70: where checkrun_id = l_checkrun_id
71: and check_number = l_check_number;
72:

Line 108: | JL_AR_AP_AWT_CERTIF. This table is used for create the |

104: | |
105: | NOTES |
106: | This module is called from Wrapper to IBY Callout PMt. |
107: | The package will insert records into the table |
108: | JL_AR_AP_AWT_CERTIF. This table is used for create the |
109: | Withholding Certificates. |
110: | Check runname is the Payment Innstruction |
111: | Check ID id the payment ID |
112: | |

Line 240: FUNCTION INS_INTO_JL_AR_AP_AWT_CERTIF(

236: --- and pv.vendor_id = ap.vendor_id;
237: -- and ap.checkrun_name = p_checkrun_name
238:
239: ------------------------------------------------------------------------------------------
240: FUNCTION INS_INTO_JL_AR_AP_AWT_CERTIF(
241: v_next_certificate_number IN NUMBER ,
242: v_bank_account_num IN VARCHAR2 ,
243: v_payment_document_name IN VARCHAR2 ,
244: v_check_number IN NUMBER ,

Line 332: SELECT jl_ar_ap_awt_certif_s.nextval

328: raise column_required;
329: END IF;
330:
331:
332: SELECT jl_ar_ap_awt_certif_s.nextval
333: INTO v_table_id
334: FROM dual ;
335:
336: --Bug 6504015. added code for setting the org-id while insert.

Line 340: INSERT INTO jl_ar_ap_awt_certif_all

336: --Bug 6504015. added code for setting the org-id while insert.
337: v_org_id := MO_GLOBAL.get_current_org_id;
338: --in certificates we insert now for r12 payment id rather than check id
339:
340: INSERT INTO jl_ar_ap_awt_certif_all
341: (certificate_id ,
342: certificate_number ,
343: bank_account_num ,
344: payment_document_name ,

Line 404: ||v_column_required||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';

400:
401: EXCEPTION
402: WHEN column_required THEN
403: p_errmsg := p_errmsg||'Column constraint NOT NULL in the column '
404: ||v_column_required||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';
405: RETURN(FALSE);
406:
407: WHEN OTHERS THEN
408: p_errmsg := p_errmsg||SUBSTR(SQLERRM, 1, 100);

Line 409: p_errmsg := p_errmsg||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';

405: RETURN(FALSE);
406:
407: WHEN OTHERS THEN
408: p_errmsg := p_errmsg||SUBSTR(SQLERRM, 1, 100);
409: p_errmsg := p_errmsg||' - Error in INS_INTO_JL_AR_AP_AWT_CERTIF';
410: RETURN(FALSE);
411: END;
412:
413: ------------------------------------------------------------------------------------------

Line 467: FROM jl_ar_ap_awt_certif_all jaaac1

463:
464:
465: SELECT jaaac1.certificate_number
466: INTO max_number
467: FROM jl_ar_ap_awt_certif_all jaaac1
468: WHERE jaaac1.awt_type_code = p_awt_type_code
469: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
470: from jl_ar_ap_awt_certif_all jaaac2
471: where jaaac2.awt_type_code = p_awt_type_code)

Line 470: from jl_ar_ap_awt_certif_all jaaac2

466: INTO max_number
467: FROM jl_ar_ap_awt_certif_all jaaac1
468: WHERE jaaac1.awt_type_code = p_awt_type_code
469: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
470: from jl_ar_ap_awt_certif_all jaaac2
471: where jaaac2.awt_type_code = p_awt_type_code)
472: FOR UPDATE;
473:
474:

Line 638: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(

634: v_credit_amount);
635:
636: -- check_return (v_return);
637:
638: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(
639: v_next_certificate_number ,
640: v_prev_bank_account_num ,
641: v_prev_pay_document_name ,
642: v_prev_check_number ,

Line 720: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(

716:
717: -- check_return (v_return);
718:
719:
720: v_return := INS_INTO_JL_AR_AP_AWT_CERTIF(
721: v_next_certificate_number ,
722: v_prev_bank_account_num ,
723: v_prev_pay_document_name ,
724: v_prev_check_number ,