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_PO_RLA_TRIGGER_PKG dependencies on JAI_PO_REQ_LINES

Line 572: INSERT INTO JAI_PO_REQ_LINES (

568: (p_org_id => v_dest_org_id );
569: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
570:
571: -- Start, cbabu for EnhancementBug# 2427465
572: INSERT INTO JAI_PO_REQ_LINES (
573: requisition_line_id, requisition_header_id, tax_modified_flag,
574: tax_amount, total_amount,
575: creation_date, created_by, last_update_date,
576: last_updated_by, last_update_login

Line 890: UPDATE JAI_PO_REQ_LINES

886: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS' ;Ramananda for removal of SQL LITERALs */
887: v_total_amount := v_line_amount + v_tax_amount;
888:
889: -- cbabu for EnhancementBug# 2427465
890: UPDATE JAI_PO_REQ_LINES
891: SET tax_amount = v_tax_amount,
892: total_amount = v_total_amount
893: WHERE requisition_line_id = v_requisition_line_id;
894: END ARI_T1 ;

Line 1090: FROM JAI_PO_REQ_LINES

1086:
1087: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00
1088: CURSOR Chk_localization_entry IS
1089: SELECT COUNT(REQUISITION_LINE_ID)
1090: FROM JAI_PO_REQ_LINES
1091: WHERE REQUISITION_LINE_ID = pr_new.REQUISITION_LINE_ID;
1092: -- End modification
1093:
1094: -- Addition to check tax override flag on 24-apr-01 by RK and GSR

Line 1107: FROM JAI_PO_REQ_LINES

1103:
1104: -- cbabu for EnhancementBug# 2427465
1105: CURSOR c_get_tax_category_id(p_requisition_line_id IN NUMBER) IS
1106: SELECT tax_category_id
1107: FROM JAI_PO_REQ_LINES
1108: WHERE requisition_line_id = p_requisition_line_id;
1109:
1110:
1111: v_quantity NUMBER; -- cbabu for Bug# 3051278

Line 1963: From JAI_PO_REQ_LINES

1959: FROM Mtl_Units_Of_Measure
1960: WHERE Unit_Of_Measure = v_uom;
1961:
1962: CURSOR Fetch_Mod_Flag_Cur IS Select Tax_modified_Flag
1963: From JAI_PO_REQ_LINES
1964: Where Requisition_Line_Id = v_line_id;
1965:
1966: lv_apps_source_code VARCHAR2(20);
1967: /*rchandan for bug#5852041.. start*/ --pramasub FP end

Line 2320: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines

2316: IF pv_action = jai_constants.deleting THEN
2317: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2318: WHERE requisition_line_id = pr_old.requisition_line_id ;
2319:
2320: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2321: WHERE requisition_line_id = pr_old.requisition_line_id;
2322:
2323: RETURN;
2324:

Line 2331: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines

2327: AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2328: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2329: WHERE requisition_line_id = pr_old.requisition_line_id ;
2330:
2331: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2332: WHERE requisition_line_id = pr_old.requisition_line_id;
2333:
2334: RETURN;
2335:

Line 2503: /*UPDATE JAI_PO_REQ_LINES

2499: v_last_updated_by, v_last_update_login, v_src_org_id,p_vat_assessable_value => ln_vat_assess_value -- Ravi for VAT
2500: --, pn_gst_assessable_value => ln_gst_assessable_value
2501: ); -- Added by Jia for GST Bug#10091373 on 2010/09/10
2502:
2503: /*UPDATE JAI_PO_REQ_LINES
2504: SET Last_Update_Date = pr_new.last_update_date,
2505: Last_Updated_By = pr_new.last_updated_by,
2506: Last_Update_Login = pr_new.last_update_login
2507: WHERE Requisition_Line_Id = v_line_id

Line 2683: /*UPDATE JAI_PO_REQ_LINES --pramasub FP commented out 115.10

2679: p_func_curr => v_hdr_curr
2680: -- , pn_gst_assessable_value => ln_gst_assessable_value
2681: ); -- Added by Jia for GST Bug#10091373 on 2010/09/10
2682:
2683: /*UPDATE JAI_PO_REQ_LINES --pramasub FP commented out 115.10
2684: SET Last_Update_Date = pr_new.last_update_date,
2685: Last_Updated_By = pr_new.last_updated_by,
2686: Last_Update_Login = pr_new.last_update_login
2687: WHERE Requisition_Line_Id = v_line_id

Line 2792: From JAI_PO_REQ_LINES

2788: FROM Mtl_Units_Of_Measure
2789: WHERE Unit_Of_Measure = v_uom;
2790:
2791: CURSOR Fetch_Mod_Flag_Cur IS SELECT Tax_modIFied_Flag
2792: From JAI_PO_REQ_LINES
2793: Where Requisition_Line_Id = v_line_id;
2794: BEGIN
2795: pv_return_code := jai_constants.successful ;
2796: /*------------------------------------------------------------------------------------------

Line 3202: UPDATE JAI_PO_REQ_LINES

3198: v_last_updated_by, v_last_update_login, v_src_org_id, ln_vat_assess_value
3199: -- , pn_gst_assessable_value => ln_gst_assessable_value
3200: ); -- Added by Jia for GST Bug#10091373 on 2010/09/10
3201:
3202: UPDATE JAI_PO_REQ_LINES
3203: SET Last_Update_Date = pr_new.last_update_date,
3204: Last_Updated_By = pr_new.last_updated_by,
3205: Last_Update_Login = pr_new.last_update_login
3206: WHERE Requisition_Line_Id = v_line_id

Line 3220: UPDATE JAI_PO_REQ_LINES

3216: jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id, -999, -999, -999, ' ', v_line_tax_amount, v_assessable_value,
3217: ln_vat_assess_value, NULL, conv_rate
3218: -- , pn_gst_assessable_value => ln_gst_assessable_value
3219: ); -- Added by Jia for GST Bug#10091373 on 2010/09/10
3220: UPDATE JAI_PO_REQ_LINES
3221: SET Last_Update_Date = pr_new.last_update_date,
3222: Last_Updated_By = pr_new.last_updated_by,
3223: Last_Update_Login = pr_new.last_update_login
3224: WHERE Requisition_Line_Id = v_line_id