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.

[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

1140: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1141: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1145: -- this is the allocated receipt amount
1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,

Line 1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1145: -- this is the allocated receipt amount
1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1145: -- this is the allocated receipt amount
1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,

1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1145: -- this is the allocated receipt amount
1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1152: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

Line 1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

1145: -- this is the allocated receipt amount
1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1152: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1153: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

Line 1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

1146: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1152: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1153: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1154: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */

Line 1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

1147: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1152: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1153: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1154: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1155: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 1152: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

1148: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1152: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1153: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1154: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1155: p_called_from IN VARCHAR2 DEFAULT NULL,
1156: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 1157: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

1153: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1154: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1155: p_called_from IN VARCHAR2 DEFAULT NULL,
1156: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1157: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1158: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1159: -- ******* Global Flexfield parameters *******
1160: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1161: p_comments IN ar_receivable_applications.comments%TYPE,

Line 1161: p_comments IN ar_receivable_applications.comments%TYPE,

1157: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1158: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1159: -- ******* Global Flexfield parameters *******
1160: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1161: p_comments IN ar_receivable_applications.comments%TYPE,
1162: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,

Line 1162: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,

1158: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1159: -- ******* Global Flexfield parameters *******
1160: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1161: p_comments IN ar_receivable_applications.comments%TYPE,
1162: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

Line 1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,

1159: -- ******* Global Flexfield parameters *******
1160: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1161: p_comments IN ar_receivable_applications.comments%TYPE,
1162: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,

Line 1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,

1160: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1161: p_comments IN ar_receivable_applications.comments%TYPE,
1162: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1168: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

Line 1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,

1161: p_comments IN ar_receivable_applications.comments%TYPE,
1162: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1168: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1169: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

Line 1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

1162: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1168: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1169: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1170: p_org_id IN NUMBER DEFAULT NULL

Line 1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,

1163: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1168: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1169: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1170: p_org_id IN NUMBER DEFAULT NULL
1171: ) IS

Line 1168: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

1164: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1168: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1169: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1170: p_org_id IN NUMBER DEFAULT NULL
1171: ) IS
1172: l_api_name CONSTANT VARCHAR2(20) := 'Apply';

Line 1169: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

1165: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1166: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1167: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1168: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1169: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1170: p_org_id IN NUMBER DEFAULT NULL
1171: ) IS
1172: l_api_name CONSTANT VARCHAR2(20) := 'Apply';
1173: l_api_version CONSTANT NUMBER := 1.0;

Line 1223: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

1219: l_global_attribute_rec global_attribute_rec_type;
1220: l_remit_bank_acct_use_id NUMBER;
1221: l_receipt_method_id NUMBER;
1222: l_gdflex_return_status VARCHAR2(1);
1223: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
1224: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1225: l_return_status VARCHAR2(1);
1226: l_msg_count NUMBER;
1227: l_msg_data VARCHAR2(2000);

Line 1224: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

1220: l_remit_bank_acct_use_id NUMBER;
1221: l_receipt_method_id NUMBER;
1222: l_gdflex_return_status VARCHAR2(1);
1223: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
1224: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1225: l_return_status VARCHAR2(1);
1226: l_msg_count NUMBER;
1227: l_msg_data VARCHAR2(2000);
1228: l_payment_set_id NUMBER;

Line 1546: 'AR_RECEIVABLE_APPLICATIONS',

1542: IF nvl(l_receipt_method_id,-99) <> -1 THEN
1543: --validate and default the flexfields
1544: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
1545: l_attribute_rec,
1546: 'AR_RECEIVABLE_APPLICATIONS',
1547: l_dflex_val_return_status
1548: );
1549:
1550:

Line 1552: jg_ar_receivable_applications.apply(

1548: );
1549:
1550:
1551: --default and validate the global descriptive flexfield
1552: jg_ar_receivable_applications.apply(
1553: p_apply_before_after => 'BEFORE',
1554: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
1555: p_set_of_books_id => arp_global.set_of_books_id,
1556: p_cash_receipt_id => l_cash_receipt_id,

Line 1762: jg_ar_receivable_applications.apply(

1758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761:
1762: jg_ar_receivable_applications.apply(
1763: p_apply_before_after => 'AFTER',
1764: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
1765: p_set_of_books_id => null,
1766: p_cash_receipt_id => null,

Line 1920: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

1916: -- LLCA Parameters
1917: p_llca_type IN VARCHAR2 DEFAULT 'S',
1918: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1919: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1920: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1921: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1922: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1923: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1924: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 1921: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

1917: p_llca_type IN VARCHAR2 DEFAULT 'S',
1918: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1919: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1920: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1921: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1922: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1923: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1924: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1925: p_line_discount IN NUMBER DEFAULT NULL,

Line 1922: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

1918: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1919: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1920: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1921: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1922: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1923: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1924: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1925: p_line_discount IN NUMBER DEFAULT NULL,
1926: p_tax_discount IN NUMBER DEFAULT NULL,

Line 1923: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

1919: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1920: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1921: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1922: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1923: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1924: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1925: p_line_discount IN NUMBER DEFAULT NULL,
1926: p_tax_discount IN NUMBER DEFAULT NULL,
1927: p_freight_discount IN NUMBER DEFAULT NULL,

Line 1924: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

1920: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1921: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1922: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1923: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1924: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1925: p_line_discount IN NUMBER DEFAULT NULL,
1926: p_tax_discount IN NUMBER DEFAULT NULL,
1927: p_freight_discount IN NUMBER DEFAULT NULL,
1928: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

Line 1928: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

1924: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1925: p_line_discount IN NUMBER DEFAULT NULL,
1926: p_tax_discount IN NUMBER DEFAULT NULL,
1927: p_freight_discount IN NUMBER DEFAULT NULL,
1928: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1929: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1930: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1931: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1932: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 1929: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

1925: p_line_discount IN NUMBER DEFAULT NULL,
1926: p_tax_discount IN NUMBER DEFAULT NULL,
1927: p_freight_discount IN NUMBER DEFAULT NULL,
1928: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1929: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1930: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1931: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1932: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1933: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 1930: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,

1926: p_tax_discount IN NUMBER DEFAULT NULL,
1927: p_freight_discount IN NUMBER DEFAULT NULL,
1928: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1929: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1930: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1931: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1932: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1933: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1934: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',

Line 1931: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

1927: p_freight_discount IN NUMBER DEFAULT NULL,
1928: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1929: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1930: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1931: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1932: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1933: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1934: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1935: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 1932: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

1928: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1929: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1930: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1931: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1932: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1933: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1934: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1935: p_called_from IN VARCHAR2 DEFAULT NULL,
1936: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 1933: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

1929: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1930: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1931: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1932: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1933: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1934: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1935: p_called_from IN VARCHAR2 DEFAULT NULL,
1936: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1937: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 1937: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

1933: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1934: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1935: p_called_from IN VARCHAR2 DEFAULT NULL,
1936: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1937: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1938: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1939: -- ******* Global Flexfield parameters *******
1940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 1941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

1937: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1938: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1939: -- ******* Global Flexfield parameters *******
1940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1942: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,

Line 1942: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,

1938: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1939: -- ******* Global Flexfield parameters *******
1940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1942: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

Line 1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,

1939: -- ******* Global Flexfield parameters *******
1940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1942: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,

Line 1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,

1940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1942: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1948: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

Line 1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,

1941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1942: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1948: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1949: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

Line 1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

1942: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1948: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1949: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1950: p_org_id IN NUMBER DEFAULT NULL,

Line 1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,

1943: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1948: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1949: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1950: p_org_id IN NUMBER DEFAULT NULL,
1951: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const

Line 1948: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

1944: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1948: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1949: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1950: p_org_id IN NUMBER DEFAULT NULL,
1951: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
1952: ) IS

Line 1949: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

1945: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1946: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1947: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1948: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1949: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1950: p_org_id IN NUMBER DEFAULT NULL,
1951: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
1952: ) IS
1953:

Line 2011: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

2007: l_global_attribute_rec global_attribute_rec_type;
2008: l_remit_bank_acct_use_id NUMBER;
2009: l_receipt_method_id NUMBER;
2010: l_gdflex_return_status VARCHAR2(1);
2011: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
2012: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2013: l_return_status VARCHAR2(1);
2014: l_msg_count NUMBER;
2015: l_msg_data VARCHAR2(2000);

Line 2012: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

2008: l_remit_bank_acct_use_id NUMBER;
2009: l_receipt_method_id NUMBER;
2010: l_gdflex_return_status VARCHAR2(1);
2011: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
2012: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2013: l_return_status VARCHAR2(1);
2014: l_msg_count NUMBER;
2015: l_msg_data VARCHAR2(2000);
2016: l_payment_set_id NUMBER;

Line 2046: llca_ra_rec ar_receivable_applications%rowtype;

2042: l_llca_app_msg_count NUMBER;
2043: lfc_msg_data VARCHAR2(2000);
2044: lfc_return_status VARCHAR2(1);
2045: lfc_msg_count NUMBER;
2046: llca_ra_rec ar_receivable_applications%rowtype;
2047: l_llca_trx_lines_tbl llca_trx_lines_tbl_type;
2048: l_line_number NUMBER;
2049: l_count NUMBER;
2050: l_ad_dflex_val_return_status VARCHAR2(1);

Line 2413: 'AR_RECEIVABLE_APPLICATIONS',

2409:
2410: --validate and default the flexfields
2411: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
2412: l_attribute_rec,
2413: 'AR_RECEIVABLE_APPLICATIONS',
2414: l_dflex_val_return_status
2415: );
2416:
2417:

Line 2551: jg_ar_receivable_applications.apply(

2547:
2548:
2549:
2550: --default and validate the global descriptive flexfield
2551: jg_ar_receivable_applications.apply(
2552: p_apply_before_after => 'BEFORE',
2553: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
2554: p_set_of_books_id => arp_global.set_of_books_id,
2555: p_cash_receipt_id => l_cash_receipt_id,

Line 2762: jg_ar_receivable_applications.apply(

2758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2760: END IF;
2761:
2762: jg_ar_receivable_applications.apply(
2763: p_apply_before_after => 'AFTER',
2764: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
2765: p_set_of_books_id => null,
2766: p_cash_receipt_id => null,

Line 2932: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

2928: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2931: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2932: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2933: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2934: p_called_from IN VARCHAR2 DEFAULT NULL,
2935: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
2936: p_org_id IN NUMBER DEFAULT NULL

Line 2933: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2931: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2932: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2933: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2934: p_called_from IN VARCHAR2 DEFAULT NULL,
2935: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
2936: p_org_id IN NUMBER DEFAULT NULL
2937: ) IS

Line 3077: FROM ar_receivable_applications

3073: amount_applied
3074: INTO l_application_ref_type,
3075: l_secondary_app_ref_id,
3076: l_amount_applied
3077: FROM ar_receivable_applications
3078: WHERE receivable_application_id = l_receivable_application_id;
3079: IF (l_application_ref_type = 'CLAIM' AND
3080: NVL(p_called_from,'RAPI') <> 'TRADE_MANAGEMENT')
3081: THEN

Line 3097: jg_ar_receivable_applications.Unapply(

3093: IF PG_DEBUG in ('Y', 'C') THEN
3094: arp_util.debug('Apply: ' || 'validation return status :'||l_val_return_status);
3095: END IF;
3096:
3097: jg_ar_receivable_applications.Unapply(
3098: l_cash_receipt_id,
3099: l_applied_payment_schedule_id,
3100: l_glob_return_status );
3101: --

Line 4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

4818: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4819: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4820: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4821: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4823: -- this is the allocated receipt amount
4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,

Line 4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

4820: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4821: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4823: -- this is the allocated receipt amount
4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

4821: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4823: -- this is the allocated receipt amount
4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,

4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4823: -- this is the allocated receipt amount
4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

Line 4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

4823: -- this is the allocated receipt amount
4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4831: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

Line 4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

4824: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4831: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4832: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */

Line 4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

4825: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4831: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4832: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4833: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

4826: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4831: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4832: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4833: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
4834: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 4834: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4831: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4832: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4833: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
4834: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
4835: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4836: -- ******* Global Flexfield parameters *******
4837: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4838: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 4838: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

4834: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
4835: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4836: -- ******* Global Flexfield parameters *******
4837: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4838: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
4839: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4840: p_org_id IN NUMBER DEFAULT NULL
4841: ) IS
4842: l_cash_receipt_id NUMBER(15);

Line 5149: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

5145: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
5146: -- ** OUT NOCOPY variables for Creating receipt
5147: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
5148: -- Receipt application parameters
5149: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5150: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5151: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5152: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5153: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,

Line 5150: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

5146: -- ** OUT NOCOPY variables for Creating receipt
5147: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
5148: -- Receipt application parameters
5149: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5150: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5151: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5152: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5153: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5154: -- ******* Global Flexfield parameters *******

Line 5151: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

5147: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
5148: -- Receipt application parameters
5149: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5150: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5151: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5152: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5153: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5154: -- ******* Global Flexfield parameters *******
5155: app_global_attribute_rec IN global_attribute_rec_type

Line 5152: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

5148: -- Receipt application parameters
5149: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5150: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5151: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5152: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5153: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5154: -- ******* Global Flexfield parameters *******
5155: app_global_attribute_rec IN global_attribute_rec_type
5156: DEFAULT global_attribute_rec_const,

Line 5157: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

5153: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5154: -- ******* Global Flexfield parameters *******
5155: app_global_attribute_rec IN global_attribute_rec_type
5156: DEFAULT global_attribute_rec_const,
5157: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5158: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5159: DEFAULT NULL,
5160: p_secondary_application_ref_id IN
5161: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

Line 5158: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE

5154: -- ******* Global Flexfield parameters *******
5155: app_global_attribute_rec IN global_attribute_rec_type
5156: DEFAULT global_attribute_rec_const,
5157: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5158: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5159: DEFAULT NULL,
5160: p_secondary_application_ref_id IN
5161: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
5162: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

Line 5161: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

5157: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5158: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5159: DEFAULT NULL,
5160: p_secondary_application_ref_id IN
5161: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
5162: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5163: DEFAULT NULL,
5164: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5165: p_secondary_app_ref_type IN

Line 5162: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

5158: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5159: DEFAULT NULL,
5160: p_secondary_application_ref_id IN
5161: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
5162: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5163: DEFAULT NULL,
5164: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5165: p_secondary_app_ref_type IN
5166: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

Line 5164: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

5160: p_secondary_application_ref_id IN
5161: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
5162: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5163: DEFAULT NULL,
5164: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5165: p_secondary_app_ref_type IN
5166: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5167: p_secondary_app_ref_num IN
5168: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

Line 5166: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

5162: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5163: DEFAULT NULL,
5164: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5165: p_secondary_app_ref_type IN
5166: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5167: p_secondary_app_ref_num IN
5168: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5169:
5170: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 5168: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

5164: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5165: p_secondary_app_ref_type IN
5166: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5167: p_secondary_app_ref_num IN
5168: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5169:
5170: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5171: p_org_id IN NUMBER DEFAULT NULL
5172: ) IS

Line 6235: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

6231: x_msg_data OUT NOCOPY VARCHAR2,
6232: -- Receipt application parameters.
6233: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6234: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6235: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
6236: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
6237: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
6238: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
6239: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,

Line 6236: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

6232: -- Receipt application parameters.
6233: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6234: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6235: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
6236: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
6237: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
6238: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
6239: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
6240: -- ******* Global Flexfield parameters *******

Line 6237: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

6233: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6234: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6235: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
6236: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
6237: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
6238: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
6239: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
6240: -- ******* Global Flexfield parameters *******
6241: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,

Line 6238: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

6234: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6235: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
6236: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
6237: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
6238: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
6239: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
6240: -- ******* Global Flexfield parameters *******
6241: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
6242: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 6242: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

6238: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
6239: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
6240: -- ******* Global Flexfield parameters *******
6241: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
6242: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
6243: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
6244: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
6245: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
6246: p_called_from IN VARCHAR2,

Line 6243: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,

6239: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
6240: -- ******* Global Flexfield parameters *******
6241: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
6242: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
6243: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
6244: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
6245: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
6246: p_called_from IN VARCHAR2,
6247: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,

Line 6244: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,

6240: -- ******* Global Flexfield parameters *******
6241: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
6242: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
6243: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
6244: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
6245: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
6246: p_called_from IN VARCHAR2,
6247: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
6248: p_secondary_app_ref_type IN

Line 6245: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,

6241: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
6242: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
6243: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
6244: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
6245: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
6246: p_called_from IN VARCHAR2,
6247: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
6248: p_secondary_app_ref_type IN
6249: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

Line 6247: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,

6243: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
6244: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
6245: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
6246: p_called_from IN VARCHAR2,
6247: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
6248: p_secondary_app_ref_type IN
6249: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
6250: p_secondary_app_ref_num IN
6251: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

Line 6249: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

6245: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
6246: p_called_from IN VARCHAR2,
6247: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
6248: p_secondary_app_ref_type IN
6249: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
6250: p_secondary_app_ref_num IN
6251: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
6252: p_org_id IN NUMBER DEFAULT NULL
6253: ) IS

Line 6251: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

6247: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
6248: p_secondary_app_ref_type IN
6249: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
6250: p_secondary_app_ref_num IN
6251: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
6252: p_org_id IN NUMBER DEFAULT NULL
6253: ) IS
6254: l_api_name CONSTANT VARCHAR2(20) := 'Apply_on_acount';
6255: l_api_version CONSTANT NUMBER := 1.0;

Line 6406: 'AR_RECEIVABLE_APPLICATIONS',

6402:
6403: --validate and default the flexfields
6404: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
6405: l_attribute_rec,
6406: 'AR_RECEIVABLE_APPLICATIONS',
6407: l_dflex_val_return_status
6408: );
6409:
6410: IF PG_DEBUG in ('Y', 'C') THEN

Line 6661: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

6657: x_msg_data OUT NOCOPY VARCHAR2 ,
6658: -- *** Receipt Info. parameters *****
6659: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6660: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6661: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6662: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6663: p_org_id IN NUMBER DEFAULT NULL
6664: ) IS
6665: l_api_name CONSTANT VARCHAR2(20) := 'Unapply_on_account';

Line 6662: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

6658: -- *** Receipt Info. parameters *****
6659: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6660: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6661: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6662: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6663: p_org_id IN NUMBER DEFAULT NULL
6664: ) IS
6665: l_api_name CONSTANT VARCHAR2(20) := 'Unapply_on_account';
6666: l_api_version CONSTANT NUMBER := 1.0;

Line 6969: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

6965: x_msg_data OUT NOCOPY VARCHAR2 ,
6966: -- *** Receipt Info. parameters *****
6967: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6968: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6969: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6970: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6971: p_cancel_claim_flag IN VARCHAR2,
6972: p_called_from IN VARCHAR2,
6973: p_org_id IN NUMBER DEFAULT NULL

Line 6970: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,

6966: -- *** Receipt Info. parameters *****
6967: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6968: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6969: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6970: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6971: p_cancel_claim_flag IN VARCHAR2,
6972: p_called_from IN VARCHAR2,
6973: p_org_id IN NUMBER DEFAULT NULL
6974: ) IS

Line 7071: FROM ar_receivable_applications

7067: , amount_applied
7068: INTO l_applied_ps_id
7069: , l_sec_app_ref_id
7070: , l_amount_applied
7071: FROM ar_receivable_applications
7072: WHERE receivable_application_id = p_receivable_application_id;
7073:
7074: /*------------------------------------------------+
7075: | Derive the id's for the entered values. |

Line 7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

7349: x_msg_data OUT NOCOPY VARCHAR2,
7350: -- Receipt application parameters.
7351: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7352: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

Line 7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

7352: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7358: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7359: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7360: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,

Line 7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7358: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7359: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7360: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7361: -- ******* Global Flexfield parameters *******

Line 7358: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7358: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7359: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7360: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7361: -- ******* Global Flexfield parameters *******
7362: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,

Line 7359: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7358: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7359: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7360: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7361: -- ******* Global Flexfield parameters *******
7362: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
7363: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 7363: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

7359: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7360: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7361: -- ******* Global Flexfield parameters *******
7362: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
7363: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
7364: p_application_ref_type IN OUT NOCOPY
7365: ar_receivable_applications.application_ref_type%TYPE,
7366: p_application_ref_id IN OUT NOCOPY
7367: ar_receivable_applications.application_ref_id%TYPE,

Line 7365: ar_receivable_applications.application_ref_type%TYPE,

7361: -- ******* Global Flexfield parameters *******
7362: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
7363: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
7364: p_application_ref_type IN OUT NOCOPY
7365: ar_receivable_applications.application_ref_type%TYPE,
7366: p_application_ref_id IN OUT NOCOPY
7367: ar_receivable_applications.application_ref_id%TYPE,
7368: p_application_ref_num IN OUT NOCOPY
7369: ar_receivable_applications.application_ref_num%TYPE,

Line 7367: ar_receivable_applications.application_ref_id%TYPE,

7363: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
7364: p_application_ref_type IN OUT NOCOPY
7365: ar_receivable_applications.application_ref_type%TYPE,
7366: p_application_ref_id IN OUT NOCOPY
7367: ar_receivable_applications.application_ref_id%TYPE,
7368: p_application_ref_num IN OUT NOCOPY
7369: ar_receivable_applications.application_ref_num%TYPE,
7370: p_secondary_application_ref_id IN OUT NOCOPY
7371: ar_receivable_applications.secondary_application_ref_id%TYPE,

Line 7369: ar_receivable_applications.application_ref_num%TYPE,

7365: ar_receivable_applications.application_ref_type%TYPE,
7366: p_application_ref_id IN OUT NOCOPY
7367: ar_receivable_applications.application_ref_id%TYPE,
7368: p_application_ref_num IN OUT NOCOPY
7369: ar_receivable_applications.application_ref_num%TYPE,
7370: p_secondary_application_ref_id IN OUT NOCOPY
7371: ar_receivable_applications.secondary_application_ref_id%TYPE,
7372: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7373: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 7371: ar_receivable_applications.secondary_application_ref_id%TYPE,

7367: ar_receivable_applications.application_ref_id%TYPE,
7368: p_application_ref_num IN OUT NOCOPY
7369: ar_receivable_applications.application_ref_num%TYPE,
7370: p_secondary_application_ref_id IN OUT NOCOPY
7371: ar_receivable_applications.secondary_application_ref_id%TYPE,
7372: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7373: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7375: p_val_writeoff_limits_flag IN VARCHAR2,

Line 7372: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,

7368: p_application_ref_num IN OUT NOCOPY
7369: ar_receivable_applications.application_ref_num%TYPE,
7370: p_secondary_application_ref_id IN OUT NOCOPY
7371: ar_receivable_applications.secondary_application_ref_id%TYPE,
7372: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7373: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7375: p_val_writeoff_limits_flag IN VARCHAR2,
7376: p_called_from IN VARCHAR2,

Line 7373: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

7369: ar_receivable_applications.application_ref_num%TYPE,
7370: p_secondary_application_ref_id IN OUT NOCOPY
7371: ar_receivable_applications.secondary_application_ref_id%TYPE,
7372: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7373: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7375: p_val_writeoff_limits_flag IN VARCHAR2,
7376: p_called_from IN VARCHAR2,
7377: p_netted_receipt_flag IN VARCHAR2,

Line 7374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,

7370: p_secondary_application_ref_id IN OUT NOCOPY
7371: ar_receivable_applications.secondary_application_ref_id%TYPE,
7372: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7373: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7375: p_val_writeoff_limits_flag IN VARCHAR2,
7376: p_called_from IN VARCHAR2,
7377: p_netted_receipt_flag IN VARCHAR2,
7378: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

Line 7380: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

7376: p_called_from IN VARCHAR2,
7377: p_netted_receipt_flag IN VARCHAR2,
7378: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
7379: p_secondary_app_ref_type IN
7380: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
7381: p_secondary_app_ref_num IN
7382: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7383: p_org_id IN NUMBER DEFAULT NULL,
7384: p_customer_reason IN

Line 7382: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

7378: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
7379: p_secondary_app_ref_type IN
7380: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
7381: p_secondary_app_ref_num IN
7382: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7383: p_org_id IN NUMBER DEFAULT NULL,
7384: p_customer_reason IN
7385: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
7386: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE

Line 7385: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL

7381: p_secondary_app_ref_num IN
7382: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7383: p_org_id IN NUMBER DEFAULT NULL,
7384: p_customer_reason IN
7385: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
7386: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE
7387: ,p_pay_alone_flag IN VARCHAR2
7388: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
7389: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE

Line 7417: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

7413: ln_rec_application_id NUMBER;
7414: l_cr_date DATE;
7415: l_cr_payment_schedule_id NUMBER;
7416: l_cr_currency_code VARCHAR2(15);
7417: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7418: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;

Line 7418: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

7414: l_cr_date DATE;
7415: l_cr_payment_schedule_id NUMBER;
7416: l_cr_currency_code VARCHAR2(15);
7417: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7418: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7422: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;

Line 7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

7415: l_cr_payment_schedule_id NUMBER;
7416: l_cr_currency_code VARCHAR2(15);
7417: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7418: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7422: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7423: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;

Line 7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

7416: l_cr_currency_code VARCHAR2(15);
7417: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7418: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7422: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7423: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7424: l_acctd_amount_applied_from NUMBER;

Line 7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;

7417: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7418: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7422: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7423: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7424: l_acctd_amount_applied_from NUMBER;
7425: l_acctd_amount_applied_to NUMBER;

Line 7422: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;

7418: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7422: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7423: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7424: l_acctd_amount_applied_from NUMBER;
7425: l_acctd_amount_applied_to NUMBER;
7426: l_org_return_status VARCHAR2(1);

Line 7423: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;

7419: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7420: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7421: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7422: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7423: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7424: l_acctd_amount_applied_from NUMBER;
7425: l_acctd_amount_applied_to NUMBER;
7426: l_org_return_status VARCHAR2(1);
7427: l_org_id NUMBER;

Line 8033: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

8029: x_msg_data OUT NOCOPY VARCHAR2 ,
8030: -- *** Receipt Info. parameters *****
8031: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8032: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8033: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
8034: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
8035: p_called_from IN VARCHAR2,
8036: p_org_id IN NUMBER DEFAULT NULL
8037: ) IS

Line 8034: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

8030: -- *** Receipt Info. parameters *****
8031: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8032: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8033: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
8034: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
8035: p_called_from IN VARCHAR2,
8036: p_org_id IN NUMBER DEFAULT NULL
8037: ) IS
8038: l_api_name CONSTANT VARCHAR2(20) := 'Activity_unapp';

Line 8052: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

8048: l_bal_due_remaining NUMBER;
8049: l_org_return_status VARCHAR2(1);
8050: l_org_id NUMBER;
8051: l_cr_unapp_amt NUMBER; /* Bug fix 3569640 */
8052: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8053: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
8054: l_refund_return_status VARCHAR2(1);
8055: BEGIN
8056: /*------------------------------------+

Line 8169: FROM ar_receivable_applications

8165:
8166: /* Refunds - check for refund and cancel if refund application */
8167: SELECT applied_payment_schedule_id, application_ref_id
8168: INTO l_applied_ps_id, l_application_ref_id
8169: FROM ar_receivable_applications
8170: WHERE receivable_application_id = l_receivable_application_id;
8171:
8172: IF (l_applied_ps_id = -8 AND p_called_from <> 'AR_REFUNDS_GRP') THEN
8173: ar_refunds_pvt.cancel_refund(

Line 8369: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

8365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8366: x_return_status OUT NOCOPY VARCHAR2,
8367: x_msg_count OUT NOCOPY NUMBER,
8368: x_msg_data OUT NOCOPY VARCHAR2,
8369: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8370: -- Receipt application parameters.
8371: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8372: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

8369: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8370: -- Receipt application parameters.
8371: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8372: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,

8370: -- Receipt application parameters.
8371: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8372: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,

8371: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8372: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,

Line 8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

8372: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,

Line 8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,

Line 8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8382: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,

Line 8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,

8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8382: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8383: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,

Line 8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,

8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8382: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8383: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,

Line 8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,

8377: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8382: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8383: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8385: -- ******* Global Flexfield parameters *******

Line 8382: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,

8378: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8382: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8383: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8385: -- ******* Global Flexfield parameters *******
8386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,

Line 8383: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,

8379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8380: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8381: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8382: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8383: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8385: -- ******* Global Flexfield parameters *******
8386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 8387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

8383: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8385: -- ******* Global Flexfield parameters *******
8386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8388: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8389: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8390: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8391: p_called_from IN VARCHAR2,

Line 8388: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,

8384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8385: -- ******* Global Flexfield parameters *******
8386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8388: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8389: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8390: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8391: p_called_from IN VARCHAR2,
8392: p_org_id IN NUMBER DEFAULT NULL

Line 8389: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

8385: -- ******* Global Flexfield parameters *******
8386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8388: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8389: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8390: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8391: p_called_from IN VARCHAR2,
8392: p_org_id IN NUMBER DEFAULT NULL
8393: ) IS

