DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 522: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

518: lv_process_message VARCHAR2(1996);
519: ln_reg_id number;
520:
521: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
522: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
523: )
524: is
525: select count(1)
526: from jai_regime_tax_types_v jrttv

Line 5098: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

5094: lv_process_message VARCHAR2(1996);
5095: ln_reg_id number;
5096: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
5097: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
5098: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
5099: )
5100: is
5101: select count(1)
5102: from jai_regime_tax_types_v jrttv

Line 6229: ( r_new in ra_customer_trx_lines_all%rowtype

6225:
6226:
6227:
6228: procedure import_projects_taxes
6229: ( r_new in ra_customer_trx_lines_all%rowtype
6230: , r_old in ra_customer_trx_lines_all%rowtype
6231: , pv_action in varchar2
6232: , pv_err_msg OUT NOCOPY varchar2
6233: , pv_err_flg OUT NOCOPY varchar2

Line 6230: , r_old in ra_customer_trx_lines_all%rowtype

6226:
6227:
6228: procedure import_projects_taxes
6229: ( r_new in ra_customer_trx_lines_all%rowtype
6230: , r_old in ra_customer_trx_lines_all%rowtype
6231: , pv_action in varchar2
6232: , pv_err_msg OUT NOCOPY varchar2
6233: , pv_err_flg OUT NOCOPY varchar2
6234: )

Line 6320: ln_line_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

6316:
6317: r_jai_pa_draft_inv_line c_jai_pa_draft_inv_line%rowtype;
6318:
6319:
6320: ln_line_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
6321:
6322: ln_project_id pa_draft_invoices_all.project_id%type;
6323: ln_draft_invoice_num pa_draft_invoices_all.draft_invoice_num%type;
6324: ln_line_num pa_draft_invoice_items.line_num%type;