DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_BOE_DETAIL_TAXES_S

Line 4294: -A.boe_detail_id,jai_boe_detail_taxes_s.NEXTVAL,A.tax_line_no,

4290: tax_id, tax_amount,
4291: creation_date,created_by,
4292: last_update_date, last_updated_by,last_update_login)
4293: SELECT
4294: -A.boe_detail_id,jai_boe_detail_taxes_s.NEXTVAL,A.tax_line_no,
4295: A.tax_id, A.tax_amount,
4296: A.creation_date,A.created_by,
4297: A.last_update_date, A.last_updated_by,A.last_update_login
4298: FROM

Line 4374: j, jai_boe_detail_taxes_s.NEXTVAL, boe_rec.boe_detail_id,

4370: last_update_login, tax_category_id
4371: ,tax_type,inclusive_tax_flag
4372: ,boe_flag
4373: ) VALUES (
4374: j, jai_boe_detail_taxes_s.NEXTVAL, boe_rec.boe_detail_id,
4375: tax_rec.p_1, tax_rec.p_2, tax_rec.p_3, tax_rec.p_4, tax_rec.p_5,
4376: tax_rec.p_6, tax_rec.p_7, tax_rec.p_8, tax_rec.p_9, tax_rec.p_10,
4377: tax_rec.tax_id, tax_rec.tax_rate, tax_rec.tax_amount, tax_rec.uom_code,
4378: 0, null, null,

Line 4412: UPDATE JAI_BOE_DETAIL_TAXES SET tax_line_no = j

4408: IF p_override_manual_taxes <> 'Y' THEN
4409: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *
4410: FOR tax_rec IN c_manual_boe_taxes_up(boe_rec.boe_detail_id) LOOP
4411: j := j + 1;
4412: UPDATE JAI_BOE_DETAIL_TAXES SET tax_line_no = j
4413: WHERE rowid = tax_rec.rowid;
4414: END LOOP;
4415: END IF;
4416: