[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;
416:
417:
418: CURSOR c_ct IS
419: SELECT distinct gld.event_id event_id
420: FROM ra_cust_trx_line_gl_dist gld, ra_customer_trx ra
421: WHERE gld.customer_trx_id = p_customer_trx_id
422: and gld.customer_trx_id = ra.customer_trx_id
423: and ra.invoicing_rule_id is NULL
424: and gld.gl_date <> p_gl_date
750: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
751: ) IS
752:
753: l_line_rec ra_customer_trx_lines%rowtype;
754: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
755: BEGIN
756:
757: arp_util.debug('arp_process_header.reverse_revrec_effect()+');
758:
855: p_form_name IN varchar2,
856: p_form_version IN number,
857: p_trx_rec IN ra_customer_trx%rowtype,
858: p_trx_class IN ra_cust_trx_types.type%type,
859: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
860: p_term_in_use_flag IN varchar2,
861: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
862: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
863: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1133: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1134: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1135: p_trx_amount IN number,
1136: p_trx_class IN ra_cust_trx_types.type%type,
1137: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1138: p_initial_customer_trx_line_id IN
1139: ra_customer_trx_lines.initial_customer_trx_line_id%type
1140: default null,
1141: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1164: l_exchange_rate ra_customer_trx.exchange_rate%type;
1165: l_invoice_currency_code ra_customer_trx.invoice_currency_code%type;
1166:
1167: l_line_rec ra_customer_trx_lines%rowtype;
1168: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1169:
1170: l_old_trx_rec ra_customer_trx%rowtype;
1171:
1172: l_number_of_pay_scheds NUMBER;
1183:
1184: --BUG#5192414
1185: CURSOR cpost IS
1186: SELECT 'Y'
1187: FROM ra_cust_trx_line_gl_dist
1188: WHERE customer_trx_id = p_customer_trx_id
1189: AND posting_control_id <> -3
1190: AND account_set_flag = 'N';
1191: l_test VARCHAR2(1);
1765: p_event_id => l_event_id,
1766: p_valuation_method => NULL,
1767: p_security_context => l_security);
1768:
1769: update ra_cust_trx_line_gl_dist set event_id=null
1770: WHERE customer_trx_id = p_customer_trx_id
1771: and ACCOUNT_SET_FLAG='N'
1772: and event_id =l_event_id;
1773:
2336: ) IS
2337:
2338: l_ct_commitment_trx_date ra_customer_trx.trx_date%type;
2339: l_ct_commitment_number ra_customer_trx.trx_number%type;
2340: l_gd_commitment_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2341: l_ctl_commit_cust_trx_line_id
2342: ra_customer_trx_lines.customer_trx_line_id%type;
2343: l_ctl_commitment_amount ra_customer_trx_lines.extended_amount%type;
2344: l_ctl_commitment_text ra_customer_trx_lines.description%type;
2426: l_ct_prev_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
2427: l_ct_prev_initial_cust_trx_id ra_customer_trx.customer_trx_id%type;
2428: l_ct_prev_primary_salesrep_id ra_customer_trx.primary_salesrep_id%type;
2429: l_ct_prev_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
2430: l_gd_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2431: l_prev_trx_original number;
2432: l_prev_trx_balance number;
2433: l_rac_prev_bill_to_cust_name hz_parties.party_name%type;
2434: l_rac_prev_bill_to_cust_num hz_cust_accounts.account_number%type;
2541: l_ct_commitment_number,
2542: l_gd_commitment_gl_date,
2543: l_ctl_commitment_inv_item_id
2544: FROM ra_customer_trx ct_commit,
2545: ra_cust_trx_line_gl_dist gd_commit,
2546: ra_customer_trx_lines ctl_commit
2547: WHERE ct_commit.customer_trx_id = p_initial_customer_trx_id
2548: AND ct_commit.customer_trx_id = ctl_commit.customer_trx_id
2549: AND ct_commit.customer_trx_id = gd_commit.customer_trx_id
2781: l_ct_prev_post_to_gl_flag, /* Bug-3954193 */
2782: l_al_cm_reason_meaning
2783: FROM ra_customer_trx ct,
2784: ra_customer_trx ct_prev,
2785: ra_cust_trx_line_gl_dist gd_prev,
2786: hz_cust_accounts rac_prev,
2787: hz_parties party,
2788: ra_batch_sources bs_prev,
2789: ra_cust_trx_types ctt_prev,