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.OE_BLANKET_UTIL dependencies on FND_GLOBAL

Line 644: ,last_updated_by = fnd_global.user_id

640: --11i10 Pricing Changes Start
641: if oe_code_control.get_code_release_level >= '110510' then
642: Update oe_blanket_headers
643: set lock_control = lock_control + 1
644: ,last_updated_by = fnd_global.user_id
645: ,last_update_date = sysdate
646: where header_id = lheader_id ;
647: Update oe_blanket_headers_ext
648: set new_price_list_id = ppr_price_list_rec.list_header_id

Line 2397: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or

2393: -- Validate Last Updated By values.
2394: -- Added for bug #6270818.
2395: IF p_line_rec.operation = oe_globals.g_opr_update
2396: THEN
2397: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2398: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2399: THEN
2400: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2401: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 2398: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID

2394: -- Added for bug #6270818.
2395: IF p_line_rec.operation = oe_globals.g_opr_update
2396: THEN
2397: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2398: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2399: THEN
2400: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2401: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2402: END IF;

Line 2400: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;

2396: THEN
2397: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2398: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2399: THEN
2400: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2401: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2402: END IF;
2403: p_line_rec.last_update_date := sysdate;
2404: l_old_line_rec.last_update_date := sysdate;

Line 2401: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;

2397: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2398: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2399: THEN
2400: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2401: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2402: END IF;
2403: p_line_rec.last_update_date := sysdate;
2404: l_old_line_rec.last_update_date := sysdate;
2405: END IF;

Line 3374: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or

3370: -- Validate Last Updated By valued issue
3371: -- Added for a bug #6270818.
3372: IF p_header_rec.operation = oe_globals.g_opr_update
3373: THEN
3374: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3375: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3376: THEN
3377: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3378: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 3375: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID

3371: -- Added for a bug #6270818.
3372: IF p_header_rec.operation = oe_globals.g_opr_update
3373: THEN
3374: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3375: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3376: THEN
3377: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3378: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3379: END IF;

Line 3377: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

3373: THEN
3374: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3375: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3376: THEN
3377: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3378: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3379: END IF;
3380: p_header_rec.last_update_date := sysdate;
3381: l_old_header_rec.last_update_date := sysdate;

Line 3378: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

3374: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3375: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3376: THEN
3377: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3378: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3379: END IF;
3380: p_header_rec.last_update_date := sysdate;
3381: l_old_header_rec.last_update_date := sysdate;
3382: END IF;

Line 4549: , LAST_UPDATED_BY = nvl(p_header_rec.last_updated_by, FND_GLOBAL.USER_ID)

4545: , DELIVER_TO_ORG_ID = p_header_rec.deliver_to_org_id
4546: , FREIGHT_TERMS_CODE = p_header_rec.freight_terms_code
4547: , INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
4548: , INVOICING_RULE_ID = p_header_rec.invoicing_rule_id
4549: , LAST_UPDATED_BY = nvl(p_header_rec.last_updated_by, FND_GLOBAL.USER_ID)
4550: , LAST_UPDATE_DATE = nvl(p_header_rec.last_update_date, sysdate)
4551: , LAST_UPDATE_LOGIN = p_header_rec.last_update_login
4552: , ORDER_TYPE_ID = p_header_rec.order_type_id
4553: , PAYMENT_TERM_ID = p_header_rec.payment_term_id

Line 5126: , LAST_UPDATED_BY = nvl(p_line_rec.last_updated_by, FND_GLOBAL.USER_ID)

5122: , lock_control = lock_control + 1
5123:
5124: , ORDERED_ITEM = p_line_rec.ordered_item
5125: , ITEM_TYPE_CODE = p_line_rec.item_type_code
5126: , LAST_UPDATED_BY = nvl(p_line_rec.last_updated_by, FND_GLOBAL.USER_ID)
5127: , LAST_UPDATE_DATE = nvl(p_line_rec.last_update_date, sysdate)
5128: , LAST_UPDATE_LOGIN = p_line_rec.last_update_login
5129: , line_number = p_line_rec.line_number
5130: , PAYMENT_TERM_ID = p_line_rec.payment_term_id

