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

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_CUST_TRX_TYPES

Line 154: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE := NULL;

150: X_new_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE := NULL;
151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;
153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;
154: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE := NULL;
155: l_cust_trx_type_name ra_cust_trx_types.NAME%TYPE := NULL;
156:
157: x_msg_data VARCHAR2(1000);
158: x_msg_count NUMBER;

Line 155: l_cust_trx_type_name ra_cust_trx_types.NAME%TYPE := NULL;

151: X_new_rowid VARCHAR2(18) := NULL;
152: l_batch_source_id ra_batch_sources.batch_source_id%TYPE := NULL;
153: l_batch_source_name ra_batch_sources.NAME%TYPE := NULL;
154: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE := NULL;
155: l_cust_trx_type_name ra_cust_trx_types.NAME%TYPE := NULL;
156:
157: x_msg_data VARCHAR2(1000);
158: x_msg_count NUMBER;
159:

Line 3134: FROM ra_cust_trx_types_all

3130: l_progress := 200;
3131: BEGIN
3132: SELECT SUBSEQUENT_TRX_TYPE_ID
3133: INTO l_inv_trx_type_id
3134: FROM ra_cust_trx_types_all
3135: WHERE CUST_TRX_TYPE_ID = l_pon_emd_fin_parameters.RA_TRX_TYPE_ID
3136: AND org_id = l_org_id;
3137: EXCEPTION
3138: WHEN No_Data_Found THEN

Line 4331: ra_cust_trx_types_all ctyp,

4327: INTO x_cash_receipt_id,
4328: x_receivable_app_id
4329: from ar_receivable_applications_all arp,
4330: ra_customer_trx_all rct,
4331: ra_cust_trx_types_all ctyp,
4332: ar_cash_receipts_all acr
4333: where arp.applied_customer_trx_id = p_parent_trx_id
4334: AND arp.org_id = p_org_id
4335: AND arp.status = 'APP'

Line 4578: l_type ra_cust_trx_types.TYPE%TYPE;

4574: p_org_id IN NUMBER,
4575: x_return_status OUT NOCOPY VARCHAR2)
4576: IS
4577:
4578: l_type ra_cust_trx_types.TYPE%TYPE;
4579: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%TYPE;
4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;
4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;

Line 4579: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%TYPE;

4575: x_return_status OUT NOCOPY VARCHAR2)
4576: IS
4577:
4578: l_type ra_cust_trx_types.TYPE%TYPE;
4579: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%TYPE;
4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;
4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;

Line 4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;

4576: IS
4577:
4578: l_type ra_cust_trx_types.TYPE%TYPE;
4579: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%TYPE;
4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;
4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;

Line 4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;

4577:
4578: l_type ra_cust_trx_types.TYPE%TYPE;
4579: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%TYPE;
4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;
4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;

Line 4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;

4578: l_type ra_cust_trx_types.TYPE%TYPE;
4579: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%TYPE;
4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;
4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;

Line 4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;

4579: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%TYPE;
4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;
4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;

Line 4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;

4580: l_subsequent_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%TYPE;
4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;

Line 4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;

4581: l_post_to_gl ra_cust_trx_types.post_to_gl%TYPE;
4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;

Line 4586: l_default_status ra_cust_trx_types.default_status%TYPE;

4582: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;

Line 4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;

4583: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;

Line 4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;

4584: l_natural_app_only_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;

Line 4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;

4585: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;
4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;

Line 4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;

4586: l_default_status ra_cust_trx_types.default_status%TYPE;
4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;
4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;
4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;

Line 4591: l_start_date ra_cust_trx_types.start_date%TYPE;

4587: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%TYPE;
4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;
4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;
4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;
4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;

Line 4592: l_end_date ra_cust_trx_types.end_date%TYPE;

4588: l_exclude_from_late_charges ra_cust_trx_types.exclude_from_late_charges%TYPE;
4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;
4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;
4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;
4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;
4596:

Line 4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;

4589: l_gl_id_rec ra_cust_trx_types.gl_id_rec%TYPE;
4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;
4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;
4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;
4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;
4596:
4597: l_batch_source_name ra_batch_sources.NAME%TYPE;

