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 556: INSERT INTO JAI_PO_REQ_LINES (

552: (p_org_id => v_dest_org_id );
553: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
554:
555: -- Start, cbabu for EnhancementBug# 2427465
556: INSERT INTO JAI_PO_REQ_LINES (
557: requisition_line_id, requisition_header_id, tax_modified_flag,
558: tax_amount, total_amount,
559: creation_date, created_by, last_update_date,
560: last_updated_by, last_update_login

Line 804: UPDATE JAI_PO_REQ_LINES

800: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS' ;Ramananda for removal of SQL LITERALs */
801: v_total_amount := v_line_amount + v_tax_amount;
802:
803: -- cbabu for EnhancementBug# 2427465
804: UPDATE JAI_PO_REQ_LINES
805: SET tax_amount = v_tax_amount,
806: total_amount = v_total_amount
807: WHERE requisition_line_id = v_requisition_line_id;
808: END ARI_T1 ;

Line 1003: FROM JAI_PO_REQ_LINES

999:
1000: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00
1001: CURSOR Chk_localization_entry IS
1002: SELECT COUNT(REQUISITION_LINE_ID)
1003: FROM JAI_PO_REQ_LINES
1004: WHERE REQUISITION_LINE_ID = pr_new.REQUISITION_LINE_ID;
1005: -- End modification
1006:
1007: -- Addition to check tax override flag on 24-apr-01 by RK and GSR

Line 1020: FROM JAI_PO_REQ_LINES

1016:
1017: -- cbabu for EnhancementBug# 2427465
1018: CURSOR c_get_tax_category_id(p_requisition_line_id IN NUMBER) IS
1019: SELECT tax_category_id
1020: FROM JAI_PO_REQ_LINES
1021: WHERE requisition_line_id = p_requisition_line_id;
1022:
1023:
1024: v_quantity NUMBER; -- cbabu for Bug# 3051278

Line 1832: From JAI_PO_REQ_LINES

1828: FROM Mtl_Units_Of_Measure
1829: WHERE Unit_Of_Measure = v_uom;
1830:
1831: CURSOR Fetch_Mod_Flag_Cur IS Select Tax_modified_Flag
1832: From JAI_PO_REQ_LINES
1833: Where Requisition_Line_Id = v_line_id;
1834:
1835: lv_apps_source_code VARCHAR2(20);
1836: /*rchandan for bug#5852041.. start*/ --pramasub FP end

Line 2186: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines

2182: IF pv_action = jai_constants.deleting THEN
2183: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2184: WHERE requisition_line_id = pr_old.requisition_line_id ;
2185:
2186: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2187: WHERE requisition_line_id = pr_old.requisition_line_id;
2188:
2189: RETURN;
2190:

Line 2197: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines

2193: AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2194: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2195: WHERE requisition_line_id = pr_old.requisition_line_id ;
2196:
2197: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2198: WHERE requisition_line_id = pr_old.requisition_line_id;
2199:
2200: RETURN;
2201:

Line 2325: /*UPDATE JAI_PO_REQ_LINES

2321: v_quantity , v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ),
2322: conv_rate, v_creation_date, v_created_by, v_last_update_date,
2323: v_last_updated_by, v_last_update_login, v_src_org_id,p_vat_assessable_value => ln_vat_assess_value ); -- Ravi for VAT
2324:
2325: /*UPDATE JAI_PO_REQ_LINES
2326: SET Last_Update_Date = pr_new.last_update_date,
2327: Last_Updated_By = pr_new.last_updated_by,
2328: Last_Update_Login = pr_new.last_update_login
2329: WHERE Requisition_Line_Id = v_line_id

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

2459: p_conv_rate => 1/conv_rate,
2460: p_po_curr => v_currency,
2461: p_func_curr => v_hdr_curr);
2462:
2463: /*UPDATE JAI_PO_REQ_LINES --pramasub FP commented out 115.10
2464: SET Last_Update_Date = pr_new.last_update_date,
2465: Last_Updated_By = pr_new.last_updated_by,
2466: Last_Update_Login = pr_new.last_update_login
2467: WHERE Requisition_Line_Id = v_line_id

Line 2569: From JAI_PO_REQ_LINES

2565: FROM Mtl_Units_Of_Measure
2566: WHERE Unit_Of_Measure = v_uom;
2567:
2568: CURSOR Fetch_Mod_Flag_Cur IS SELECT Tax_modIFied_Flag
2569: From JAI_PO_REQ_LINES
2570: Where Requisition_Line_Id = v_line_id;
2571: BEGIN
2572: pv_return_code := jai_constants.successful ;
2573: /*------------------------------------------------------------------------------------------

Line 2936: UPDATE JAI_PO_REQ_LINES

2932: v_quantity , v_uom_code, v_vendor_id, NVL( v_currency, v_hdr_curr ),
2933: conv_rate, v_creation_date, v_created_by, v_last_update_date,
2934: v_last_updated_by, v_last_update_login, v_src_org_id, ln_vat_assess_value );
2935:
2936: UPDATE JAI_PO_REQ_LINES
2937: SET Last_Update_Date = pr_new.last_update_date,
2938: Last_Updated_By = pr_new.last_updated_by,
2939: Last_Update_Login = pr_new.last_update_login
2940: WHERE Requisition_Line_Id = v_line_id

Line 2952: UPDATE JAI_PO_REQ_LINES

2948: AND Currency = NVL( v_currency, v_hdr_curr )
2949: AND Tax_Rate is Not Null;
2950: jai_po_tax_pkg.calculate_tax( 'REQUISITION', v_header_id, v_line_id, -999, -999, -999, ' ', v_line_tax_amount, v_assessable_value,
2951: ln_vat_assess_value, NULL, conv_rate );
2952: UPDATE JAI_PO_REQ_LINES
2953: SET Last_Update_Date = pr_new.last_update_date,
2954: Last_Updated_By = pr_new.last_updated_by,
2955: Last_Update_Login = pr_new.last_update_login
2956: WHERE Requisition_Line_Id = v_line_id