Line 6756: p_x_header_rec.created_by := FND_GLOBAL.USER_ID;

6752:
6753: -- Default Who Columns
6754: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6755: p_x_header_rec.creation_Date := sysdate;
6756: p_x_header_rec.created_by := FND_GLOBAL.USER_ID;
6757: END IF;
6758:
6759: p_x_header_rec.last_update_date := sysdate;
6760: p_x_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 6760: p_x_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

6756: p_x_header_rec.created_by := FND_GLOBAL.USER_ID;
6757: END IF;
6758:
6759: p_x_header_rec.last_update_date := sysdate;
6760: p_x_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
6761:
6762: -- Default Currency Code
6763: IF p_x_header_rec.transactional_curr_code IS NULL THEN
6764: BEGIN

Line 7090: p_x_line_rec.created_by := FND_GLOBAL.USER_ID;

7086:
7087: -- WHO columns
7088: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7089: p_x_line_rec.creation_Date := sysdate;
7090: p_x_line_rec.created_by := FND_GLOBAL.USER_ID;
7091: END IF;
7092: p_x_line_rec.last_update_date := sysdate;
7093: p_x_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
7094:

Line 7093: p_x_line_rec.last_updated_by := FND_GLOBAL.USER_ID;

7089: p_x_line_rec.creation_Date := sysdate;
7090: p_x_line_rec.created_by := FND_GLOBAL.USER_ID;
7091: END IF;
7092: p_x_line_rec.last_update_date := sysdate;
7093: p_x_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
7094:
7095: EXCEPTION
7096: WHEN FND_API.G_EXC_ERROR THEN
7097: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8292: , nvl(FND_GLOBAL.RESP_ID,-1)

8288: , p_header_rec.ORG_ID
8289: , p_header_rec.REVISION_CHANGE_REASON_CODE
8290: , p_header_rec.REVISION_CHANGE_COMMENTS
8291: , p_header_rec.REVISION_CHANGE_DATE
8292: , nvl(FND_GLOBAL.RESP_ID,-1)
8293: , 'UPDATE'
8294: , sysdate
8295: , nvl(FND_GLOBAL.USER_ID, -1)
8296: , 'B'

Line 8295: , nvl(FND_GLOBAL.USER_ID, -1)

8291: , p_header_rec.REVISION_CHANGE_DATE
8292: , nvl(FND_GLOBAL.RESP_ID,-1)
8293: , 'UPDATE'
8294: , sysdate
8295: , nvl(FND_GLOBAL.USER_ID, -1)
8296: , 'B'
8297: , p_header_rec.source_document_id
8298: , p_header_rec.source_document_type_id
8299: , p_header_rec.SALES_DOCUMENT_NAME -- hashraf ... start of pack J

Line 8504: , nvl(FND_GLOBAL.RESP_ID,-1)

8500: , p_line_tbl(I).ORDER_NUMBER
8501: , p_line_tbl(I).RELEASED_AMOUNT
8502: , p_line_tbl(I).FULFILLED_AMOUNT
8503: , p_line_tbl(I).RETURNED_AMOUNT
8504: , nvl(FND_GLOBAL.RESP_ID,-1)
8505: , 'UPDATE'
8506: , sysdate
8507: , nvl(FND_GLOBAL.USER_ID, -1)
8508: , p_header_rec.version_number

Line 8507: , nvl(FND_GLOBAL.USER_ID, -1)

8503: , p_line_tbl(I).RETURNED_AMOUNT
8504: , nvl(FND_GLOBAL.RESP_ID,-1)
8505: , 'UPDATE'
8506: , sysdate
8507: , nvl(FND_GLOBAL.USER_ID, -1)
8508: , p_header_rec.version_number
8509: , 'B'
8510: , p_line_tbl(I).TRANSACTION_PHASE_CODE -- hashraf ... start of pack J
8511: , p_line_tbl(I).source_document_version_number