Line 4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;

4590: l_gl_id_rev ra_cust_trx_types.gl_ID_rev%TYPE;
4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;
4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;
4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;
4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;
4596:
4597: l_batch_source_name ra_batch_sources.NAME%TYPE;
4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;

Line 4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;

4591: l_start_date ra_cust_trx_types.start_date%TYPE;
4592: l_end_date ra_cust_trx_types.end_date%TYPE;
4593: l_deposit_trx_name ra_cust_trx_types.name%TYPE;
4594: l_cm_trx_name ra_cust_trx_types.NAME%TYPE;
4595: l_invoice_trx_name ra_cust_trx_types.NAME%TYPE;
4596:
4597: l_batch_source_name ra_batch_sources.NAME%TYPE;
4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;

Line 4688: FROM ra_cust_trx_types_all

4684: l_gl_id_rev,
4685: l_start_date,
4686: l_end_date,
4687: l_deposit_trx_name
4688: FROM ra_cust_trx_types_all
4689: WHERE CUST_TRX_TYPE_ID = p_ra_trx_type_id
4690: AND org_id = p_org_id;
4691: EXCEPTION
4692: WHEN No_Data_Found THEN

Line 4730: FROM ra_cust_trx_types_all

4726: END IF;
4727: ELSIF (p_transaction_type_code = G_EMD_REFUND) THEN
4728: SELECT CREDIT_MEMO_TYPE_ID
4729: INTO l_credit_memo_type_id
4730: FROM ra_cust_trx_types_all
4731: WHERE CUST_TRX_TYPE_ID = p_ra_trx_type_id
4732: AND org_id = p_org_id;
4733: print_log('l_credit_memo_type_id:'||l_credit_memo_type_id);
4734: IF (l_credit_memo_type_id IS NULL) THEN

Line 4768: FROM ra_cust_trx_types_all

4764: l_gl_id_rev,
4765: l_start_date,
4766: l_end_date,
4767: l_cm_trx_name
4768: FROM ra_cust_trx_types_all
4769: WHERE CUST_TRX_TYPE_ID = l_credit_memo_type_id
4770: AND org_id = p_org_id;
4771: print_log('l_start_date:'||l_start_date||' l_end_date:'||l_end_date);
4772: IF NOT((Trunc(SYSDATE) >= l_start_date) AND

Line 4803: FROM ra_cust_trx_types_all

4799: END IF;
4800: ELSIF (p_transaction_type_code = G_EMD_FORFEIT) THEN
4801: SELECT SUBSEQUENT_TRX_TYPE_ID
4802: INTO l_subsequent_trx_type_id
4803: FROM ra_cust_trx_types_all
4804: WHERE CUST_TRX_TYPE_ID = p_ra_trx_type_id
4805: AND org_id = p_org_id;
4806:
4807: IF (l_subsequent_trx_type_id IS NULL) THEN

Line 4841: FROM ra_cust_trx_types_all

4837: l_gl_id_rev,
4838: l_start_date,
4839: l_end_date,
4840: l_invoice_trx_name
4841: FROM ra_cust_trx_types_all
4842: WHERE CUST_TRX_TYPE_ID = l_subsequent_trx_type_id
4843: AND org_id = p_org_id;
4844:
4845: IF NOT((Trunc(SYSDATE) >= l_start_date) AND

Line 5550: l_cust_trx_name ra_cust_trx_types.NAME%TYPE;

5546: message_text VARCHAR2(240);
5547: invalid_value VARCHAR2(240);
5548: concat_err_msg VARCHAR2(2000);
5549: l_return_status VARCHAR2(1);
5550: l_cust_trx_name ra_cust_trx_types.NAME%TYPE;
5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;

Line 5633: FROM ra_cust_trx_types_all

5629:
5630: BEGIN
5631: SELECT NAME
5632: INTO l_cust_trx_name
5633: FROM ra_cust_trx_types_all
5634: WHERE CUST_TRX_TYPE_ID = p_in_rec.trx_type_id
5635: AND org_id = p_in_rec.org_id;
5636: EXCEPTION
5637: WHEN OTHERS THEN