eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_BOE_DETAIL_TAXES

Line 412: jai_boe_detail_taxes ttax,

408:
409: cursor get_tax_rec(cn_boe_detail_id number)
410: is
411: select ttax.tax_id,ttype.tax_type from
412: jai_boe_detail_taxes ttax,
413: jai_cmn_taxes_all ttype
414: where ttax.boe_detail_id = cn_boe_detail_id
415: and ttax.tax_id = ttype.tax_id;
416:

Line 427: from jai_boe_detail_taxes ttax,

423: ttax.tax_id,
424: ttax.tax_amount,
425: ttype.tax_type,
426: ttax.boe_flag
427: from jai_boe_detail_taxes ttax,
428: jai_cmn_taxes_all ttype
429:
430: where ttax.boe_detail_id = cn_boe_detail_id
431: --and ttax.boe_flag = 'Y'

Line 887: FROM JAI_BOE_DETAIL_TAXES

883: ORDER BY head.boe_id, detail.boe_detail_id;
884:
885: CURSOR c_manual_boe_taxes_up(p_line_id IN NUMBER) IS
886: SELECT rowid, tax_line_no
887: FROM JAI_BOE_DETAIL_TAXES
888: WHERE boe_detail_id = p_line_id
889: AND tax_category_id IS NULL
890: ORDER BY tax_line_no;
891:

Line 4288: insert into JAI_BOE_DETAIL_TAXES

4284:
4285:
4286:
4287:
4288: insert into JAI_BOE_DETAIL_TAXES
4289: (boe_detail_id,BOE_DETAIL_TAX_ID,tax_line_no,
4290: tax_id, tax_amount,
4291: creation_date,created_by,
4292: last_update_date, last_updated_by,last_update_login)

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 4299: JAI_BOE_DETAIL_TAXES A,

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
4299: JAI_BOE_DETAIL_TAXES A,
4300: JAI_CMN_TAXES_ALL B
4301: WHERE
4302: A.tax_id = B.tax_id AND
4303: boe_detail_id = boe_rec.boe_detail_id AND

Line 4308: DELETE FROM JAI_BOE_DETAIL_TAXES

4304: NVL(adhoc_flag,'N') = 'Y';
4305: --Updated by Wenqiong for add BOE_DETAIL_TAX_ID in insert clause.
4306:
4307: IF p_override_manual_taxes = 'Y' THEN
4308: DELETE FROM JAI_BOE_DETAIL_TAXES
4309: WHERE boe_detail_id = boe_rec.boe_detail_id;
4310:
4311: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
4312: ELSE

Line 4355: INSERT INTO JAI_BOE_DETAIL_TAXES(

4351:
4352: lv_boe_flag := 'Y';
4353: end if;
4354:
4355: INSERT INTO JAI_BOE_DETAIL_TAXES(
4356: tax_line_no, boe_detail_tax_id, boe_detail_id,
4357: precedence_1,
4358: precedence_2,
4359: precedence_3,

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 4390: jai_boe_detail_taxes a

4386: END LOOP;
4387:
4388:
4389: update
4390: jai_boe_detail_taxes a
4391: set tax_amount = (
4392: select tax_amount
4393: from jai_boe_detail_taxes
4394: where tax_id = a.tax_id

Line 4393: from jai_boe_detail_taxes

4389: update
4390: jai_boe_detail_taxes a
4391: set tax_amount = (
4392: select tax_amount
4393: from jai_boe_detail_taxes
4394: where tax_id = a.tax_id
4395: and boe_detail_id = -boe_rec.boe_detail_id
4396: )
4397: where boe_detail_id = boe_rec.boe_detail_id

Line 4400: from jai_boe_detail_taxes

4396: )
4397: where boe_detail_id = boe_rec.boe_detail_id
4398: and tax_id in (
4399: select tax_id
4400: from jai_boe_detail_taxes
4401: where boe_detail_id = -boe_rec.boe_detail_id
4402: );
4403:
4404:

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:

Line 4473: DELETE FROM jai_boe_detail_taxes

4469: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||
4470: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
4471: END IF;
4472:
4473: DELETE FROM jai_boe_detail_taxes
4474: WHERE boe_detail_id = -boe_rec.boe_detail_id;
4475:
4476: select sum(tax_amount)
4477: into ln_boe_amount

Line 4478: from JAI_BOE_DETAIL_TAXES

4474: WHERE boe_detail_id = -boe_rec.boe_detail_id;
4475:
4476: select sum(tax_amount)
4477: into ln_boe_amount
4478: from JAI_BOE_DETAIL_TAXES
4479: where NVL(BOE_FLAG,'N')='Y'
4480: and BOE_DETAIL_ID = boe_rec.boe_detail_id;
4481:
4482:

Line 4493: FROM JAI_BOE_DETAIL_TAXES

4489: where rowid = boe_rec.rowid;
4490:
4491: SELECT SUM(TAX_AMOUNT)
4492: into ln_boe_amount
4493: FROM JAI_BOE_DETAIL_TAXES
4494: WHERE 1=1
4495: AND NVL(BOE_FLAG,'N')='Y'
4496: AND BOE_DETAIL_ID
4497: IN

Line 4586: DELETE FROM jai_boe_detail_taxes

4582: ', Message -> '||v_message
4583: );
4584: END IF;
4585:
4586: DELETE FROM jai_boe_detail_taxes
4587: WHERE boe_detail_id = -boe_rec.boe_detail_id;
4588: END IF;
4589:
4590:

Line 4822: FROM JAI_BOE_DETAIL_TAXES

4818: nvl(precedence_9, -1) p_9,
4819: nvl(precedence_10, -1) p_10,
4820: tax_id,
4821: tax_category_id
4822: FROM JAI_BOE_DETAIL_TAXES
4823: WHERE boe_detail_id = p_line_id;
4824:
4825: ---------------------------------------------
4826: --Added by zhiwei for BOE ER bug 11684111 end

Line 5123: DELETE FROM JAI_BOE_DETAIL_TAXES

5119: -------------------------------------------------
5120: ELSIF p_document_type = 'BOE' THEN
5121:
5122:
5123: DELETE FROM JAI_BOE_DETAIL_TAXES
5124: WHERE boe_detail_id = p_line_id AND tax_category_id IS NOT NULL;
5125: p_message := 'No Manual taxes are attached to the BOE line, so no problem is deleting the line taxes';
5126:
5127: -------------------------------------------------

Line 5159: DELETE FROM JAI_BOE_DETAIL_TAXES

5155: --Added by zhiwei for BOE ER bug 11684111 begin
5156: --------------------------------------------------------
5157: ELSIF p_document_type = 'BOE' THEN
5158:
5159: DELETE FROM JAI_BOE_DETAIL_TAXES
5160: WHERE boe_detail_id = p_line_id
5161: AND tax_category_id IS NOT NULL;
5162:
5163: p_message := 'No Manual taxes are attached to the BOE line, so no problem is deleting the line taxes';