APPS.AR_IREC_APPLY_CREDITS dependencies on AR_IREC_APPLY_CREDIT_GT

Line 172: INSERT INTO ar_irec_apply_credit_gt

168: FOR trx IN transaction_list(p_customer_id,
169: p_customer_site_use_id,
170: p_currency_code )
171: LOOP
172: INSERT INTO ar_irec_apply_credit_gt
173: (
174: CUSTOMER_ID,
175: CUSTOMER_SITE_USE_ID,
176: ACCOUNT_NUMBER,

Line 511: INSERT INTO ar_irec_apply_credit_gt

507: l_pay_for_cust_id := l_customer_id;
508: l_pay_for_cust_site_id := l_customer_site_use_id;
509: end if;
510:
511: INSERT INTO ar_irec_apply_credit_gt
512: (
513: CUSTOMER_ID,
514: CUSTOMER_SITE_USE_ID,
515: ACCOUNT_NUMBER,

Line 709: DELETE FROM ar_irec_apply_credit_gt

705: IF (PG_DEBUG = 'Y') THEN
706: arp_standard.debug(l_debug_info);
707: END IF;
708:
709: DELETE FROM ar_irec_apply_credit_gt
710: WHERE customer_id = p_customer_id
711: AND customer_site_use_id = nvl(p_customer_site_use_id, customer_site_use_id)
712: AND currency_code = p_currency_code
713: AND ( trx_class = 'INV' OR

Line 785: DELETE FROM ar_irec_apply_credit_gt

781: IF (PG_DEBUG = 'Y') THEN
782: arp_standard.debug(l_debug_info);
783: END IF;
784:
785: DELETE FROM ar_irec_apply_credit_gt
786: WHERE customer_id = p_customer_id
787: AND customer_site_use_id = nvl(p_customer_site_use_id, customer_site_use_id)
788: AND currency_code = p_currency_code
789: AND ( trx_class = 'CM' OR

Line 854: DELETE FROM ar_irec_apply_credit_gt

850: IF (PG_DEBUG = 'Y') THEN
851: arp_standard.debug(l_debug_info);
852: END IF;
853:
854: DELETE FROM ar_irec_apply_credit_gt
855: WHERE payment_schedule_id = p_payment_schedule_id;
856:
857: COMMIT;
858:

Line 922: DELETE FROM ar_irec_apply_credit_gt;

918: arp_standard.debug(l_debug_info);
919: END IF;
920: -- Bug 5076215 - Apply Credits GT contains data related to the customer and its related customer,
921: -- the related customer transactions are not getting cleared. Since GT contains only session specific data removed the where condition.
922: DELETE FROM ar_irec_apply_credit_gt;
923: COMMIT;
924:
925: EXCEPTION
926: WHEN OTHERS THEN

Line 998: DELETE FROM ar_irec_apply_credit_gt WHERE PRINTING_OPTION <> 'Y';

994:
995: l_procedure_name := '.apply_credits';
996: x_cash_receipt_id := 0;
997:
998: DELETE FROM ar_irec_apply_credit_gt WHERE PRINTING_OPTION <> 'Y';
999: COMMIT;
1000:
1001: if(p_driving_customer_id is NOT NULL and p_driving_customer_id <> p_customer_id) then
1002: l_customer_id := p_driving_customer_id;

Line 1126: FROM ar_irec_apply_credit_gt

1122: SERVICE_CHARGE,
1123: DISCOUNT_AMOUNT,
1124: APPLICATION_AMOUNT,
1125: CASH_RECEIPT_ID
1126: FROM ar_irec_apply_credit_gt
1127: WHERE CURRENCY_CODE = p_currency_code
1128: AND ( TRX_CLASS = 'INV' OR
1129: TRX_CLASS = 'DM' OR
1130: TRX_CLASS = 'CB' OR

Line 1157: FROM ar_irec_apply_credit_gt

1153: SERVICE_CHARGE,
1154: DISCOUNT_AMOUNT,
1155: APPLICATION_AMOUNT,
1156: CASH_RECEIPT_ID
1157: FROM ar_irec_apply_credit_gt
1158: WHERE CURRENCY_CODE = p_currency_code
1159: AND ( TRX_CLASS = 'CM' OR
1160: TRX_CLASS = 'PMT'
1161: )

Line 1540: FROM ar_irec_apply_credit_gt

1536: SERVICE_CHARGE,
1537: DISCOUNT_AMOUNT,
1538: APPLICATION_AMOUNT,
1539: CASH_RECEIPT_ID
1540: FROM ar_irec_apply_credit_gt
1541: WHERE CURRENCY_CODE = p_currency_code
1542: AND ( TRX_CLASS = 'INV' OR
1543: TRX_CLASS = 'DM' OR
1544: TRX_CLASS = 'CB' OR

Line 1571: FROM ar_irec_apply_credit_gt

1567: SERVICE_CHARGE,
1568: DISCOUNT_AMOUNT,
1569: APPLICATION_AMOUNT,
1570: CASH_RECEIPT_ID
1571: FROM ar_irec_apply_credit_gt
1572: WHERE CURRENCY_CODE = p_currency_code
1573: AND ( TRX_CLASS = 'CM' OR
1574: TRX_CLASS = 'PMT'
1575: )

Line 1980: FROM ar_irec_apply_credit_gt

1976: CUSTOMER_SITE_USE_ID,
1977: TRX_CLASS,
1978: PAYMENT_SCHEDULE_ID,
1979: CURRENCY_CODE
1980: FROM ar_irec_apply_credit_gt
1981: WHERE PAY_FOR_CUSTOMER_ID = p_customer_id
1982: AND ( (PAY_FOR_CUSTOMER_SITE_ID IS NULL AND p_customer_site_use_id IS NULL) OR CUSTOMER_SITE_USE_ID = nvl(p_customer_site_use_id,CUSTOMER_SITE_USE_ID))
1983: AND CURRENCY_CODE = p_currency_code
1984: AND ( TRX_CLASS = 'INV' OR

Line 2083: from ar_irec_apply_credit_gt acgt

2079: x_debit_ps_id OUT NOCOPY NUMBER)
2080: IS
2081: CURSOR credit_to_apply (p_currency_code VARCHAR2) IS
2082: select acgt.payment_schedule_id
2083: from ar_irec_apply_credit_gt acgt
2084: where acgt.currency_code = p_currency_code
2085: and acgt.trx_class = 'PMT'
2086:
2087: or ( (

Line 2089: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2085: and acgt.trx_class = 'PMT'
2086:
2087: or ( (
2088: select sum(amount_applied)
2089: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2090: where acgt1.currency_code = p_currency_code
2091: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2092: and arp.payment_schedule_id = acgt.payment_schedule_id) = 0
2093: )

Line 2102: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1

2098: /* bug#6311033-APPLY CREDIT FAILS WITH YOU HAVE PAID SAME INVOICE TWICE ERROR */
2099:
2100: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2101: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2102: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2103: where acgt.currency_code = p_currency_code
2104: and acgt.trx_class = 'PMT'
2105: and acgt.payment_schedule_id = arp.payment_schedule_id
2106: and acgt1.currency_code = p_currency_code

Line 2110: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2106: and acgt1.currency_code = p_currency_code
2107: and acgt1.payment_schedule_id = arp.applied_payment_schedule_id
2108: and (
2109: select sum(amount_applied)
2110: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2111: where acgt1.currency_code = p_currency_code
2112: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2113: and arp.payment_schedule_id = acgt.payment_schedule_id) > 0;
2114: