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 4897: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

4893:
4894: l_header_rec.header_id := p_header_id;
4895: l_header_rec.credit_card_approval_code := p_auth_code;
4896: l_header_rec.credit_card_approval_date := p_auth_date;
4897: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
4898: l_header_rec.last_update_date := SYSDATE;
4899: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4900: l_header_rec.lock_control := l_header_rec.lock_control + 1;
4901: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

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

4895: l_header_rec.credit_card_approval_code := p_auth_code;
4896: l_header_rec.credit_card_approval_date := p_auth_date;
4897: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
4898: l_header_rec.last_update_date := SYSDATE;
4899: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4900: l_header_rec.lock_control := l_header_rec.lock_control + 1;
4901: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4902:
4903: -- Header needs to be requeried, setting the flag to true

Line 4913: , last_updated_by = FND_GLOBAL.USER_ID

4909:
4910: update oe_order_headers
4911: set credit_card_approval_code = p_auth_code
4912: , credit_card_approval_date = p_auth_date
4913: , last_updated_by = FND_GLOBAL.USER_ID
4914: , last_update_date = SYSDATE
4915: , last_update_login = FND_GLOBAL.LOGIN_ID
4916: , lock_control = lock_control + 1
4917: where header_id = p_header_id;

Line 4915: , last_update_login = FND_GLOBAL.LOGIN_ID

4911: set credit_card_approval_code = p_auth_code
4912: , credit_card_approval_date = p_auth_date
4913: , last_updated_by = FND_GLOBAL.USER_ID
4914: , last_update_date = SYSDATE
4915: , last_update_login = FND_GLOBAL.LOGIN_ID
4916: , lock_control = lock_control + 1
4917: where header_id = p_header_id;
4918:
4919: -- aksingh performance

Line 6088: , last_updated_by = FND_GLOBAL.USER_ID

6084: -- if line_id is null, then this is for header invoice payment.
6085: IF l_payments_tbl(I).line_id IS NULL THEN
6086: UPDATE oe_order_headers_all
6087: SET payment_amount = l_amount.value
6088: , last_updated_by = FND_GLOBAL.USER_ID
6089: , last_update_date = SYSDATE
6090: , last_update_login = FND_GLOBAL.LOGIN_ID
6091: , lock_control = lock_control + 1
6092: WHERE header_id = p_header_rec.header_id

Line 6090: , last_update_login = FND_GLOBAL.LOGIN_ID

6086: UPDATE oe_order_headers_all
6087: SET payment_amount = l_amount.value
6088: , last_updated_by = FND_GLOBAL.USER_ID
6089: , last_update_date = SYSDATE
6090: , last_update_login = FND_GLOBAL.LOGIN_ID
6091: , lock_control = lock_control + 1
6092: WHERE header_id = p_header_rec.header_id
6093: AND payment_type_code = 'CREDIT_CARD';
6094: END IF;

Line 6134: , last_updated_by = FND_GLOBAL.USER_ID

6130:
6131: -- update order header with the authorized amount for header invoice payment.
6132: UPDATE oe_order_headers_all
6133: SET payment_amount = l_amount.value
6134: , last_updated_by = FND_GLOBAL.USER_ID
6135: , last_update_date = SYSDATE
6136: , last_update_login = FND_GLOBAL.LOGIN_ID
6137: , lock_control = lock_control + 1
6138: WHERE header_id = p_header_rec.header_id

Line 6136: , last_update_login = FND_GLOBAL.LOGIN_ID

6132: UPDATE oe_order_headers_all
6133: SET payment_amount = l_amount.value
6134: , last_updated_by = FND_GLOBAL.USER_ID
6135: , last_update_date = SYSDATE
6136: , last_update_login = FND_GLOBAL.LOGIN_ID
6137: , lock_control = lock_control + 1
6138: WHERE header_id = p_header_rec.header_id
6139: AND payment_type_code = 'CREDIT_CARD';
6140:

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

7501: l_Line_Payment_rec.header_id := p_header_id;
7502: l_Line_Payment_rec.line_id := p_line_id;
7503: l_Line_Payment_rec.credit_card_approval_code := p_auth_code;
7504: l_Line_Payment_rec.credit_card_approval_date := p_auth_date;
7505: l_Line_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;
7506: l_Line_Payment_rec.last_update_date := SYSDATE;
7507: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
7508: l_Line_Payment_rec.lock_control := l_header_rec.lock_control + 1;
7509: l_Line_Payment_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

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

7503: l_Line_Payment_rec.credit_card_approval_code := p_auth_code;
7504: l_Line_Payment_rec.credit_card_approval_date := p_auth_date;
7505: l_Line_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;
7506: l_Line_Payment_rec.last_update_date := SYSDATE;
7507: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
7508: l_Line_Payment_rec.lock_control := l_header_rec.lock_control + 1;
7509: l_Line_Payment_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
7510:
7511: -- Header needs to be requeried, setting the flag to true

Line 7525: , last_updated_by = FND_GLOBAL.USER_ID

7521: update oe_payments
7522: set credit_card_approval_code = p_auth_code
7523: , credit_card_approval_date = p_auth_date
7524: , tangible_id = p_tangible_id
7525: , last_updated_by = FND_GLOBAL.USER_ID
7526: , last_update_date = SYSDATE
7527: , last_update_login = FND_GLOBAL.LOGIN_ID
7528: , lock_control = lock_control + 1
7529: where nvl(payment_number, -1) = nvl(p_payment_number, -1)

Line 7527: , last_update_login = FND_GLOBAL.LOGIN_ID

7523: , credit_card_approval_date = p_auth_date
7524: , tangible_id = p_tangible_id
7525: , last_updated_by = FND_GLOBAL.USER_ID
7526: , last_update_date = SYSDATE
7527: , last_update_login = FND_GLOBAL.LOGIN_ID
7528: , lock_control = lock_control + 1
7529: where nvl(payment_number, -1) = nvl(p_payment_number, -1)
7530: and line_id = p_line_id
7531: and header_id = p_header_id;

Line 7538: , last_updated_by = FND_GLOBAL.USER_ID

7534: update oe_payments
7535: set credit_card_approval_code = p_auth_code
7536: , credit_card_approval_date = p_auth_date
7537: , tangible_id = p_tangible_id
7538: , last_updated_by = FND_GLOBAL.USER_ID
7539: , last_update_date = SYSDATE
7540: , last_update_login = FND_GLOBAL.LOGIN_ID
7541: , lock_control = lock_control + 1
7542: where line_id IS NULL

Line 7540: , last_update_login = FND_GLOBAL.LOGIN_ID

7536: , credit_card_approval_date = p_auth_date
7537: , tangible_id = p_tangible_id
7538: , last_updated_by = FND_GLOBAL.USER_ID
7539: , last_update_date = SYSDATE
7540: , last_update_login = FND_GLOBAL.LOGIN_ID
7541: , lock_control = lock_control + 1
7542: where line_id IS NULL
7543: and payment_type_code = 'CREDIT_CARD'
7544: and payment_collection_event = 'INVOICE'