eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on AR_RECEIVABLE_APPLICATIONS

Line 499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;

495: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
496: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
497: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
498: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;
501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;
502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;

Line 500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;

496: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
497: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
498: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;
501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;
502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;

Line 501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;

497: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
498: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;
501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;
502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;

Line 502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;

498: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;
501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;
502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;

Line 503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;

499: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;
501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;
502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;
507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;

Line 504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;

500: l_amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL;
501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;
502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;
507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;
508: l_show_closed_invoices VARCHAR2(1) DEFAULT 'N';

Line 505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;

501: l_trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL;
502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;
507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;
508: l_show_closed_invoices VARCHAR2(1) DEFAULT 'N';
509: l_move_deferred_tax VARCHAR2(1) DEFAULT 'Y';

Line 506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;

502: l_discount ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL;
503: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
504: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
505: app_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;
507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;
508: l_show_closed_invoices VARCHAR2(1) DEFAULT 'N';
509: l_move_deferred_tax VARCHAR2(1) DEFAULT 'Y';
510: l_link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL;

Line 510: l_link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL;

506: l_customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL;
507: l_line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL;
508: l_show_closed_invoices VARCHAR2(1) DEFAULT 'N';
509: l_move_deferred_tax VARCHAR2(1) DEFAULT 'Y';
510: l_link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL;
511: app_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
512: app_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
513: app_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
514: l_call_payment_processor VARCHAR2(1) DEFAULT FND_API.G_FALSE;

Line 513: app_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;

509: l_move_deferred_tax VARCHAR2(1) DEFAULT 'Y';
510: l_link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL;
511: app_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
512: app_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
513: app_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
514: l_call_payment_processor VARCHAR2(1) DEFAULT FND_API.G_FALSE;
515: l_org_id NUMBER DEFAULT NULL;
516:
517: x_msg_data VARCHAR2(1000);

Line 667: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL;

663: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
664: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
665: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
666: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
667: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL;
668: l_reversal_gl_date ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL;
669: l_called_from VARCHAR2(30) DEFAULT NULL;
670: l_cancel_claim_flag VARCHAR2(1) DEFAULT 'Y';
671: l_org_id NUMBER DEFAULT NULL;

Line 668: l_reversal_gl_date ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL;

664: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
665: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
666: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;
667: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL;
668: l_reversal_gl_date ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL;
669: l_called_from VARCHAR2(30) DEFAULT NULL;
670: l_cancel_claim_flag VARCHAR2(1) DEFAULT 'Y';
671: l_org_id NUMBER DEFAULT NULL;
672:

Line 787: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;

783: l_api_name VARCHAR2(50) := 'refund_activity_on_emd_receipt';
784: l_progress NUMBER;
785: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
786: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
787: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
788: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE; --this has no default
789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default
791: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;

Line 790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default

786: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
787: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
788: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE; --this has no default
789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default
791: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
792: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
794: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;

Line 791: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;

787: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
788: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE; --this has no default
789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default
791: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
792: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
794: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
795: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;

Line 792: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;

788: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE; --this has no default
789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default
791: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
792: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
794: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
795: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;

Line 793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;

789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default
791: l_apply_date ar_receivable_applications.apply_date%TYPE DEFAULT NULL;
792: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
794: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
795: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

Line 796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;

792: l_apply_gl_date ar_receivable_applications.gl_date%TYPE DEFAULT NULL;
793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
794: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
795: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

Line 797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

793: l_ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL;
794: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
795: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;

Line 798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

794: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
795: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;
802: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

Line 799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

795: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;
802: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
803: l_customer_reference ar_receivable_applications.customer_reference%TYPE DEFAULT NULL;

Line 800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

796: l_comments ar_receivable_applications.comments%TYPE DEFAULT NULL;
797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;
802: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
803: l_customer_reference ar_receivable_applications.customer_reference%TYPE DEFAULT NULL;
804: l_val_writeoff_limits_flag VARCHAR2(1);

Line 801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;

797: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;
802: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
803: l_customer_reference ar_receivable_applications.customer_reference%TYPE DEFAULT NULL;
804: l_val_writeoff_limits_flag VARCHAR2(1);
805: l_called_from VARCHAR2(30) DEFAULT NULL;

Line 802: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

798: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;
802: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
803: l_customer_reference ar_receivable_applications.customer_reference%TYPE DEFAULT NULL;
804: l_val_writeoff_limits_flag VARCHAR2(1);
805: l_called_from VARCHAR2(30) DEFAULT NULL;
806: l_netted_receipt_flag VARCHAR2(1) DEFAULT NULL;

Line 803: l_customer_reference ar_receivable_applications.customer_reference%TYPE DEFAULT NULL;

799: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
800: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
801: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL;
802: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
803: l_customer_reference ar_receivable_applications.customer_reference%TYPE DEFAULT NULL;
804: l_val_writeoff_limits_flag VARCHAR2(1);
805: l_called_from VARCHAR2(30) DEFAULT NULL;
806: l_netted_receipt_flag VARCHAR2(1) DEFAULT NULL;
807: l_netted_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;

Line 808: l_secondary_apl_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE := null;

804: l_val_writeoff_limits_flag VARCHAR2(1);
805: l_called_from VARCHAR2(30) DEFAULT NULL;
806: l_netted_receipt_flag VARCHAR2(1) DEFAULT NULL;
807: l_netted_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
808: l_secondary_apl_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE := null;
809: l_secondary_apl_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE := null;
810: l_org_id NUMBER DEFAULT NULL;
811: l_customer_reason ar_receivable_applications.customer_reason%TYPE DEFAULT NULL;
812: l_pay_group_lookup_code FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL;

Line 809: l_secondary_apl_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE := null;

805: l_called_from VARCHAR2(30) DEFAULT NULL;
806: l_netted_receipt_flag VARCHAR2(1) DEFAULT NULL;
807: l_netted_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
808: l_secondary_apl_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE := null;
809: l_secondary_apl_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE := null;
810: l_org_id NUMBER DEFAULT NULL;
811: l_customer_reason ar_receivable_applications.customer_reason%TYPE DEFAULT NULL;
812: l_pay_group_lookup_code FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL;
813: l_pay_alone_flag VARCHAR2(1) DEFAULT 'Y';

Line 811: l_customer_reason ar_receivable_applications.customer_reason%TYPE DEFAULT NULL;

807: l_netted_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
808: l_secondary_apl_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE := null;
809: l_secondary_apl_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE := null;
810: l_org_id NUMBER DEFAULT NULL;
811: l_customer_reason ar_receivable_applications.customer_reason%TYPE DEFAULT NULL;
812: l_pay_group_lookup_code FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL;
813: l_pay_alone_flag VARCHAR2(1) DEFAULT 'Y';
814: l_payment_method_code ap_invoices.payment_method_code%TYPE DEFAULT NULL;
815: l_payment_reason_code ap_invoices.payment_reason_code%TYPE DEFAULT NULL;

Line 2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;

2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;
2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2181: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2182: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2183:
2184: l_cm_in_record CM_INFO_IN_RECTYPE;

Line 2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;

2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2789:

Line 4329: from ar_receivable_applications_all arp,

4325: SELECT Max(acr.cash_receipt_id),
4326: Max(arp.receivable_application_id)
4327: INTO x_cash_receipt_id,
4328: x_receivable_app_id
4329: from ar_receivable_applications_all arp,
4330: ra_customer_trx_all rct,
4331: ra_cust_trx_types_all ctyp,
4332: ar_cash_receipts_all acr
4333: where arp.applied_customer_trx_id = p_parent_trx_id