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 2484: l_fnd_user_id NUMBER;

2480: x_status OUT NOCOPY VARCHAR2
2481: )
2482: IS
2483:
2484: l_fnd_user_id NUMBER;
2485: l_next_scenario_number NUMBER;
2486: l_num_constraints NUMBER;
2487: l_num_bid_classes NUMBER;
2488: l_auction_header_id NUMBER;

Line 2494: -- Derive fnd_user_id from tp_id

2490: l_new_scenario_id NUMBER;
2491:
2492: BEGIN
2493:
2494: -- Derive fnd_user_id from tp_id
2495: -- This will not fail if more than one user setup w/ same buyer.
2496: -- But, this will reurn any of the matched user id in such cases
2497: BEGIN
2498: SELECT USER_ID

Line 2499: INTO l_fnd_user_id

2495: -- This will not fail if more than one user setup w/ same buyer.
2496: -- But, this will reurn any of the matched user id in such cases
2497: BEGIN
2498: SELECT USER_ID
2499: INTO l_fnd_user_id
2500: FROM FND_USER
2501: WHERE PERSON_PARTY_ID = p_user_id
2502: AND NVL(END_DATE,SYSDATE+1) > SYSDATE;
2503: EXCEPTION

Line 2500: FROM FND_USER

2496: -- But, this will reurn any of the matched user id in such cases
2497: BEGIN
2498: SELECT USER_ID
2499: INTO l_fnd_user_id
2500: FROM FND_USER
2501: WHERE PERSON_PARTY_ID = p_user_id
2502: AND NVL(END_DATE,SYSDATE+1) > SYSDATE;
2503: EXCEPTION
2504: WHEN TOO_MANY_ROWS THEN

Line 2514: INTO l_fnd_user_id

2510: END IF;
2511: END IF;
2512:
2513: SELECT USER_ID
2514: INTO l_fnd_user_id
2515: FROM FND_USER
2516: WHERE PERSON_PARTY_ID = p_user_id
2517: AND NVL(END_DATE,SYSDATE+1) > SYSDATE
2518: AND ROWNUM = 1;

Line 2515: FROM FND_USER

2511: END IF;
2512:
2513: SELECT USER_ID
2514: INTO l_fnd_user_id
2515: FROM FND_USER
2516: WHERE PERSON_PARTY_ID = p_user_id
2517: AND NVL(END_DATE,SYSDATE+1) > SYSDATE
2518: AND ROWNUM = 1;
2519: END;

Line 2576: l_fnd_user_id,

2572: internal_note,
2573: p_user_id,
2574: sysdate,
2575: sysdate,
2576: l_fnd_user_id,
2577: sysdate,
2578: l_fnd_user_id,
2579: l_fnd_user_id,
2580: p_cost_scenario_flag,

Line 2578: l_fnd_user_id,

2574: sysdate,
2575: sysdate,
2576: l_fnd_user_id,
2577: sysdate,
2578: l_fnd_user_id,
2579: l_fnd_user_id,
2580: p_cost_scenario_flag,
2581: decode(p_cost_scenario_flag, 'Y', p_scenario_id, to_number(null)),
2582: nvl(constraint_priority_type, 'MANDATORY')

Line 2579: l_fnd_user_id,

2575: sysdate,
2576: l_fnd_user_id,
2577: sysdate,
2578: l_fnd_user_id,
2579: l_fnd_user_id,
2580: p_cost_scenario_flag,
2581: decode(p_cost_scenario_flag, 'Y', p_scenario_id, to_number(null)),
2582: nvl(constraint_priority_type, 'MANDATORY')
2583: FROM pon_optimize_scenarios

Line 2677: l_fnd_user_id,

2673: trading_partner_id,
2674: trading_partner_contact_id,
2675: vendor_site_id,
2676: sysdate,
2677: l_fnd_user_id,
2678: sysdate,
2679: l_fnd_user_id,
2680: l_fnd_user_id,
2681: MIN_MAX_AMOUNT_PRIORITY

Line 2679: l_fnd_user_id,

2675: vendor_site_id,
2676: sysdate,
2677: l_fnd_user_id,
2678: sysdate,
2679: l_fnd_user_id,
2680: l_fnd_user_id,
2681: MIN_MAX_AMOUNT_PRIORITY
2682: ,TO_NUMBER(NULL)
2683: ,TO_CHAR(NULL)

Line 2680: l_fnd_user_id,

2676: sysdate,
2677: l_fnd_user_id,
2678: sysdate,
2679: l_fnd_user_id,
2680: l_fnd_user_id,
2681: MIN_MAX_AMOUNT_PRIORITY
2682: ,TO_NUMBER(NULL)
2683: ,TO_CHAR(NULL)
2684: ,MIN_MAX_QUANTITY_PRIORITY

Line 2734: l_fnd_user_id,

2730: SELECT l_new_scenario_id,
2731: sequence_number,
2732: bid_number,
2733: sysdate,
2734: l_fnd_user_id,
2735: sysdate,
2736: l_fnd_user_id,
2737: l_fnd_user_id
2738: FROM pon_optimize_bid_class

Line 2736: l_fnd_user_id,

2732: bid_number,
2733: sysdate,
2734: l_fnd_user_id,
2735: sysdate,
2736: l_fnd_user_id,
2737: l_fnd_user_id
2738: FROM pon_optimize_bid_class
2739: WHERE scenario_id = p_scenario_id;
2740: END IF;

Line 2737: l_fnd_user_id

2733: sysdate,
2734: l_fnd_user_id,
2735: sysdate,
2736: l_fnd_user_id,
2737: l_fnd_user_id
2738: FROM pon_optimize_bid_class
2739: WHERE scenario_id = p_scenario_id;
2740: END IF;
2741:

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

3054: l_person_id NUMBER;
3055:
3056: BEGIN
3057: -- This will never fail even if more than one user setup w/ same buyer
3058: -- as always there will be one record for an user_id in fnd_user
3059: SELECT PERSON_PARTY_ID INTO l_person_id
3060: FROM FND_USER
3061: WHERE user_id = p_user_id;
3062:

Line 3060: FROM FND_USER

3056: BEGIN
3057: -- This will never fail even if more than one user setup w/ same buyer
3058: -- as always there will be one record for an user_id in fnd_user
3059: SELECT PERSON_PARTY_ID INTO l_person_id
3060: FROM FND_USER
3061: WHERE user_id = p_user_id;
3062:
3063: IF (p_event = 'NOT_SHORTLIST') THEN
3064: UPDATE PON_BID_HEADERS