[Home] [Help]
26: parm_customer_category hz_parties.category_code%TYPE;
27: parm_customer_id hz_parties.party_id%TYPE;
28: parm_trx_date_low DATE;
29: parm_trx_date_high DATE;
30: parm_currency ra_customer_trx.invoice_currency_code%TYPE;
31: parm_contact_name fv_ipac_trx_all.cnt_nm%TYPE;
32: parm_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
33: parm_org_id fv_operating_units.org_id%TYPE;
34: parm_contact_ph_no VARCHAR2(17);
63: v_trx_excpt_cat fv_ipac_trx_all.exception_category%TYPE;
64: v_trx_exception fv_ipac_trx_all.exception_category%TYPE;
65: v_bulk_exception fv_ipac_trx_all.bulk_exception%TYPE;
66: v_pay_flag VARCHAR2(1) ;
67: v_invoice_currency ra_customer_trx.invoice_currency_code%TYPE;
68: -- Variables to populate who columns
69: v_created_by NUMBER(15);
70: v_creation_date DATE;
71: v_last_updated_by NUMBER(15);
96: rsu.Cust_Acct_site_ID bill_to_address_id,
97: rct.invoice_currency_code
98: FROM hz_parties hzp,
99: hz_cust_accounts hzca,
100: ra_customer_trx rct,
101: ra_cust_trx_types rtt,
102: HZ_CUST_SITE_USES rsu ,
103: ar_remit_to_addresses_v arem,
104: fv_facts_customers_v ffc
154: fu.user_name,
155: rgld.percent,
156: rgld.account_class,
157: rctl.customer_trx_line_id
158: FROM ra_customer_trx_lines rctl,
159: ra_cust_trx_line_gl_dist rgld,
160: fnd_user fu
161: WHERE rgld.customer_trx_id = p_customer_trx_id
162: AND rgld.customer_trx_id = rctl.customer_trx_id(+)
279: fit.sender_do_sym,
280: fit.sender_alc,
281: rct.comments comments
282: FROM fv_ipac_trx_all fit,
283: ra_customer_trx rct
284: WHERE fit.org_id = v_org_id
285: AND fit.set_of_books_id = v_set_of_books_id
286: AND fit.customer_trx_id = p_cust_trx_id
287: AND fit.customer_trx_id = rct.customer_trx_id
1193: l_valid_flag VARCHAR2(1);
1194: l_ignore_budgetary_flag VARCHAR2(1);
1195: l_drcr_acct Gl_Ussgl_Account_Pairs.dr_account_segment_value%TYPE;
1196: trx_rec fv_ipac_trx_all%ROWTYPE;
1197: v_commitment_id ra_customer_trx_all.initial_customer_trx_id%TYPE;
1198: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
1199: l_module_name VARCHAR2(200) ;
1200: l_bill_to_address_id Number;
1201: BEGIN
1255: trx_rec.contract_no := NULL;
1256: ELSE
1257: SELECT trx_number
1258: INTO trx_rec.contract_no
1259: FROM Ra_Customer_Trx
1260: WHERE customer_trx_id = v_commitment_id;
1261: END IF;
1262: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Processing Transaction:'||trx_rec.trx_number);
1263: SELECT SUM(amount_due_original),
1559: fit.trn_set_id ||
1560: RPAD(NVL(SUBSTR(rct.ct_reference, 1, 8), '' ''), 8, '' '')||
1561: RPAD('' '',2)
1562: FROM fv_ipac_trx fit,
1563: ra_customer_trx rct
1564: WHERE fit.set_of_books_id = :b_set_of_books_id
1565: AND rct.customer_trx_id = fit.customer_trx_id
1566: AND fit.processed_flag = ''N''
1567: AND fit.exclude_flag = ''N''
1874: l_is_line_no:=TRUE;
1875:
1876: SELECT racust.line_number
1877: INTO l_trx_line_no
1878: FROM ra_customer_trx_lines racust,
1879: ar_distributions ardist,
1880: xla_distribution_links xladist
1881: WHERE
1882: xladist.ae_header_id = xla_acnt_rec.ae_header_id