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

Line 1440: last_updated_by = FND_GLOBAL.USER_ID,

1436: ELSE 'Y'
1437: END
1438: ), --
1439: last_update_date = SYSDATE,
1440: last_updated_by = FND_GLOBAL.USER_ID,
1441: last_update_login = FND_GLOBAL.LOGIN_ID
1442: where auction_header_id = x_negotiation_id;
1443:
1444: else

Line 1441: last_update_login = FND_GLOBAL.LOGIN_ID

1437: END
1438: ), --
1439: last_update_date = SYSDATE,
1440: last_updated_by = FND_GLOBAL.USER_ID,
1441: last_update_login = FND_GLOBAL.LOGIN_ID
1442: where auction_header_id = x_negotiation_id;
1443:
1444: else
1445: -- : added update of at_sourcing_flag and of

Line 1473: last_updated_by = FND_GLOBAL.USER_ID,

1469: ELSE 'Y'
1470: END
1471: ), --
1472: last_update_date = SYSDATE,
1473: last_updated_by = FND_GLOBAL.USER_ID,
1474: last_update_login = FND_GLOBAL.LOGIN_ID
1475: where auction_header_id = x_negotiation_id
1476: and auction_line_number = x_negotiation_line_num;
1477: end if;

Line 1474: last_update_login = FND_GLOBAL.LOGIN_ID

1470: END
1471: ), --
1472: last_update_date = SYSDATE,
1473: last_updated_by = FND_GLOBAL.USER_ID,
1474: last_update_login = FND_GLOBAL.LOGIN_ID
1475: where auction_header_id = x_negotiation_id
1476: and auction_line_number = x_negotiation_line_num;
1477: end if;
1478:

Line 1618: last_updated_by = FND_GLOBAL.USER_ID,

1614: update po_requisition_lines_all prla --Bug 4001965: use _all
1615: set reqs_in_pool_flag = x_new_pool_value,
1616: at_sourcing_flag = x_sourcing_flag_value, --
1617: last_update_date = SYSDATE,
1618: last_updated_by = FND_GLOBAL.USER_ID,
1619: last_update_login = FND_GLOBAL.LOGIN_ID
1620: where auction_header_id = x_negotiation_id
1621: -- We only want to set the reqs_in_pool_flag to 'Y'
1622: --if all of the following conditions are met.

Line 1619: last_update_login = FND_GLOBAL.LOGIN_ID

1615: set reqs_in_pool_flag = x_new_pool_value,
1616: at_sourcing_flag = x_sourcing_flag_value, --
1617: last_update_date = SYSDATE,
1618: last_updated_by = FND_GLOBAL.USER_ID,
1619: last_update_login = FND_GLOBAL.LOGIN_ID
1620: where auction_header_id = x_negotiation_id
1621: -- We only want to set the reqs_in_pool_flag to 'Y'
1622: --if all of the following conditions are met.
1623: and nvl(modified_by_agent_flag,'N') <> 'Y' --

Line 1643: last_updated_by = FND_GLOBAL.USER_ID,

1639: update po_requisition_lines_all prla --Bug 4001965: use _all
1640: set reqs_in_pool_flag = x_new_pool_value,
1641: at_sourcing_flag = x_sourcing_flag_value, --
1642: last_update_date = SYSDATE,
1643: last_updated_by = FND_GLOBAL.USER_ID,
1644: last_update_login = FND_GLOBAL.LOGIN_ID
1645: where auction_header_id = x_negotiation_id
1646: and auction_line_number = x_negotiation_line_num
1647: -- We only want to set the reqs_in_pool_flag to 'Y'

Line 1644: last_update_login = FND_GLOBAL.LOGIN_ID

1640: set reqs_in_pool_flag = x_new_pool_value,
1641: at_sourcing_flag = x_sourcing_flag_value, --
1642: last_update_date = SYSDATE,
1643: last_updated_by = FND_GLOBAL.USER_ID,
1644: last_update_login = FND_GLOBAL.LOGIN_ID
1645: where auction_header_id = x_negotiation_id
1646: and auction_line_number = x_negotiation_line_num
1647: -- We only want to set the reqs_in_pool_flag to 'Y'
1648: --if all of the following conditions are met.

Line 1830: l_user_id := FND_GLOBAL.USER_ID;

