APPS.JAI_OM_RG_PKG dependencies on JAI_AR_TRX_LINES

Line 903: from JAI_AR_TRX_LINES

899: where delivery_detail_id = p_transaction_hdr_id;
900:
901: cursor c_customer_trx_details is
902: select customer_trx_id
903: from JAI_AR_TRX_LINES
904: where customer_trx_line_id = p_transaction_hdr_id;
905:
906: ln_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
907: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;

Line 907: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;

903: from JAI_AR_TRX_LINES
904: where customer_trx_line_id = p_transaction_hdr_id;
905:
906: ln_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
907: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;
908: ln_Cess_amount number;
909: ln_inv_orgn_id number;
910: ln_header_id number;
911: lv_source_name varchar2(20);

Line 936: p_transaction_hdr_id := customer_trx_line_id from JAI_AR_TRX_LINES table

932: If called from AR invoice completion the values for the parameters are as follows.
933:
934: p_source_name := 'Receivables India'
935: p_category_name := 'RG Register Data Entry'
936: p_transaction_hdr_id := customer_trx_line_id from JAI_AR_TRX_LINES table
937:
938: Based on the customer_trx_line_id , pick up the customer_trx_id , organization id and get the taxes from JAI_AR_TRX_TAX_LINES
939:
940: */

Line 3972: from JAI_AR_TRX_LINES

3968: where delivery_id = p_header_id;
3969:
3970: cursor c_invoice_header_cur(cp_header_id number) is
3971: select customer_trx_id
3972: from JAI_AR_TRX_LINES
3973: where customer_trx_line_id = cp_header_id;
3974:
3975: /*
3976: following two cursors added by ssumaith - bug# 4136981

Line 4010: from JAI_AR_TRX_LINES

4006: JAI_CMN_TAXES_ALL jtc
4007: where jtc.tax_id = jrctl.tax_id
4008: and link_to_cust_trx_line_id in
4009: (select customer_trx_line_id
4010: from JAI_AR_TRX_LINES
4011: where customer_trx_id = cp_customer_trx_id
4012: )
4013: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4014: /*Bug 5989740 bduvarag*/

Line 4022: from JAI_AR_TRX_LINES

4018: JAI_CMN_TAXES_ALL jtc
4019: where jtc.tax_id = jrctl.tax_id
4020: and link_to_cust_trx_line_id in
4021: (select customer_trx_line_id
4022: from JAI_AR_TRX_LINES
4023: where customer_trx_id = cp_customer_trx_id
4024: )
4025: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4026:

Line 4034: from JAI_AR_TRX_LINES

4030: JAI_CMN_TAXES_ALL jtc
4031: where jtc.tax_id = jrctl.tax_id
4032: and link_to_cust_trx_line_id in
4033: (select customer_trx_line_id
4034: from JAI_AR_TRX_LINES
4035: where customer_trx_id = cp_customer_trx_id
4036: )
4037: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4038: /*Bug 5989740 bduvarag*/

Line 4046: from JAI_AR_TRX_LINES

4042: JAI_CMN_TAXES_ALL jtc
4043: where jtc.tax_id = jrctl.tax_id
4044: and link_to_cust_trx_line_id in
4045: (select customer_trx_line_id
4046: from JAI_AR_TRX_LINES
4047: where customer_trx_id = cp_customer_trx_id
4048: )
4049: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4050:

Line 4119: from JAI_AR_TRX_LINES

4115:
4116: for line_rec in
4117: (
4118: select customer_trx_line_id
4119: from JAI_AR_TRX_LINES
4120: where customer_trx_line_id = p_header_id
4121: )
4122: Loop
4123: for cess_rec in

Line 4184: from JAI_AR_TRX_LINES

4180:
4181: for line_rec in
4182: (
4183: select customer_trx_line_id
4184: from JAI_AR_TRX_LINES
4185: where customer_trx_line_id = p_header_id
4186: )
4187: Loop
4188: for cess_rec in