[Home] [Help]
238: WHEN NO_DATA_FOUND THEN
239: /* Bug 4233770/4235243 - no data in gl_dist table. This happens
240: for freight lines coming through invoice API.
241: Clearly, there is no assigned gl_date yet */
242: arp_standard.debug('No rows in ra_cust_trx_line_gl_dist');
243: WHEN OTHERS THEN
244: RAISE;
245: END;
246:
452:
453: l_event_source_info.entity_type_code:= 'TRANSACTIONS';
454: l_security.security_id_int_1 := arp_global.sysparam.org_id;
455: l_event_source_info.application_id := 222;
456: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id;
457: l_event_source_info.source_id_int_1 := p_customer_trx_id;
458:
459: xla_events_pub_pkg.delete_event
460: ( p_event_source_info => l_event_source_info,
1306: l_amount_due_remaining NUMBER;
1307: l_ps_id NUMBER;
1308: l_new_dispute_amount NUMBER;
1309: l_sysdate DATE := SYSDATE;
1310: l_last_update_login NUMBER := arp_standard.profile.last_update_login;
1311: l_user_id NUMBER := arp_standard.profile.user_id;
1312: BEGIN
1313: /*Bug 5129946: Calling arp_dispute_history.DisputeHistory*/
1314: OPEN get_existing_ps(p_customer_trx_id);
1307: l_ps_id NUMBER;
1308: l_new_dispute_amount NUMBER;
1309: l_sysdate DATE := SYSDATE;
1310: l_last_update_login NUMBER := arp_standard.profile.last_update_login;
1311: l_user_id NUMBER := arp_standard.profile.user_id;
1312: BEGIN
1313: /*Bug 5129946: Calling arp_dispute_history.DisputeHistory*/
1314: OPEN get_existing_ps(p_customer_trx_id);
1315: FETCH get_existing_ps INTO
1655: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);
1656:
1657: l_dist_rec.account_set_flag := 'N';
1658:
1659: l_dist_rec.acctd_amount := arp_standard.functional_amount(
1660: p_trx_amount,
1661: pg_base_curr_code,
1662: l_exchange_rate,
1663: pg_base_precision,
2037: p_creation_sign,
2038: p_allow_overapplication_flag,
2039: p_natural_application_flag,
2040: p_cash_receipt_id,
2041: 'STANDARD'
2042: );
2043:
2044: END;
2045: