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

Line 517: ,last_updated_by = fnd_global.user_id

513: --11i10 Pricing Changes Start
514: if oe_code_control.get_code_release_level >= '110510' then
515: Update oe_blanket_headers
516: set lock_control = lock_control + 1
517: ,last_updated_by = fnd_global.user_id
518: ,last_update_date = sysdate
519: where header_id = lheader_id ;
520: Update oe_blanket_headers_ext
521: set new_price_list_id = ppr_price_list_rec.list_header_id

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

2248: -- Validate Last Updated By values.
2249: -- Added for bug #6270818.
2250: IF p_line_rec.operation = oe_globals.g_opr_update
2251: THEN
2252: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2253: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2254: THEN
2255: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2256: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 2253: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID

2249: -- Added for bug #6270818.
2250: IF p_line_rec.operation = oe_globals.g_opr_update
2251: THEN
2252: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2253: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2254: THEN
2255: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2256: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2257: END IF;

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

2251: THEN
2252: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2253: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2254: THEN
2255: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2256: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2257: END IF;
2258: p_line_rec.last_update_date := sysdate;
2259: l_old_line_rec.last_update_date := sysdate;

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

2252: If p_line_rec.last_updated_by <> FND_GLOBAL.USER_ID or
2253: l_old_line_rec.last_updated_by <> FND_GLOBAL.USER_ID
2254: THEN
2255: p_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2256: l_old_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
2257: END IF;
2258: p_line_rec.last_update_date := sysdate;
2259: l_old_line_rec.last_update_date := sysdate;
2260: END IF;

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

3179: -- Validate Last Updated By valued issue
3180: -- Added for a bug #6270818.
3181: IF p_header_rec.operation = oe_globals.g_opr_update
3182: THEN
3183: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3184: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3185: THEN
3186: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3187: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 3184: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID

3180: -- Added for a bug #6270818.
3181: IF p_header_rec.operation = oe_globals.g_opr_update
3182: THEN
3183: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3184: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3185: THEN
3186: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3187: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3188: END IF;

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

3182: THEN
3183: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3184: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3185: THEN
3186: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3187: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3188: END IF;
3189: p_header_rec.last_update_date := sysdate;
3190: l_old_header_rec.last_update_date := sysdate;

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

3183: If p_header_rec.last_updated_by <> FND_GLOBAL.USER_ID or
3184: l_old_header_rec.last_updated_by <> FND_GLOBAL.USER_ID
3185: THEN
3186: p_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3187: l_old_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3188: END IF;
3189: p_header_rec.last_update_date := sysdate;
3190: l_old_header_rec.last_update_date := sysdate;
3191: END IF;

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

4351: , DELIVER_TO_ORG_ID = p_header_rec.deliver_to_org_id
4352: , FREIGHT_TERMS_CODE = p_header_rec.freight_terms_code
4353: , INVOICE_TO_ORG_ID = p_header_rec.invoice_to_org_id
4354: , INVOICING_RULE_ID = p_header_rec.invoicing_rule_id
4355: , LAST_UPDATED_BY = nvl(p_header_rec.last_updated_by, FND_GLOBAL.USER_ID)
4356: , LAST_UPDATE_DATE = nvl(p_header_rec.last_update_date, sysdate)
4357: , LAST_UPDATE_LOGIN = p_header_rec.last_update_login
4358: , ORDER_TYPE_ID = p_header_rec.order_type_id
4359: , PAYMENT_TERM_ID = p_header_rec.payment_term_id

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

4928: , lock_control = lock_control + 1
4929:
4930: , ORDERED_ITEM = p_line_rec.ordered_item
4931: , ITEM_TYPE_CODE = p_line_rec.item_type_code
4932: , LAST_UPDATED_BY = nvl(p_line_rec.last_updated_by, FND_GLOBAL.USER_ID)
4933: , LAST_UPDATE_DATE = nvl(p_line_rec.last_update_date, sysdate)
4934: , LAST_UPDATE_LOGIN = p_line_rec.last_update_login
4935: , line_number = p_line_rec.line_number
4936: , PAYMENT_TERM_ID = p_line_rec.payment_term_id

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

6558:
6559: -- Default Who Columns
6560: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6561: p_x_header_rec.creation_Date := sysdate;
6562: p_x_header_rec.created_by := FND_GLOBAL.USER_ID;
6563: END IF;
6564:
6565: p_x_header_rec.last_update_date := sysdate;
6566: p_x_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

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

6562: p_x_header_rec.created_by := FND_GLOBAL.USER_ID;
6563: END IF;
6564:
6565: p_x_header_rec.last_update_date := sysdate;
6566: p_x_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
6567:
6568: -- Default Currency Code
6569: IF p_x_header_rec.transactional_curr_code IS NULL THEN
6570: BEGIN

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

6892:
6893: -- WHO columns
6894: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6895: p_x_line_rec.creation_Date := sysdate;
6896: p_x_line_rec.created_by := FND_GLOBAL.USER_ID;
6897: END IF;
6898: p_x_line_rec.last_update_date := sysdate;
6899: p_x_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
6900:

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

6895: p_x_line_rec.creation_Date := sysdate;
6896: p_x_line_rec.created_by := FND_GLOBAL.USER_ID;
6897: END IF;
6898: p_x_line_rec.last_update_date := sysdate;
6899: p_x_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
6900:
6901: EXCEPTION
6902: WHEN FND_API.G_EXC_ERROR THEN
6903: x_return_status := FND_API.G_RET_STS_ERROR;

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

8091: , p_header_rec.ORG_ID
8092: , p_header_rec.REVISION_CHANGE_REASON_CODE
8093: , p_header_rec.REVISION_CHANGE_COMMENTS
8094: , p_header_rec.REVISION_CHANGE_DATE
8095: , nvl(FND_GLOBAL.RESP_ID,-1)
8096: , 'UPDATE'
8097: , sysdate
8098: , nvl(FND_GLOBAL.USER_ID, -1)
8099: , 'B'

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

8094: , p_header_rec.REVISION_CHANGE_DATE
8095: , nvl(FND_GLOBAL.RESP_ID,-1)
8096: , 'UPDATE'
8097: , sysdate
8098: , nvl(FND_GLOBAL.USER_ID, -1)
8099: , 'B'
8100: , p_header_rec.source_document_id
8101: , p_header_rec.source_document_type_id
8102: , p_header_rec.SALES_DOCUMENT_NAME -- hashraf ... start of pack J

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

8303: , p_line_tbl(I).ORDER_NUMBER
8304: , p_line_tbl(I).RELEASED_AMOUNT
8305: , p_line_tbl(I).FULFILLED_AMOUNT
8306: , p_line_tbl(I).RETURNED_AMOUNT
8307: , nvl(FND_GLOBAL.RESP_ID,-1)
8308: , 'UPDATE'
8309: , sysdate
8310: , nvl(FND_GLOBAL.USER_ID, -1)
8311: , p_header_rec.version_number

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

8306: , p_line_tbl(I).RETURNED_AMOUNT
8307: , nvl(FND_GLOBAL.RESP_ID,-1)
8308: , 'UPDATE'
8309: , sysdate
8310: , nvl(FND_GLOBAL.USER_ID, -1)
8311: , p_header_rec.version_number
8312: , 'B'
8313: , p_line_tbl(I).TRANSACTION_PHASE_CODE -- hashraf ... start of pack J
8314: , p_line_tbl(I).source_document_version_number