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.

[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on FND_GLOBAL

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

2315: p_price => c_rec.price_override,
2316: p_unit_code => c_rec.uom_code,
2317: p_assessable_value => c_rec.assessable_value,
2318: p_cre_dt => nvl(c_rec.creation_date, SYSDATE),
2319: p_cre_by => nvl(c_rec.created_by, FND_GLOBAL.USER_ID),
2320: p_last_upd_dt => nvl(c_rec.last_update_date, SYSDATE),
2321: p_last_upd_by => nvl(c_rec.last_updated_by, FND_GLOBAL.USER_ID),
2322: p_last_upd_login=> nvl(c_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
2323: );

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

2317: p_assessable_value => c_rec.assessable_value,
2318: p_cre_dt => nvl(c_rec.creation_date, SYSDATE),
2319: p_cre_by => nvl(c_rec.created_by, FND_GLOBAL.USER_ID),
2320: p_last_upd_dt => nvl(c_rec.last_update_date, SYSDATE),
2321: p_last_upd_by => nvl(c_rec.last_updated_by, FND_GLOBAL.USER_ID),
2322: p_last_upd_login=> nvl(c_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
2323: );
2324:
2325: -- check whether called procedure returned any error

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

2318: p_cre_dt => nvl(c_rec.creation_date, SYSDATE),
2319: p_cre_by => nvl(c_rec.created_by, FND_GLOBAL.USER_ID),
2320: p_last_upd_dt => nvl(c_rec.last_update_date, SYSDATE),
2321: p_last_upd_by => nvl(c_rec.last_updated_by, FND_GLOBAL.USER_ID),
2322: p_last_upd_login=> nvl(c_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
2323: );
2324:
2325: -- check whether called procedure returned any error
2326: IF ( v_errbuf IS NOT NULL) THEN

Line 4935: last_updated_by = fnd_global.user_id,

4931: UPDATE JAI_PO_REQ_LINE_TAXES
4932: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
4933: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4934: last_update_date = sysdate,
4935: last_updated_by = fnd_global.user_id,
4936: last_update_login = fnd_global.login_id
4937: WHERE Requisition_Header_Id = p_header_id
4938: AND Requisition_Line_Id = p_line_id
4939: AND Tax_Line_No = I;

Line 4936: last_update_login = fnd_global.login_id

4932: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
4933: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4934: last_update_date = sysdate,
4935: last_updated_by = fnd_global.user_id,
4936: last_update_login = fnd_global.login_id
4937: WHERE Requisition_Header_Id = p_header_id
4938: AND Requisition_Line_Id = p_line_id
4939: AND Tax_Line_No = I;
4940: END LOOP;

Line 4948: last_updated_by = fnd_global.user_id,

4944: UPDATE JAI_PO_REQ_LINES
4945: SET Tax_Amount = v_tax_amt,
4946: total_amount = p_base_value + v_tax_amt,
4947: last_update_date = sysdate,
4948: last_updated_by = fnd_global.user_id,
4949: last_update_login = fnd_global.login_id
4950: WHERE requisition_header_id = p_header_id
4951: AND requisition_line_id = p_line_id;
4952:

Line 4949: last_update_login = fnd_global.login_id

4945: SET Tax_Amount = v_tax_amt,
4946: total_amount = p_base_value + v_tax_amt,
4947: last_update_date = sysdate,
4948: last_updated_by = fnd_global.user_id,
4949: last_update_login = fnd_global.login_id
4950: WHERE requisition_header_id = p_header_id
4951: AND requisition_line_id = p_line_id;
4952:
4953: ELSIF p_type = 'REQUISITION_BLANKET' THEN

Line 4981: last_updated_by = fnd_global.user_id,

4977: UPDATE JAI_PO_REQ_LINE_TAXES
4978: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
4979: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4980: last_update_date = sysdate,
4981: last_updated_by = fnd_global.user_id,
4982: last_update_login = fnd_global.login_id
4983: WHERE Requisition_Line_Id = p_requisition_line_id/*5877782..replaced p_line_id with p_requisition_line_id */
4984: AND Tax_Line_No = I;
4985: END LOOP;

Line 4982: last_update_login = fnd_global.login_id

4978: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
4979: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4980: last_update_date = sysdate,
4981: last_updated_by = fnd_global.user_id,
4982: last_update_login = fnd_global.login_id
4983: WHERE Requisition_Line_Id = p_requisition_line_id/*5877782..replaced p_line_id with p_requisition_line_id */
4984: AND Tax_Line_No = I;
4985: END LOOP;
4986:

Line 5023: last_updated_by = fnd_global.user_id,

5019: UPDATE JAI_PO_TAXES
5020: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
5021: tax_target_amount = nvl( tax_target_tab(i), 0 ),
5022: last_update_date = sysdate,
5023: last_updated_by = fnd_global.user_id,
5024: last_update_login = fnd_global.login_id
5025: WHERE line_location_id = p_line_location_id
5026: AND po_line_id = p_line_id
5027: AND tax_line_no = i;

Line 5024: last_update_login = fnd_global.login_id

5020: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
5021: tax_target_amount = nvl( tax_target_tab(i), 0 ),
5022: last_update_date = sysdate,
5023: last_updated_by = fnd_global.user_id,
5024: last_update_login = fnd_global.login_id
5025: WHERE line_location_id = p_line_location_id
5026: AND po_line_id = p_line_id
5027: AND tax_line_no = i;
5028:

Line 5055: last_updated_by = fnd_global.user_id,

5051: UPDATE JAI_PO_LINE_LOCATIONS
5052: SET Tax_Amount = NVL( v_tax_amt, 0 ),
5053: Total_Amount = v_tax_amt + p_base_value ,
5054: last_update_date = sysdate,
5055: last_updated_by = fnd_global.user_id,
5056: last_update_login = fnd_global.login_id
5057: WHERE Line_Location_Id = p_line_location_id
5058: AND Po_Line_Id = p_line_id;
5059:

Line 5056: last_update_login = fnd_global.login_id

5052: SET Tax_Amount = NVL( v_tax_amt, 0 ),
5053: Total_Amount = v_tax_amt + p_base_value ,
5054: last_update_date = sysdate,
5055: last_updated_by = fnd_global.user_id,
5056: last_update_login = fnd_global.login_id
5057: WHERE Line_Location_Id = p_line_location_id
5058: AND Po_Line_Id = p_line_id;
5059:
5060: ELSIF p_type in ( 'ASBN' ) THEN /*rchandan for 5961325*/

Line 5094: last_updated_by = fnd_global.user_id,

5090:
5091: UPDATE jai_cmn_document_taxes
5092: SET Tax_Amt = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
5093: last_update_date = sysdate,
5094: last_updated_by = fnd_global.user_id,
5095: last_update_login = fnd_global.login_id
5096: WHERE source_doc_id = p_header_id
5097: AND source_doc_Line_Id = p_line_id
5098: AND Tax_Line_No = I;

Line 5095: last_update_login = fnd_global.login_id

5091: UPDATE jai_cmn_document_taxes
5092: SET Tax_Amt = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
5093: last_update_date = sysdate,
5094: last_updated_by = fnd_global.user_id,
5095: last_update_login = fnd_global.login_id
5096: WHERE source_doc_id = p_header_id
5097: AND source_doc_Line_Id = p_line_id
5098: AND Tax_Line_No = I;
5099:

Line 7212: Last_Updated_By = fnd_global.user_id,

7208:
7209: UPDATE Jai_Po_Line_Locations
7210: SET Tax_Amount = NULL,
7211: Total_Amount = NULL,
7212: Last_Updated_By = fnd_global.user_id,
7213: Last_Update_Date = sysdate,
7214: Last_Update_Login = fnd_global.login_id
7215: WHERE Po_Line_Id = v_po_line_id
7216: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */

Line 7214: Last_Update_Login = fnd_global.login_id

7210: SET Tax_Amount = NULL,
7211: Total_Amount = NULL,
7212: Last_Updated_By = fnd_global.user_id,
7213: Last_Update_Date = sysdate,
7214: Last_Update_Login = fnd_global.login_id
7215: WHERE Po_Line_Id = v_po_line_id
7216: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */
7217:
7218: v_tax_ctg_id := p_tax_category_id;