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_PO_REQ_LINE_TAXES

Line 495: FROM JAI_PO_REQ_LINE_TAXES

491: ORDER BY tax_line_no;
492:
493: CURSOR c_manual_reqn_taxes_up(p_requisition_line_id IN NUMBER) IS
494: SELECT rowid, tax_line_no
495: FROM JAI_PO_REQ_LINE_TAXES
496: WHERE requisition_line_id = p_requisition_line_id
497: AND tax_category_id IS NULL
498: ORDER BY tax_line_no;
499:

Line 3114: insert into JAI_PO_REQ_LINE_TAXES

3110: -- The adhoc data is preserved to capture the tax_amount later.
3111: -- added by Harshita for Bug #3765133
3112:
3113:
3114: insert into JAI_PO_REQ_LINE_TAXES
3115: (requisition_line_id,tax_line_no,
3116: tax_id, tax_amount,
3117: creation_date,created_by,
3118: last_update_date, last_updated_by,last_update_login)

Line 3125: JAI_PO_REQ_LINE_TAXES A,

3121: A.tax_id, A.tax_amount,
3122: A.creation_date,A.created_by,
3123: A.last_update_date, A.last_updated_by,A.last_update_login
3124: FROM
3125: JAI_PO_REQ_LINE_TAXES A,
3126: JAI_CMN_TAXES_ALL B
3127: WHERE
3128: A.tax_id = B.tax_id AND
3129: requisition_line_id = reqn_rec.requisition_line_id AND

Line 3135: DELETE FROM JAI_PO_REQ_LINE_TAXES

3131:
3132: -- end, Harshita for Bug #3765133
3133:
3134: IF p_override_manual_taxes = 'Y' THEN
3135: DELETE FROM JAI_PO_REQ_LINE_TAXES
3136: WHERE requisition_line_id = reqn_rec.requisition_line_id;
3137:
3138: 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
3139: ELSE

Line 3200: INSERT INTO JAI_PO_REQ_LINE_TAXES(

3196: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9
3197: ||', tax_rec.p_10 -> '||tax_rec.p_10 );
3198: END IF;
3199:
3200: INSERT INTO JAI_PO_REQ_LINE_TAXES(
3201: requisition_line_id, requisition_header_id, tax_line_no,
3202: precedence_1,
3203: precedence_2,
3204: precedence_3,

Line 3234: JAI_PO_REQ_LINE_TAXES a

3230: /* Harshita - Update the tax_amount in the latest records
3231: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
3232:
3233: UPDATE
3234: JAI_PO_REQ_LINE_TAXES a
3235: SET
3236: tax_amount = (SELECT tax_amount
3237: FROM JAI_PO_REQ_LINE_TAXES
3238: where tax_id = a.tax_id

Line 3237: FROM JAI_PO_REQ_LINE_TAXES

3233: UPDATE
3234: JAI_PO_REQ_LINE_TAXES a
3235: SET
3236: tax_amount = (SELECT tax_amount
3237: FROM JAI_PO_REQ_LINE_TAXES
3238: where tax_id = a.tax_id
3239: and requisition_line_id = -reqn_rec.requisition_line_id)
3240: WHERE
3241: requisition_line_id = reqn_rec.requisition_line_id

Line 3243: FROM JAI_PO_REQ_LINE_TAXES

3239: and requisition_line_id = -reqn_rec.requisition_line_id)
3240: WHERE
3241: requisition_line_id = reqn_rec.requisition_line_id
3242: and tax_id in (SELECT tax_id
3243: FROM JAI_PO_REQ_LINE_TAXES
3244: WHERE requisition_line_id = -reqn_rec.requisition_line_id);
3245:
3246: -- ended, Harshita for Bug #3765133
3247:

Line 3255: UPDATE JAI_PO_REQ_LINE_TAXES SET tax_line_no = j

3251: IF p_override_manual_taxes <> 'Y' THEN
3252: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *
3253: FOR tax_rec IN c_manual_reqn_taxes_up(reqn_rec.requisition_line_id) LOOP
3254: j := j + 1;
3255: UPDATE JAI_PO_REQ_LINE_TAXES SET tax_line_no = j
3256: WHERE rowid = tax_rec.rowid;
3257: END LOOP;
3258: END IF;
3259:

Line 3376: DELETE FROM JAI_PO_REQ_LINE_TAXES

3372: END IF;
3373:
3374: -- added, Harshita for Bug #3765133
3375: /* Temporary data stored previously will be flushed using following DELETE */
3376: DELETE FROM JAI_PO_REQ_LINE_TAXES
3377: WHERE requisition_line_id = -reqn_rec.requisition_line_id;
3378: -- ended, Harshita for Bug #3765133
3379:
3380: ELSE

Line 3760: FROM JAI_PO_REQ_LINE_TAXES

3756: and line_id = -so_rec.line_id)
3757: WHERE
3758: line_id = so_rec.line_id
3759: and tax_id in (SELECT tax_id
3760: FROM JAI_PO_REQ_LINE_TAXES
3761: WHERE line_id = -so_rec.line_id);
3762:
3763:
3764: -- ended, Harshita for Bug #3765133

Line 4840: FROM JAI_PO_REQ_LINE_TAXES

4836: nvl(precedence_8, -1) p_8,
4837: nvl(precedence_9, -1) p_9,
4838: nvl(precedence_10, -1) p_10,
4839: tax_id, tax_category_id
4840: FROM JAI_PO_REQ_LINE_TAXES
4841: WHERE requisition_line_id = p_requisition_line_id;
4842:
4843: j NUMBER(4) := 0;
4844: v_manual VARCHAR2(1); -- := 'N'; --Ramananda for File.Sql.35

Line 5130: DELETE FROM JAI_PO_REQ_LINE_TAXES

5126:
5127: -------------------------------------------------
5128: --Added by zhiwei for BOE ER bug 11684111 end
5129: ELSIF p_document_type = 'REQUISITION' THEN
5130: DELETE FROM JAI_PO_REQ_LINE_TAXES
5131: WHERE requisition_line_id = p_line_id AND tax_category_id IS NOT NULL;
5132: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';
5133: END IF;
5134:

Line 5168: DELETE FROM JAI_PO_REQ_LINE_TAXES

5164:
5165: --------------------------------------------------------
5166: --Added by zhiwei for BOE ER bug 11684111 end
5167: ELSIF p_document_type = 'REQUISITION' THEN
5168: DELETE FROM JAI_PO_REQ_LINE_TAXES
5169: WHERE requisition_line_id = p_line_id
5170: AND tax_category_id IS NOT NULL;
5171:
5172: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';