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_TAX_PKG dependencies on FND_GLOBAL

Line 3040: p_cre_by => nvl(c_rec.created_by, FND_GLOBAL.USER_ID),

3036: p_price => c_rec.price_override,
3037: p_unit_code => c_rec.uom_code,
3038: p_assessable_value => c_rec.assessable_value,
3039: p_cre_dt => nvl(c_rec.creation_date, SYSDATE),
3040: p_cre_by => nvl(c_rec.created_by, FND_GLOBAL.USER_ID),
3041: p_last_upd_dt => nvl(c_rec.last_update_date, SYSDATE),
3042: p_last_upd_by => nvl(c_rec.last_updated_by, FND_GLOBAL.USER_ID),
3043: p_last_upd_login=> nvl(c_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
3044: );

Line 3042: p_last_upd_by => nvl(c_rec.last_updated_by, FND_GLOBAL.USER_ID),

3038: p_assessable_value => c_rec.assessable_value,
3039: p_cre_dt => nvl(c_rec.creation_date, SYSDATE),
3040: p_cre_by => nvl(c_rec.created_by, FND_GLOBAL.USER_ID),
3041: p_last_upd_dt => nvl(c_rec.last_update_date, SYSDATE),
3042: p_last_upd_by => nvl(c_rec.last_updated_by, FND_GLOBAL.USER_ID),
3043: p_last_upd_login=> nvl(c_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
3044: );
3045:
3046: -- check whether called procedure returned any error

Line 3043: p_last_upd_login=> nvl(c_rec.last_update_login, FND_GLOBAL.LOGIN_ID)

3039: p_cre_dt => nvl(c_rec.creation_date, SYSDATE),
3040: p_cre_by => nvl(c_rec.created_by, FND_GLOBAL.USER_ID),
3041: p_last_upd_dt => nvl(c_rec.last_update_date, SYSDATE),
3042: p_last_upd_by => nvl(c_rec.last_updated_by, FND_GLOBAL.USER_ID),
3043: p_last_upd_login=> nvl(c_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
3044: );
3045:
3046: -- check whether called procedure returned any error
3047: IF ( v_errbuf IS NOT NULL) THEN

Line 6324: last_updated_by = fnd_global.user_id,

6320: UPDATE JAI_PO_REQ_LINE_TAXES
6321: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
6322: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6323: last_update_date = sysdate,
6324: last_updated_by = fnd_global.user_id,
6325: last_update_login = fnd_global.login_id
6326: WHERE Requisition_Header_Id = p_header_id
6327: AND Requisition_Line_Id = p_line_id
6328: AND Tax_Line_No = I;

Line 6325: last_update_login = fnd_global.login_id

6321: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
6322: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6323: last_update_date = sysdate,
6324: last_updated_by = fnd_global.user_id,
6325: last_update_login = fnd_global.login_id
6326: WHERE Requisition_Header_Id = p_header_id
6327: AND Requisition_Line_Id = p_line_id
6328: AND Tax_Line_No = I;
6329: END LOOP;

Line 6337: last_updated_by = fnd_global.user_id,

6333: UPDATE JAI_PO_REQ_LINES
6334: SET Tax_Amount = v_tax_amt,
6335: total_amount = p_base_value + v_tax_amt,
6336: last_update_date = sysdate,
6337: last_updated_by = fnd_global.user_id,
6338: last_update_login = fnd_global.login_id
6339: WHERE requisition_header_id = p_header_id
6340: AND requisition_line_id = p_line_id;
6341:

Line 6338: last_update_login = fnd_global.login_id

6334: SET Tax_Amount = v_tax_amt,
6335: total_amount = p_base_value + v_tax_amt,
6336: last_update_date = sysdate,
6337: last_updated_by = fnd_global.user_id,
6338: last_update_login = fnd_global.login_id
6339: WHERE requisition_header_id = p_header_id
6340: AND requisition_line_id = p_line_id;
6341:
6342: ELSIF p_type = 'REQUISITION_BLANKET' THEN

Line 6370: last_updated_by = fnd_global.user_id,

6366: UPDATE JAI_PO_REQ_LINE_TAXES
6367: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
6368: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6369: last_update_date = sysdate,
6370: last_updated_by = fnd_global.user_id,
6371: last_update_login = fnd_global.login_id
6372: WHERE Requisition_Line_Id = p_requisition_line_id/*5877782..replaced p_line_id with p_requisition_line_id */
6373: AND Tax_Line_No = I;
6374: END LOOP;

Line 6371: last_update_login = fnd_global.login_id

6367: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
6368: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6369: last_update_date = sysdate,
6370: last_updated_by = fnd_global.user_id,
6371: last_update_login = fnd_global.login_id
6372: WHERE Requisition_Line_Id = p_requisition_line_id/*5877782..replaced p_line_id with p_requisition_line_id */
6373: AND Tax_Line_No = I;
6374: END LOOP;
6375:

Line 6412: last_updated_by = fnd_global.user_id,

6408: UPDATE JAI_PO_TAXES
6409: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
6410: tax_target_amount = nvl( tax_target_tab(i), 0 ),
6411: last_update_date = sysdate,
6412: last_updated_by = fnd_global.user_id,
6413: last_update_login = fnd_global.login_id
6414: WHERE line_location_id = p_line_location_id
6415: AND po_line_id = p_line_id
6416: AND tax_line_no = i;

Line 6413: last_update_login = fnd_global.login_id

6409: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
6410: tax_target_amount = nvl( tax_target_tab(i), 0 ),
6411: last_update_date = sysdate,
6412: last_updated_by = fnd_global.user_id,
6413: last_update_login = fnd_global.login_id
6414: WHERE line_location_id = p_line_location_id
6415: AND po_line_id = p_line_id
6416: AND tax_line_no = i;
6417:

Line 6444: last_updated_by = fnd_global.user_id,

6440: UPDATE JAI_PO_LINE_LOCATIONS
6441: SET Tax_Amount = NVL( v_tax_amt, 0 ),
6442: Total_Amount = v_tax_amt + p_base_value ,
6443: last_update_date = sysdate,
6444: last_updated_by = fnd_global.user_id,
6445: last_update_login = fnd_global.login_id
6446: WHERE Line_Location_Id = p_line_location_id
6447: AND Po_Line_Id = p_line_id;
6448:

Line 6445: last_update_login = fnd_global.login_id

6441: SET Tax_Amount = NVL( v_tax_amt, 0 ),
6442: Total_Amount = v_tax_amt + p_base_value ,
6443: last_update_date = sysdate,
6444: last_updated_by = fnd_global.user_id,
6445: last_update_login = fnd_global.login_id
6446: WHERE Line_Location_Id = p_line_location_id
6447: AND Po_Line_Id = p_line_id;
6448:
6449: ELSIF p_type in ( 'ASBN' ) THEN /*rchandan for 5961325*/

Line 6483: last_updated_by = fnd_global.user_id,

6479:
6480: UPDATE jai_cmn_document_taxes
6481: SET Tax_Amt = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
6482: last_update_date = sysdate,
6483: last_updated_by = fnd_global.user_id,
6484: last_update_login = fnd_global.login_id
6485: WHERE source_doc_id = p_header_id
6486: AND source_doc_Line_Id = p_line_id
6487: AND Tax_Line_No = I;

Line 6484: last_update_login = fnd_global.login_id

6480: UPDATE jai_cmn_document_taxes
6481: SET Tax_Amt = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
6482: last_update_date = sysdate,
6483: last_updated_by = fnd_global.user_id,
6484: last_update_login = fnd_global.login_id
6485: WHERE source_doc_id = p_header_id
6486: AND source_doc_Line_Id = p_line_id
6487: AND Tax_Line_No = I;
6488:

Line 8762: Last_Updated_By = fnd_global.user_id,

8758:
8759: UPDATE Jai_Po_Line_Locations
8760: SET Tax_Amount = NULL,
8761: Total_Amount = NULL,
8762: Last_Updated_By = fnd_global.user_id,
8763: Last_Update_Date = sysdate,
8764: Last_Update_Login = fnd_global.login_id
8765: WHERE Po_Line_Id = v_po_line_id
8766: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */

Line 8764: Last_Update_Login = fnd_global.login_id

8760: SET Tax_Amount = NULL,
8761: Total_Amount = NULL,
8762: Last_Updated_By = fnd_global.user_id,
8763: Last_Update_Date = sysdate,
8764: Last_Update_Login = fnd_global.login_id
8765: WHERE Po_Line_Id = v_po_line_id
8766: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */
8767:
8768: v_tax_ctg_id := p_tax_category_id;