[Home] [Help]
2074:
2075: --bug 8771563
2076: SELECT asp.when_to_account_pmt
2077: INTO l_when_to_acct
2078: FROM ap_checks ac, ap_system_parameters asp
2079: WHERE ac.check_id = p_check_id
2080: AND ac.org_id = asp.org_id;
2081:
2082: IF (p_event_type IN (PAYMENT_CANCELLED_TYPE, REFUND_CANCELLED_TYPE,PAYMENT_CREATED_TYPE, REFUND_RECORDED_TYPE,
2128: IF (p_event_type IN (PAYMENT_MATURTY_TRX_TYPE, PAYMENT_MATURTY_RVRSL_TRX_TYPE)) THEN
2129: BEGIN
2130: SELECT 1
2131: INTO l_dummy
2132: FROM ap_checks_all ac,
2133: ap_system_parameters_all asp
2134: WHERE ac.check_id =l_event_source_info.source_id_int_1
2135: AND ac.org_id = asp.org_id
2136: AND exists (
2157: ELSE
2158: BEGIN
2159: SELECT 1
2160: INTO l_dummy
2161: FROM ap_checks_all ac,
2162: ap_system_parameters_all asp
2163: WHERE ac.check_id =l_event_source_info.source_id_int_1
2164: AND ac.org_id = asp.org_id
2165: /*AND not exists (
2185: /*
2186: BEGIN
2187: SELECT 1
2188: INTO l_dummy
2189: FROM ap_checks_all ac,
2190: ap_system_parameters_all asp
2191: WHERE ac.check_id =l_event_source_info.source_id_int_1
2192: AND ac.org_id = asp.org_id
2193: AND exists (
2211: WHEN NO_DATA_FOUND THEN
2212: BEGIN
2213: SELECT 1
2214: INTO l_dummy
2215: FROM ap_checks_all ac,
2216: ap_system_parameters_all asp
2217: WHERE ac.check_id =l_event_source_info.source_id_int_1
2218: AND ac.org_id = asp.org_id
2219: AND not exists (
2310: l_currency_code,
2311: l_maturity_exchange_rate_type,
2312: l_maturity_exchange_date,
2313: l_maturity_exchange_Rate
2314: from ap_Checks
2315: where check_id = P_check_id;
2316:
2317: l_log_msg := 'Before ap_reconciliation_pkg.recon_payment_history';
2318: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2696: BEGIN
2697: select DISTINCT ac.check_id --bug10024752
2698: into l_check_id
2699: from ap_invoice_payments_all aip,
2700: ap_checks_all ac
2701: where aip.check_id=ac.check_id
2702: and aip.accounting_event_id = l_accounting_event_ids(i)
2703: and aip.invoice_id=l_event_source_info.source_id_int_1;
2704:
2712: --bug 8358552 starts
2713: BEGIN
2714: SELECT 1
2715: INTO l_dummy
2716: FROM ap_checks_all ac,
2717: ap_system_parameters_all asp
2718: WHERE ac.check_id =l_event_source_info.source_id_int_1
2719: AND ac.org_id = asp.org_id
2720: AND( (ac.currency_code <> asp.base_currency_code
3318: BEGIN
3319: select ac.check_id
3320: into l_check_id
3321: from ap_invoice_payments_all aip,
3322: ap_checks_all ac
3323: where aip.check_id=ac.check_id
3324: and aip.accounting_event_id = l_accounting_event_ids(i)
3325: and aip.invoice_id=l_event_source_info.source_id_int_1;
3326:
3768: SET event_status_code = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION
3769: WHERE XEG.application_id = 200
3770: AND XEG.source_id_int_1 IN
3771: ( SELECT AC.check_id
3772: FROM AP_CHECKS_ALL AC
3773: WHERE AC.checkrun_name = p_checkrun_name
3774: and AC.completed_pmts_group_id = p_completed_pmts_group_id
3775: and AC.org_id = p_org_id );
3776:
3958: decode(ac.exchange_rate_type, NULL, XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE,
3959: decode(ac.exchange_rate, NULL, XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE,
3960: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED))))
3961: --bug 8358552 ends
3962: FROM ap_checks_all ac
3963: , ap_system_parameters_all asp
3964: WHERE ac.checkrun_name = p_checkrun_name
3965: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
3966: AND ac.org_id = p_org_id
4059: accounting_event_id,
4060: request_id,
4061: org_id,
4062: related_event_id ) -- Bug 5015973 -- Bug 5658623: Adding hint
4063: ( select /*+ Leading(xeg) index(ac ap_checks_u1) */
4064: ap_payment_history_s.NEXTVAL, -- payment_history_id
4065: ac.check_id, -- check_id
4066: trunc(p_accounting_date), -- accounting_date bug6602676
4067: l_event_type, -- transaction_type
4096: XEG.event_id, -- accounting_event_id
4097: NULL, -- request_id
4098: ac.org_id, -- org_id
4099: XEG.event_id -- related_event_id
4100: from ap_checks_all ac,
4101: xla_events_int_gt xeg
4102: where ac.completed_pmts_group_id = p_completed_pmts_group_id
4103: and ac.org_id = p_org_id
4104: and xeg.source_id_int_1 = ac.check_id);
4107:
4108: SELECT COUNT(*)
4109: INTO l_count
4110: FROM ap_payment_history_all aph,
4111: ap_checks_all ac
4112: WHERE aph.check_id = ac.check_id
4113: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
4114: AND ac.org_id = p_org_id;
4115:
4123:
4124: SELECT accounting_event_id
4125: INTO l_count
4126: FROM ap_payment_history_all aph,
4127: ap_checks_all ac
4128: WHERE aph.check_id = ac.check_id
4129: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
4130: AND ac.org_id = p_org_id
4131: AND rownum = 1;
4333: CURSOR get_payment_info IS
4334: SELECT DISTINCT AC.check_id, /* Added the distinct for bug#8368922 */
4335: AIP.accounting_event_id -- Bug3343314
4336: , AIP.invoice_id /* Added the distinct for bug#8438184 */
4337: FROM ap_checks AC,
4338: ap_invoice_payments AIP -- Bug3343314
4339: WHERE AC.check_id = AIP.check_id -- Bug3343314
4340: AND AC.checkrun_name = p_checkrun_name
4341: AND AC.status_lookup_code NOT IN ('OVERFLOW', 'SET UP')
4582:
4583: SELECT nvl(purch_encumbrance_flag,'N')
4584: INTO l_purch_enc_flag
4585: FROM financials_system_parameters FSP,
4586: AP_CHECKS AC
4587: WHERE AC.org_id = FSP.org_id
4588: AND AC.check_id = p_source_id;
4589: EXCEPTION
4590: WHEN NO_DATA_FOUND THEN
4737:
4738: CURSOR l_event_cur IS
4739: SELECT distinct(AIP.accounting_event_id)
4740: FROM ap_invoice_payments AIP,
4741: ap_checks AC
4742: WHERE AIP.check_id = p_check_id
4743: AND AIP.check_id = AC.check_id
4744: AND nvl(AIP.posted_flag, 'N') = 'N'
4745: AND AC.void_date IS NULL;
4901: l_exchange_rate,
4902: l_currency_code,
4903: l_creation_date,
4904: l_last_updated_by
4905: FROM AP_CHECKS AC
4906: WHERE AC.check_id = P_check_id;
4907:
4908: l_log_msg := 'Before AP_RECONCILIATION_PKG.INSERT_PAYMENT_HISTORY';
4909: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
5212: ac.last_updated_by,
5213: ac.org_id,
5214: ac.payment_type_flag,
5215: asp.automatic_offsets_flag
5216: FROM ap_checks_all ac,
5217: ap_system_parameters_all asp ---7209263 added automatic offsets flag
5218: WHERE ac.check_id = p_check_id
5219: AND ac.org_id=asp.org_id;
5220:
5250: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_CASCADE_EVENTS';
5251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5252:
5253: l_event_type xla_events.event_type_code%TYPE;
5254: l_pay_type ap_checks_all.payment_type_flag%TYPE;
5255: l_automatic_offsets_flag ap_system_parameters_all.automatic_offsets_flag%TYPE; ---7209263
5256: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949
5257:
5258: -- Bug 8276852 Start
5556: l_creation_date,
5557: l_last_updated_by,
5558: l_org_id,
5559: l_automatic_offsets_flag --7209263
5560: FROM AP_CHECKS AC, ap_system_parameters_all asp
5561: WHERE AC.check_id = l_pay_clear_check_ids(i) --bug 7278341 l_pay_check_ids(i)
5562: AND AC.org_id=asp.org_id;
5563: */
5564: --bug 7607184
5642: l_exchange_rate,
5643: l_creation_date,
5644: l_last_updated_by,
5645: l_org_id
5646: FROM AP_CHECKS AC
5647: WHERE AC.check_id = l_pay_check_ids(i);
5648: */
5649:
5650:
5783: l_exchange_rate,
5784: l_creation_date,
5785: l_last_updated_by,
5786: l_org_id
5787: FROM AP_CHECKS AC
5788: WHERE AC.check_id = l_pay_check_ids(i);
5789: */
5790:
5791: l_log_msg := 'Before AP_RECONCILIATION_PKG.INSERT_PAYMENT_HISTORY';
6261: IF (l_event_id_list.count <= 1) THEN
6262:
6263: SELECT check_date
6264: INTO l_accounting_date
6265: FROM ap_checks
6266: WHERE check_id = p_check_id;
6267:
6268: IF (l_accounting_date = p_accounting_date) THEN
6269: -- p_event_type_code is left NULL so that 'PAYMENT CREATED' and
6534: AND ROWNUM = 1
6535: ) ledger_id
6536: FROM
6537: ap_payment_history_all APH,
6538: ap_checks_all AC
6539: WHERE
6540: APH.check_id = AC.check_id
6541: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6542: = p_period_name
6573: AND ROWNUM = 1
6574: ) ledger_id
6575: FROM
6576: ap_payment_history_all APH,
6577: ap_checks_all AC
6578: WHERE
6579: APH.check_id = AC.check_id
6580: AND APH.accounting_date BETWEEN p_from_date AND p_to_date
6581: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
6983: WHERE AIP.check_id = APH.check_id
6984: AND ROWNUM = 1
6985: ) ledger_id
6986: FROM ap_payment_history_all APH,
6987: ap_checks_all AC
6988: WHERE APH.check_id = AC.check_id
6989: AND APH.org_id = AC.org_id
6990: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6991: = p_period_name
7002: WHERE AIP.check_id = APH.check_id
7003: AND ROWNUM = 1
7004: ) ledger_id
7005: FROM ap_payment_history_all APH,
7006: ap_checks_all AC
7007: WHERE APH.check_id = AC.check_id
7008: AND APH.org_id = AC.org_id
7009: AND APH.accounting_date BETWEEN p_from_date AND p_to_date
7010: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
7571: END IF;
7572:
7573: select check_number
7574: into l_check_number
7575: from ap_checks_all --bug6705052
7576: where check_id = p_check_id;
7577:
7578: l_event_source_info.application_id := 200;
7579: l_event_source_info.legal_entity_id := p_legal_entity_id;
7735: ASP.set_of_books_id
7736: INTO p_org_id,
7737: p_legal_entity_id,
7738: p_ledger_id
7739: FROM ap_checks_all AC, --bug6705052
7740: ap_system_parameters_all ASP --bug6705052
7741: WHERE AC.check_id = p_check_id
7742: AND nvl(AC.org_id,-99) = nvl(ASP.org_id,-99);
7743: