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.PON_AWARD_PKG dependencies on FND_USER

Line 1012: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u

1008: select u.user_name,
1009: a.trading_partner_name auctioneer,
1010: a.auction_title,
1011: a.document_number
1012: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u
1013: where b.menu_name = 'EMD_ADMIN'
1014: and b.approver_flag = 'Y'
1015: and a.auction_header_id = b.auction_header_id
1016: and u.user_id = b.user_id

Line 3681: l_fnd_user_id NUMBER;

3677: x_status OUT NOCOPY VARCHAR2
3678: )
3679: IS
3680:
3681: l_fnd_user_id NUMBER;
3682: l_next_scenario_number NUMBER;
3683: l_num_constraints NUMBER;
3684: l_num_bid_classes NUMBER;
3685: l_auction_header_id NUMBER;

Line 3691: -- Derive fnd_user_id from tp_id

3687: l_new_scenario_id NUMBER;
3688:
3689: BEGIN
3690:
3691: -- Derive fnd_user_id from tp_id
3692: -- This will not fail if more than one user setup w/ same buyer.
3693: -- But, this will reurn any of the matched user id in such cases
3694: BEGIN
3695: SELECT USER_ID

Line 3696: INTO l_fnd_user_id

3692: -- This will not fail if more than one user setup w/ same buyer.
3693: -- But, this will reurn any of the matched user id in such cases
3694: BEGIN
3695: SELECT USER_ID
3696: INTO l_fnd_user_id
3697: FROM FND_USER
3698: WHERE PERSON_PARTY_ID = p_user_id
3699: AND NVL(END_DATE,SYSDATE+1) > SYSDATE;
3700: EXCEPTION

Line 3697: FROM FND_USER

3693: -- But, this will reurn any of the matched user id in such cases
3694: BEGIN
3695: SELECT USER_ID
3696: INTO l_fnd_user_id
3697: FROM FND_USER
3698: WHERE PERSON_PARTY_ID = p_user_id
3699: AND NVL(END_DATE,SYSDATE+1) > SYSDATE;
3700: EXCEPTION
3701: WHEN TOO_MANY_ROWS THEN

Line 3711: INTO l_fnd_user_id

3707: END IF;
3708: END IF;
3709:
3710: SELECT USER_ID
3711: INTO l_fnd_user_id
3712: FROM FND_USER
3713: WHERE PERSON_PARTY_ID = p_user_id
3714: AND NVL(END_DATE,SYSDATE+1) > SYSDATE
3715: AND ROWNUM = 1;

Line 3712: FROM FND_USER

3708: END IF;
3709:
3710: SELECT USER_ID
3711: INTO l_fnd_user_id
3712: FROM FND_USER
3713: WHERE PERSON_PARTY_ID = p_user_id
3714: AND NVL(END_DATE,SYSDATE+1) > SYSDATE
3715: AND ROWNUM = 1;
3716: END;

Line 3773: l_fnd_user_id,

3769: internal_note,
3770: p_user_id,
3771: sysdate,
3772: sysdate,
3773: l_fnd_user_id,
3774: sysdate,
3775: l_fnd_user_id,
3776: l_fnd_user_id,
3777: p_cost_scenario_flag,

Line 3775: l_fnd_user_id,

3771: sysdate,
3772: sysdate,
3773: l_fnd_user_id,
3774: sysdate,
3775: l_fnd_user_id,
3776: l_fnd_user_id,
3777: p_cost_scenario_flag,
3778: decode(p_cost_scenario_flag, 'Y', p_scenario_id, to_number(null)),
3779: nvl(constraint_priority_type, 'MANDATORY')

Line 3776: l_fnd_user_id,

3772: sysdate,
3773: l_fnd_user_id,
3774: sysdate,
3775: l_fnd_user_id,
3776: l_fnd_user_id,
3777: p_cost_scenario_flag,
3778: decode(p_cost_scenario_flag, 'Y', p_scenario_id, to_number(null)),
3779: nvl(constraint_priority_type, 'MANDATORY')
3780: FROM pon_optimize_scenarios

Line 3874: l_fnd_user_id,

3870: trading_partner_id,
3871: trading_partner_contact_id,
3872: vendor_site_id,
3873: sysdate,
3874: l_fnd_user_id,
3875: sysdate,
3876: l_fnd_user_id,
3877: l_fnd_user_id,
3878: MIN_MAX_AMOUNT_PRIORITY

Line 3876: l_fnd_user_id,

3872: vendor_site_id,
3873: sysdate,
3874: l_fnd_user_id,
3875: sysdate,
3876: l_fnd_user_id,
3877: l_fnd_user_id,
3878: MIN_MAX_AMOUNT_PRIORITY
3879: ,TO_NUMBER(NULL)
3880: ,TO_CHAR(NULL)

Line 3877: l_fnd_user_id,

3873: sysdate,
3874: l_fnd_user_id,
3875: sysdate,
3876: l_fnd_user_id,
3877: l_fnd_user_id,
3878: MIN_MAX_AMOUNT_PRIORITY
3879: ,TO_NUMBER(NULL)
3880: ,TO_CHAR(NULL)
3881: ,MIN_MAX_QUANTITY_PRIORITY

Line 3931: l_fnd_user_id,

3927: SELECT l_new_scenario_id,
3928: sequence_number,
3929: bid_number,
3930: sysdate,
3931: l_fnd_user_id,
3932: sysdate,
3933: l_fnd_user_id,
3934: l_fnd_user_id
3935: FROM pon_optimize_bid_class

Line 3933: l_fnd_user_id,

3929: bid_number,
3930: sysdate,
3931: l_fnd_user_id,
3932: sysdate,
3933: l_fnd_user_id,
3934: l_fnd_user_id
3935: FROM pon_optimize_bid_class
3936: WHERE scenario_id = p_scenario_id;
3937: END IF;

Line 3934: l_fnd_user_id

3930: sysdate,
3931: l_fnd_user_id,
3932: sysdate,
3933: l_fnd_user_id,
3934: l_fnd_user_id
3935: FROM pon_optimize_bid_class
3936: WHERE scenario_id = p_scenario_id;
3937: END IF;
3938:

Line 4255: -- as always there will be one record for an user_id in fnd_user

4251: l_person_id NUMBER;
4252:
4253: BEGIN
4254: -- This will never fail even if more than one user setup w/ same buyer
4255: -- as always there will be one record for an user_id in fnd_user
4256: SELECT PERSON_PARTY_ID INTO l_person_id
4257: FROM FND_USER
4258: WHERE user_id = p_user_id;
4259:

Line 4257: FROM FND_USER

4253: BEGIN
4254: -- This will never fail even if more than one user setup w/ same buyer
4255: -- as always there will be one record for an user_id in fnd_user
4256: SELECT PERSON_PARTY_ID INTO l_person_id
4257: FROM FND_USER
4258: WHERE user_id = p_user_id;
4259:
4260: IF (p_event = 'NOT_SHORTLIST') THEN
4261: UPDATE PON_BID_HEADERS