1826:
1827: l_progress := '001';
1828:
1829: --Bug 2694722 : Getting user id
1830: l_user_id := FND_GLOBAL.USER_ID;
1831:
1832: --Populate PON_AUC_HEADERS_INTERFACE table
1833: insert into pon_auc_headers_interface(
1834: interface_auction_header_id,

Line 3402: last_updated_by = FND_GLOBAL.USER_ID,

3398: SET auction_header_id = p_auction_header_id,
3399: auction_line_number = -1,
3400: auction_display_number = -1,
3401: last_update_date = SYSDATE,
3402: last_updated_by = FND_GLOBAL.USER_ID,
3403: last_update_login = FND_GLOBAL.LOGIN_ID
3404: WHERE requisition_line_id = p_requisition_line_id(i)
3405: AND auction_header_id IS NULL
3406: returning requisition_header_id INTO l_requisition_header_id;

Line 3403: last_update_login = FND_GLOBAL.LOGIN_ID

3399: auction_line_number = -1,
3400: auction_display_number = -1,
3401: last_update_date = SYSDATE,
3402: last_updated_by = FND_GLOBAL.USER_ID,
3403: last_update_login = FND_GLOBAL.LOGIN_ID
3404: WHERE requisition_line_id = p_requisition_line_id(i)
3405: AND auction_header_id IS NULL
3406: returning requisition_header_id INTO l_requisition_header_id;
3407:

Line 3422: last_updated_by = FND_GLOBAL.USER_ID,

3418: auction_display_number = -1,
3419: bid_number = -1,
3420: bid_line_number = -1,
3421: last_update_date = SYSDATE,
3422: last_updated_by = FND_GLOBAL.USER_ID,
3423: last_update_login = FND_GLOBAL.LOGIN_ID
3424: WHERE requisition_line_id = p_requisition_line_id(i)
3425: AND auction_header_id IS NULL
3426: returning requisition_header_id INTO l_requisition_header_id;

Line 3423: last_update_login = FND_GLOBAL.LOGIN_ID

3419: bid_number = -1,
3420: bid_line_number = -1,
3421: last_update_date = SYSDATE,
3422: last_updated_by = FND_GLOBAL.USER_ID,
3423: last_update_login = FND_GLOBAL.LOGIN_ID
3424: WHERE requisition_line_id = p_requisition_line_id(i)
3425: AND auction_header_id IS NULL
3426: returning requisition_header_id INTO l_requisition_header_id;
3427:

Line 3441: last_updated_by = FND_GLOBAL.USER_ID,

3437: UPDATE po_requisition_lines_all
3438: SET reqs_in_pool_flag = null,
3439: at_sourcing_flag = 'Y',
3440: last_update_date = SYSDATE,
3441: last_updated_by = FND_GLOBAL.USER_ID,
3442: last_update_login = FND_GLOBAL.LOGIN_ID
3443: WHERE requisition_header_id = l_requisition_header_id
3444: AND Nvl(reqs_in_pool_flag, 'N') = 'Y'
3445: AND ((requisition_line_id = p_requisition_line_id(i))

Line 3442: last_update_login = FND_GLOBAL.LOGIN_ID

3438: SET reqs_in_pool_flag = null,
3439: at_sourcing_flag = 'Y',
3440: last_update_date = SYSDATE,
3441: last_updated_by = FND_GLOBAL.USER_ID,
3442: last_update_login = FND_GLOBAL.LOGIN_ID
3443: WHERE requisition_header_id = l_requisition_header_id
3444: AND Nvl(reqs_in_pool_flag, 'N') = 'Y'
3445: AND ((requisition_line_id = p_requisition_line_id(i))
3446: OR (group_line_id = p_requisition_line_id(i))

Line 3554: last_updated_by = FND_GLOBAL.USER_ID,

3550: THEN null
3551: ELSE 'Y'
3552: END),
3553: last_update_date = SYSDATE,
3554: last_updated_by = FND_GLOBAL.USER_ID,
3555: last_update_login = FND_GLOBAL.LOGIN_ID
3556: WHERE requisition_header_id = l_requisition_header_id
3557: AND ((requisition_line_id = p_req_line_ids(i) )
3558: OR (group_line_id = p_req_line_ids(i))

Line 3555: last_update_login = FND_GLOBAL.LOGIN_ID

3551: ELSE 'Y'
3552: END),
3553: last_update_date = SYSDATE,
3554: last_updated_by = FND_GLOBAL.USER_ID,
3555: last_update_login = FND_GLOBAL.LOGIN_ID
3556: WHERE requisition_header_id = l_requisition_header_id
3557: AND ((requisition_line_id = p_req_line_ids(i) )
3558: OR (group_line_id = p_req_line_ids(i))
3559: OR (clm_base_line_num = p_req_line_ids(i))

Line 3631: last_updated_by = FND_GLOBAL.USER_ID,

3627: THEN null
3628: ELSE 'Y'
3629: END),
3630: last_update_date = SYSDATE,
3631: last_updated_by = FND_GLOBAL.USER_ID,
3632: last_update_login = FND_GLOBAL.LOGIN_ID
3633: WHERE requisition_header_id = l_requisition_header_id
3634: AND ((requisition_line_id = p_req_line_ids(i) )
3635: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all

Line 3632: last_update_login = FND_GLOBAL.LOGIN_ID

3628: ELSE 'Y'
3629: END),
3630: last_update_date = SYSDATE,
3631: last_updated_by = FND_GLOBAL.USER_ID,
3632: last_update_login = FND_GLOBAL.LOGIN_ID
3633: WHERE requisition_header_id = l_requisition_header_id
3634: AND ((requisition_line_id = p_req_line_ids(i) )
3635: OR (requisition_line_id = (SELECT group_line_id from po_requisition_lines_all
3636: WHERE requisition_line_id = p_req_line_ids(i)

Line 3745: last_updated_by = FND_GLOBAL.USER_ID,

3741: THEN null
3742: ELSE 'Y'
3743: END),
3744: last_update_date = SYSDATE,
3745: last_updated_by = FND_GLOBAL.USER_ID,
3746: last_update_login = FND_GLOBAL.LOGIN_ID
3747: where auction_header_id = p_auction_header_id;
3748:
3749: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3746: last_update_login = FND_GLOBAL.LOGIN_ID

3742: ELSE 'Y'
3743: END),
3744: last_update_date = SYSDATE,
3745: last_updated_by = FND_GLOBAL.USER_ID,
3746: last_update_login = FND_GLOBAL.LOGIN_ID
3747: where auction_header_id = p_auction_header_id;
3748:
3749: x_return_status := FND_API.G_RET_STS_SUCCESS;
3750:

Line 3830: last_updated_by = FND_GLOBAL.USER_ID,

3826: UPDATE po_requisition_lines_all prl SET auction_header_id = NULL,
3827: auction_line_number = NULL,
3828: auction_display_number = NULL,
3829: last_update_date = SYSDATE,
3830: last_updated_by = FND_GLOBAL.USER_ID,
3831: last_update_login = FND_GLOBAL.LOGIN_ID
3832: WHERE auction_header_id = p_auction_header_id
3833: AND NOT EXISTS (SELECT requisition_line_id
3834: FROM pon_backing_requisitions pbr

Line 3831: last_update_login = FND_GLOBAL.LOGIN_ID

3827: auction_line_number = NULL,
3828: auction_display_number = NULL,
3829: last_update_date = SYSDATE,
3830: last_updated_by = FND_GLOBAL.USER_ID,
3831: last_update_login = FND_GLOBAL.LOGIN_ID
3832: WHERE auction_header_id = p_auction_header_id
3833: AND NOT EXISTS (SELECT requisition_line_id
3834: FROM pon_backing_requisitions pbr
3835: WHERE auction_header_id = p_auction_header_id

Line 3847: last_updated_by = FND_GLOBAL.USER_ID,

3843: auction_display_number = NULL,
3844: bid_number = NULL,
3845: bid_line_number = NULL,
3846: last_update_date = SYSDATE,
3847: last_updated_by = FND_GLOBAL.USER_ID,
3848: last_update_login = FND_GLOBAL.LOGIN_ID
3849: WHERE auction_header_id = p_auction_header_id
3850: AND NOT EXISTS (SELECT requisition_line_id
3851: FROM pon_bid_backing_requisitions pbr

Line 3848: last_update_login = FND_GLOBAL.LOGIN_ID

3844: bid_number = NULL,
3845: bid_line_number = NULL,
3846: last_update_date = SYSDATE,
3847: last_updated_by = FND_GLOBAL.USER_ID,
3848: last_update_login = FND_GLOBAL.LOGIN_ID
3849: WHERE auction_header_id = p_auction_header_id
3850: AND NOT EXISTS (SELECT requisition_line_id
3851: FROM pon_bid_backing_requisitions pbr
3852: WHERE auction_header_id = p_auction_header_id

Line 3924: last_updated_by = FND_GLOBAL.USER_ID,

3920: UPDATE po_requisition_lines_all SET auction_header_id = NULL,
3921: auction_line_number = NULL,
3922: auction_display_number = NULL,
3923: last_update_date = SYSDATE,
3924: last_updated_by = FND_GLOBAL.USER_ID,
3925: last_update_login = FND_GLOBAL.LOGIN_ID
3926: WHERE EXISTS (SELECT DISTINCT(requisition_line_id)
3927: FROM pon_backing_requisitions
3928: WHERE auction_header_id = p_old_auction_id

Line 3925: last_update_login = FND_GLOBAL.LOGIN_ID

3921: auction_line_number = NULL,
3922: auction_display_number = NULL,
3923: last_update_date = SYSDATE,
3924: last_updated_by = FND_GLOBAL.USER_ID,
3925: last_update_login = FND_GLOBAL.LOGIN_ID
3926: WHERE EXISTS (SELECT DISTINCT(requisition_line_id)
3927: FROM pon_backing_requisitions
3928: WHERE auction_header_id = p_old_auction_id
3929: MINUS (SELECT requisition_line_id