[Home] [Help]
191: PROCEDURE set_flags(p_customer_trx_id IN
192: ra_customer_trx.customer_trx_id%type,
193: p_new_trx_rec IN ra_customer_trx%rowtype,
194: p_new_gl_date IN
195: ra_cust_trx_line_gl_dist.gl_date%type,
196: p_new_open_rec_flag IN
197: ra_cust_trx_types.accounting_affect_flag%type,
198: p_ps_dispute_amount IN
199: ar_payment_schedules.amount_in_dispute%type,
209: p_cust_trx_type_changed_flag OUT NOCOPY boolean)
210: IS
211:
212: l_old_trx_rec ra_customer_trx%rowtype;
213: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
214: l_old_open_rec_flag ra_cust_trx_types.accounting_affect_flag%type;
215: l_old_dispute_amount ar_payment_schedules.amount_in_dispute%type;
216: ld_old_dispute_date DATE;
217:
228: BEGIN
229:
230: select gl_date
231: into l_old_gl_date
232: from ra_cust_trx_line_gl_dist
233: where customer_trx_id = p_customer_trx_id
234: and account_class = 'REC'
235: and latest_rec_flag = 'Y';
236:
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:
392: +===========================================================================*/
393:
394: PROCEDURE header_rerun_aa(p_customer_trx_id IN number,
395: p_gl_date IN
396: ra_cust_trx_line_gl_dist.gl_date%type,
397: p_total_trx_amount IN number,
398: p_status OUT NOCOPY varchar2) IS
399:
400: l_result number;
693: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
694: ) IS
695:
696: l_line_rec ra_customer_trx_lines%rowtype;
697: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
698: BEGIN
699:
700: arp_util.debug('arp_process_header.reverse_revrec_effect()+');
701:
798: p_form_name IN varchar2,
799: p_form_version IN number,
800: p_trx_rec IN ra_customer_trx%rowtype,
801: p_trx_class IN ra_cust_trx_types.type%type,
802: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
803: p_term_in_use_flag IN varchar2,
804: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
805: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
806: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1076: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1078: p_trx_amount IN number,
1079: p_trx_class IN ra_cust_trx_types.type%type,
1080: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1081: p_initial_customer_trx_line_id IN
1082: ra_customer_trx_lines.initial_customer_trx_line_id%type
1083: default null,
1084: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1107: l_exchange_rate ra_customer_trx.exchange_rate%type;
1108: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1109:
1110: l_line_rec ra_customer_trx_lines%rowtype;
1111: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1112:
1113: l_old_trx_rec ra_customer_trx%rowtype;
1114:
1115: l_number_of_pay_scheds NUMBER;
1126:
1127: --BUG#5192414
1128: CURSOR cpost IS
1129: SELECT 'Y'
1130: FROM ra_cust_trx_line_gl_dist
1131: WHERE customer_trx_id = p_customer_trx_id
1132: AND posting_control_id <> -3
1133: AND account_set_flag = 'N';
1134: l_test VARCHAR2(1);
1685: p_event_id => l_event_id,
1686: p_valuation_method => NULL,
1687: p_security_context => l_security);
1688:
1689: update ra_cust_trx_line_gl_dist set event_id=null
1690: WHERE customer_trx_id = p_customer_trx_id
1691: and ACCOUNT_SET_FLAG='N'
1692: and event_id =l_event_id;
1693:
2256: ) IS
2257:
2258: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2259: l_ct_commitment_number ra_customer_trx.trx_number%type;
2260: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2261: l_ctl_commit_cust_trx_line_id
2262: ra_customer_trx_lines.customer_trx_line_id%type;
2263: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2264: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2346: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2347: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2348: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2349: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2350: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2351: l_prev_trx_original number;
2352: l_prev_trx_balance number;
2353: l_rac_prev_bill_to_cust_name hz_parties.party_name%type;
2354: l_rac_prev_bill_to_cust_num hz_cust_accounts.account_number%type;
2461: l_ct_commitment_number,
2462: l_gd_commitment_gl_date,
2463: l_ctl_commitment_inv_item_id
2464: FROM ra_customer_trx ct_commit,
2465: ra_cust_trx_line_gl_dist gd_commit,
2466: ra_customer_trx_lines ctl_commit
2467: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2468: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id
2469: AND ct_commit.customer_trx_id = gd_commit.customer_trx_id
2701: l_ct_prev_post_to_gl_flag, /* Bug-3954193 */
2702: l_al_cm_reason_meaning
2703: FROM ra_customer_trx ct,
2704: ra_customer_trx ct_prev,
2705: ra_cust_trx_line_gl_dist gd_prev,
2706: hz_cust_accounts rac_prev,
2707: hz_parties party,
2708: ra_batch_sources bs_prev,
2709: ra_cust_trx_types ctt_prev,