APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_CONSTANTS

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

550: has been applied.
551:
552:
553: ------------------------------------------------------------------------------------------------------- */
554: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
555:
556: if v_debug = 'Y' then
557: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
558: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');

Line 930: if lv_recoverable_flag = jai_constants.YES then

926: --
927: 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);
928: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
929: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
930: if lv_recoverable_flag = jai_constants.YES then
931: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);
932: elsif lv_recoverable_flag = jai_constants.NO then
933: v_tax_target_amount := v_tax_target_amount * (1 - (v_mod_cr_pctg/100));
934: end if;

Line 932: elsif lv_recoverable_flag = jai_constants.NO then

928: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
929: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
930: if lv_recoverable_flag = jai_constants.YES then
931: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);
932: elsif lv_recoverable_flag = jai_constants.NO then
933: v_tax_target_amount := v_tax_target_amount * (1 - (v_mod_cr_pctg/100));
934: end if;
935:
936: end if;

Line 1366: 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*/

1362: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1363: JAI_CMN_TAXES_ALL jtc
1364: WHERE jtc.tax_id = jsptl.tax_id
1365: AND jsptl.delivery_detail_id = jspl.delivery_detail_id
1366: 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*/
1367: AND jtc.stform_type IS NOT NULL
1368: )
1369: AND NOT EXISTS
1370: (SELECT 1

Line 1413: 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*/

1409: from JAI_OM_WSH_LINES_ALL
1410: where delivery_id = p_delivery_id
1411: )
1412: and jtc.tax_id = jsptl.tax_id
1413: 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*/
1414: and jtc.stform_type is not null;
1415:
1416: v_hdr_record_exists number;
1417: v_st_hdr_id number;

Line 1828: 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*/

1824: (SELECT 1
1825: FROM JAI_AR_TRX_TAX_LINES tax_lines ,
1826: JAI_CMN_TAXES_ALL jtc
1827: WHERE link_to_cust_trx_line_id = trx_lines.customer_trx_line_id AND
1828: 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*/
1829: AND jtc.tax_id = tax_lines.tax_id AND
1830: jtc.stform_type IS NOT NULL
1831: )
1832: and trx.complete_flag ='Y'

Line 1868: 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*/

1864: from JAI_AR_TRX_LINES
1865: where customer_trx_id = p_invoice_id
1866: )
1867: and jtc.tax_id = jtxn.tax_id
1868: 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*/
1869: and jtc.stform_type is not null;
1870:
1871: cursor c_orgn_locn (p_invoice_id number)
1872: is