APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_CONSTANTS

Line 444: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35

440: has been applied.
441:
442:
443: ------------------------------------------------------------------------------------------------------- */
444: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
445:
446: if v_debug = 'Y' then
447: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
448: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');

Line 790: if lv_recoverable_flag = jai_constants.YES then

786: --
787: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_target_amount='||v_tax_target_amount||',v_mod_cr_pctg='||v_mod_cr_pctg||',lv_recoverable_flag='||lv_recoverable_flag);
788: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
789: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
790: if lv_recoverable_flag = jai_constants.YES then
791: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);
792: elsif lv_recoverable_flag = jai_constants.NO then
793: v_tax_target_amount := v_tax_target_amount * (1 - (v_mod_cr_pctg/100));
794: end if;

Line 792: elsif lv_recoverable_flag = jai_constants.NO then

788: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
789: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
790: if lv_recoverable_flag = jai_constants.YES then
791: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);
792: elsif lv_recoverable_flag = jai_constants.NO then
793: v_tax_target_amount := v_tax_target_amount * (1 - (v_mod_cr_pctg/100));
794: end if;
795:
796: end if;

Line 1226: AND jtc.tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

1222: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1223: JAI_CMN_TAXES_ALL jtc
1224: WHERE jtc.tax_id = jsptl.tax_id
1225: AND jsptl.delivery_detail_id = jspl.delivery_detail_id
1226: AND jtc.tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1227: AND jtc.stform_type IS NOT NULL
1228: )
1229: AND NOT EXISTS
1230: (SELECT 1

Line 1272: and jtc.tax_type in ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

1268: from JAI_OM_WSH_LINES_ALL
1269: where delivery_id = p_delivery_id
1270: )
1271: and jtc.tax_id = jsptl.tax_id
1272: and jtc.tax_type in ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1273: and jtc.stform_type is not null;
1274:
1275: v_hdr_record_exists number;
1276: v_st_hdr_id number;

Line 1681: tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

1677: (SELECT 1
1678: FROM JAI_AR_TRX_TAX_LINES tax_lines ,
1679: JAI_CMN_TAXES_ALL jtc
1680: WHERE link_to_cust_trx_line_id = trx_lines.customer_trx_line_id AND
1681: tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1682: AND jtc.tax_id = tax_lines.tax_id AND
1683: jtc.stform_type IS NOT NULL
1684: )
1685: and trx.complete_flag ='Y'

Line 1721: and jtc.tax_type in ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

1717: from JAI_AR_TRX_LINES
1718: where customer_trx_id = p_invoice_id
1719: )
1720: and jtc.tax_id = jtxn.tax_id
1721: and jtc.tax_type in ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1722: and jtc.stform_type is not null;
1723:
1724: cursor c_orgn_locn (p_invoice_id number)
1725: is