Line 8390: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

8386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8388: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8389: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8390: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8391: p_called_from IN VARCHAR2,
8392: p_org_id IN NUMBER DEFAULT NULL
8393: ) IS
8394: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Other_account';

Line 8413: l_applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE;

8409: l_dflex_val_return_status VARCHAR2(1);
8410: l_attribute_rec attribute_rec_type;
8411: l_cr_currency_code VARCHAR2(15);
8412: l_receivables_trx_id NUMBER;
8413: l_applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE;
8414: l_gdflex_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
8415: l_global_attribute_rec global_attribute_rec_type;
8416:
8417: -- Bug # 2707702

Line 8418: l_temp_ref_id ar_receivable_applications.application_ref_id%TYPE;

8414: l_gdflex_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
8415: l_global_attribute_rec global_attribute_rec_type;
8416:
8417: -- Bug # 2707702
8418: l_temp_ref_id ar_receivable_applications.application_ref_id%TYPE;
8419: l_temp_ref_num ar_receivable_applications.application_ref_num%TYPE;
8420: l_claim_reason_name VARCHAR2(100);
8421: l_org_return_status VARCHAR2(1);
8422: l_org_id NUMBER;

Line 8419: l_temp_ref_num ar_receivable_applications.application_ref_num%TYPE;

8415: l_global_attribute_rec global_attribute_rec_type;
8416:
8417: -- Bug # 2707702
8418: l_temp_ref_id ar_receivable_applications.application_ref_id%TYPE;
8419: l_temp_ref_num ar_receivable_applications.application_ref_num%TYPE;
8420: l_claim_reason_name VARCHAR2(100);
8421: l_org_return_status VARCHAR2(1);
8422: l_org_id NUMBER;
8423:

Line 8573: 'AR_RECEIVABLE_APPLICATIONS',

8569:
8570: --validate and default the flexfields
8571: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
8572: l_attribute_rec,
8573: 'AR_RECEIVABLE_APPLICATIONS',
8574: l_dflex_val_return_status
8575: );
8576: arp_util.debug('Desc flexfield Validation return status :'||l_dflex_val_return_status);
8577:

Line 8579: jg_ar_receivable_applications.apply(

8575: );
8576: arp_util.debug('Desc flexfield Validation return status :'||l_dflex_val_return_status);
8577:
8578: --default and validate the global descriptive flexfield
8579: jg_ar_receivable_applications.apply(
8580: p_apply_before_after => 'BEFORE',
8581: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
8582: p_set_of_books_id => arp_global.set_of_books_id,
8583: p_cash_receipt_id => l_cash_receipt_id,

Line 9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,

9670: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9677: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9678: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9677: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9678: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9679: p_called_from IN VARCHAR2 ,

Line 9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9677: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9678: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9679: p_called_from IN VARCHAR2 ,
9680: p_attribute_rec IN attribute_rec_type,

Line 9677: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,

9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9677: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9678: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9679: p_called_from IN VARCHAR2 ,
9680: p_attribute_rec IN attribute_rec_type,
9681: -- ******* Global Flexfield parameters *******

Line 9678: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9677: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9678: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9679: p_called_from IN VARCHAR2 ,
9680: p_attribute_rec IN attribute_rec_type,
9681: -- ******* Global Flexfield parameters *******
9682: p_global_attribute_rec IN global_attribute_rec_type,

Line 9683: p_comments IN ar_receivable_applications.comments%TYPE,

9679: p_called_from IN VARCHAR2 ,
9680: p_attribute_rec IN attribute_rec_type,
9681: -- ******* Global Flexfield parameters *******
9682: p_global_attribute_rec IN global_attribute_rec_type,
9683: p_comments IN ar_receivable_applications.comments%TYPE,
9684: p_org_id IN NUMBER DEFAULT NULL,
9685: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9686: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9687: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 9685: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,

9681: -- ******* Global Flexfield parameters *******
9682: p_global_attribute_rec IN global_attribute_rec_type,
9683: p_comments IN ar_receivable_applications.comments%TYPE,
9684: p_org_id IN NUMBER DEFAULT NULL,
9685: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9686: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9687: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9688: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9689: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE

Line 9686: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

9682: p_global_attribute_rec IN global_attribute_rec_type,
9683: p_comments IN ar_receivable_applications.comments%TYPE,
9684: p_org_id IN NUMBER DEFAULT NULL,
9685: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9686: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9687: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9688: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9689: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9690: ) IS

Line 9687: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

9683: p_comments IN ar_receivable_applications.comments%TYPE,
9684: p_org_id IN NUMBER DEFAULT NULL,
9685: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9686: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9687: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9688: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9689: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9690: ) IS
9691: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';

Line 9688: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,

9684: p_org_id IN NUMBER DEFAULT NULL,
9685: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9686: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9687: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9688: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9689: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9690: ) IS
9691: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9692: l_api_version CONSTANT NUMBER := 1.0;

Line 9689: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE

9685: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9686: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9687: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9688: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9689: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9690: ) IS
9691: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9692: l_api_version CONSTANT NUMBER := 1.0;
9693: l_cash_receipt_id NUMBER;

Line 9698: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

9694: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9695: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9696: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9697: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9698: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9699: l_cr_gl_date DATE;
9700: l_open_cr_gl_date DATE;
9701: l_cr_date DATE;
9702: l_last_receipt_date DATE;

Line 9726: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

9722: l_attribute_rec attribute_rec_type;
9723: l_global_attribute_rec global_attribute_rec_type;
9724: l_remi_bank_acct_use_id NUMBER;
9725: l_receipt_method_id NUMBER;
9726: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;

Line 9727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

9723: l_global_attribute_rec global_attribute_rec_type;
9724: l_remi_bank_acct_use_id NUMBER;
9725: l_receipt_method_id NUMBER;
9726: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;

Line 9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

9724: l_remi_bank_acct_use_id NUMBER;
9725: l_receipt_method_id NUMBER;
9726: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

Line 9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

9725: l_receipt_method_id NUMBER;
9726: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;

9726: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

Line 9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;

9727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

Line 9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

9728: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9736: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;

Line 9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

9729: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9736: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9737: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;

Line 9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

9730: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9736: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9737: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9738: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

Line 9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

9731: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9732: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9733: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9736: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9737: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9738: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9739: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

Line 9738: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

9734: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9736: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9737: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9738: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9739: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9740: l_open_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9741: l_return_status VARCHAR2(1);
9742: l_msg_count NUMBER;

Line 9739: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

9735: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9736: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9737: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9738: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9739: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9740: l_open_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9741: l_return_status VARCHAR2(1);
9742: l_msg_count NUMBER;
9743: l_reapply_msg_count NUMBER;

Line 9740: l_open_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

9736: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9737: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9738: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9739: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9740: l_open_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9741: l_return_status VARCHAR2(1);
9742: l_msg_count NUMBER;
9743: l_reapply_msg_count NUMBER;
9744: l_unapply_msg_count NUMBER;

Line 9750: l_app_rec ar_receivable_applications%ROWTYPE;

9746: l_act2_msg_count NUMBER;
9747: l_msg_data VARCHAR2(2000);
9748: l_called_from VARCHAR2(100);
9749:
9750: l_app_rec ar_receivable_applications%ROWTYPE;
9751: l_org_return_status VARCHAR2(1);
9752: l_org_id NUMBER;
9753:
9754: BEGIN

Line 9903: 'AR_RECEIVABLE_APPLICATIONS',

9899:
9900: --validate and default the flexfields
9901: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
9902: l_attribute_rec,
9903: 'AR_RECEIVABLE_APPLICATIONS',
9904: l_dflex_val_return_status
9905: );
9906:
9907: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');

Line 10304: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

10300: p_validation_level IN NUMBER,
10301: x_return_status OUT NOCOPY VARCHAR2 ,
10302: x_msg_count OUT NOCOPY NUMBER ,
10303: x_msg_data OUT NOCOPY VARCHAR2 ,
10304: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
10305: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
10306: p_called_from IN VARCHAR2,
10307: p_org_id IN NUMBER DEFAULT NULL
10308: ) IS

Line 10305: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,

10301: x_return_status OUT NOCOPY VARCHAR2 ,
10302: x_msg_count OUT NOCOPY NUMBER ,
10303: x_msg_data OUT NOCOPY VARCHAR2 ,
10304: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
10305: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
10306: p_called_from IN VARCHAR2,
10307: p_org_id IN NUMBER DEFAULT NULL
10308: ) IS
10309:

Line 11376: update ar_receivable_applications SET

11372: IF PG_DEBUG in ('Y','C') THEN
11373: arp_standard.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));
11374: END IF;
11375:
11376: update ar_receivable_applications SET
11377: last_update_date = sysdate,
11378: request_id = p_request_id
11379: WHERE cash_receipt_id in
11380: ( select cash_receipt_id

Line 11393: INDEX (RA AR_RECEIVABLE_APPLICATIONS_N1) */

11389: END IF;
11390:
11391:
11392: select /*+ LEADING (GT) INDEX (GT AR_CREATE_RECEIPTS_GT_N2) USE_NL(GT RA)
11393: INDEX (RA AR_RECEIVABLE_APPLICATIONS_N1) */
11394: min(gt.cash_receipt_id),
11395: max(gt.cash_receipt_id),
11396: min(ra.receivable_application_id),
11397: max(ra.receivable_application_id)

Line 11402: from ar_create_receipts_gt gt, ar_receivable_applications ra

11398: into l_from_doc_id,
11399: l_to_doc_id,
11400: l_from_ra_doc_id,
11401: l_to_ra_doc_id
11402: from ar_create_receipts_gt gt, ar_receivable_applications ra
11403: where gt.cash_receipt_id = ra.cash_receipt_id
11404: AND gt_id = p_gt_id
11405: and gt.request_id = p_request_id
11406: and return_error_status = 'S'

Line 11919: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

11915: x_msg_count OUT NOCOPY NUMBER,
11916: x_msg_data OUT NOCOPY VARCHAR2,
11917: -- Receipt application parameters.
11918: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
11919: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
11920: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
11921: p_location IN ar_cash_receipts.customer_site_use_id%TYPE
11922: ) IS
11923: l_api_name CONSTANT VARCHAR2(20) := 'Change_customer';

Line 12105: UPDATE ar_receivable_applications

12101: | Update receivable_application with new value|
12102: +-----------------------------------------------*/
12103:
12104: BEGIN
12105: UPDATE ar_receivable_applications
12106: SET ON_ACCT_CUST_ID = l_customer_id,
12107: ON_ACCT_CUST_SITE_USE_ID = l_location
12108: WHERE cash_receipt_id = l_cash_receipt_id
12109: AND receivable_application_id = l_receivable_application_id;