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

Line 4970: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

4966:
4967: l_header_rec.header_id := p_header_id;
4968: l_header_rec.credit_card_approval_code := p_auth_code;
4969: l_header_rec.credit_card_approval_date := p_auth_date;
4970: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
4971: l_header_rec.last_update_date := SYSDATE;
4972: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4973: l_header_rec.lock_control := l_header_rec.lock_control + 1;
4974: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line 4972: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

4968: l_header_rec.credit_card_approval_code := p_auth_code;
4969: l_header_rec.credit_card_approval_date := p_auth_date;
4970: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
4971: l_header_rec.last_update_date := SYSDATE;
4972: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4973: l_header_rec.lock_control := l_header_rec.lock_control + 1;
4974: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4975:
4976: -- Header needs to be requeried, setting the flag to true

Line 4986: , last_updated_by = FND_GLOBAL.USER_ID

4982:
4983: update oe_order_headers
4984: set credit_card_approval_code = p_auth_code
4985: , credit_card_approval_date = p_auth_date
4986: , last_updated_by = FND_GLOBAL.USER_ID
4987: , last_update_date = SYSDATE
4988: , last_update_login = FND_GLOBAL.LOGIN_ID
4989: , lock_control = lock_control + 1
4990: where header_id = p_header_id;

Line 4988: , last_update_login = FND_GLOBAL.LOGIN_ID

4984: set credit_card_approval_code = p_auth_code
4985: , credit_card_approval_date = p_auth_date
4986: , last_updated_by = FND_GLOBAL.USER_ID
4987: , last_update_date = SYSDATE
4988: , last_update_login = FND_GLOBAL.LOGIN_ID
4989: , lock_control = lock_control + 1
4990: where header_id = p_header_id;
4991:
4992: -- aksingh performance

Line 6340: , last_updated_by = FND_GLOBAL.USER_ID

6336: -- if line_id is null, then this is for header invoice payment.
6337: IF l_payments_tbl(I).line_id IS NULL THEN
6338: UPDATE oe_order_headers_all
6339: SET payment_amount = l_amount.value
6340: , last_updated_by = FND_GLOBAL.USER_ID
6341: , last_update_date = SYSDATE
6342: , last_update_login = FND_GLOBAL.LOGIN_ID
6343: , lock_control = lock_control + 1
6344: WHERE header_id = p_header_rec.header_id

Line 6342: , last_update_login = FND_GLOBAL.LOGIN_ID

6338: UPDATE oe_order_headers_all
6339: SET payment_amount = l_amount.value
6340: , last_updated_by = FND_GLOBAL.USER_ID
6341: , last_update_date = SYSDATE
6342: , last_update_login = FND_GLOBAL.LOGIN_ID
6343: , lock_control = lock_control + 1
6344: WHERE header_id = p_header_rec.header_id
6345: AND payment_type_code = 'CREDIT_CARD';
6346: END IF;

Line 6407: , last_updated_by = FND_GLOBAL.USER_ID

6403:
6404: -- update order header with the authorized amount for header invoice payment.
6405: UPDATE oe_order_headers_all
6406: SET payment_amount = l_amount.value
6407: , last_updated_by = FND_GLOBAL.USER_ID
6408: , last_update_date = SYSDATE
6409: , last_update_login = FND_GLOBAL.LOGIN_ID
6410: , lock_control = lock_control + 1
6411: WHERE header_id = p_header_rec.header_id

Line 6409: , last_update_login = FND_GLOBAL.LOGIN_ID

6405: UPDATE oe_order_headers_all
6406: SET payment_amount = l_amount.value
6407: , last_updated_by = FND_GLOBAL.USER_ID
6408: , last_update_date = SYSDATE
6409: , last_update_login = FND_GLOBAL.LOGIN_ID
6410: , lock_control = lock_control + 1
6411: WHERE header_id = p_header_rec.header_id
6412: AND payment_type_code = 'CREDIT_CARD';
6413:

Line 8149: l_Line_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;

8145: l_Line_Payment_rec.header_id := p_header_id;
8146: l_Line_Payment_rec.line_id := p_line_id;
8147: l_Line_Payment_rec.credit_card_approval_code := p_auth_code;
8148: l_Line_Payment_rec.credit_card_approval_date := p_auth_date;
8149: l_Line_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;
8150: l_Line_Payment_rec.last_update_date := SYSDATE;
8151: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
8152: l_Line_Payment_rec.lock_control := l_header_rec.lock_control + 1;
8153: l_Line_Payment_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line 8151: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

8147: l_Line_Payment_rec.credit_card_approval_code := p_auth_code;
8148: l_Line_Payment_rec.credit_card_approval_date := p_auth_date;
8149: l_Line_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;
8150: l_Line_Payment_rec.last_update_date := SYSDATE;
8151: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
8152: l_Line_Payment_rec.lock_control := l_header_rec.lock_control + 1;
8153: l_Line_Payment_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
8154:
8155: -- Header needs to be requeried, setting the flag to true

Line 8169: , last_updated_by = FND_GLOBAL.USER_ID

8165: update oe_payments
8166: set credit_card_approval_code = p_auth_code
8167: , credit_card_approval_date = p_auth_date
8168: , tangible_id = p_tangible_id
8169: , last_updated_by = FND_GLOBAL.USER_ID
8170: , last_update_date = SYSDATE
8171: , last_update_login = FND_GLOBAL.LOGIN_ID
8172: , lock_control = lock_control + 1
8173: where nvl(payment_number, -1) = nvl(p_payment_number, -1)

Line 8171: , last_update_login = FND_GLOBAL.LOGIN_ID

8167: , credit_card_approval_date = p_auth_date
8168: , tangible_id = p_tangible_id
8169: , last_updated_by = FND_GLOBAL.USER_ID
8170: , last_update_date = SYSDATE
8171: , last_update_login = FND_GLOBAL.LOGIN_ID
8172: , lock_control = lock_control + 1
8173: where nvl(payment_number, -1) = nvl(p_payment_number, -1)
8174: and line_id = p_line_id
8175: and header_id = p_header_id;

Line 8182: , last_updated_by = FND_GLOBAL.USER_ID

8178: update oe_payments
8179: set credit_card_approval_code = p_auth_code
8180: , credit_card_approval_date = p_auth_date
8181: , tangible_id = p_tangible_id
8182: , last_updated_by = FND_GLOBAL.USER_ID
8183: , last_update_date = SYSDATE
8184: , last_update_login = FND_GLOBAL.LOGIN_ID
8185: , lock_control = lock_control + 1
8186: where line_id IS NULL

Line 8184: , last_update_login = FND_GLOBAL.LOGIN_ID

8180: , credit_card_approval_date = p_auth_date
8181: , tangible_id = p_tangible_id
8182: , last_updated_by = FND_GLOBAL.USER_ID
8183: , last_update_date = SYSDATE
8184: , last_update_login = FND_GLOBAL.LOGIN_ID
8185: , lock_control = lock_control + 1
8186: where line_id IS NULL
8187: and payment_type_code = 'CREDIT_CARD'
8188: and payment_collection_event = 'INVOICE'