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_NEGOTIATION_COPY_GRP dependencies on PON_NEG_TEAM_MEMBERS

Line 572: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format

568: -- award approval is required;
569: -- Permissible values are Y or N
570: --
571: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
572: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
573: --
574: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
575: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
576: --

Line 575: -- the PON_NEG_TEAM_MEMBERS.USER_ID format

571: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
572: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
573: --
574: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
575: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
576: --
577: -- IN : p_retain_clause VARCHAR2 Required, flag to carry forward the
578: -- Contracts related information;
579: -- Permissible values are Y or N

Line 1514: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format

1510: -- award approval is required;
1511: -- Permissible values are Y or N
1512: --
1513: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
1514: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
1515: --
1516: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
1517: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
1518: --

Line 1517: -- the PON_NEG_TEAM_MEMBERS.USER_ID format

1513: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
1514: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
1515: --
1516: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
1517: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
1518: --
1519: -- IN : p_large_auction_header_id NUMBER Optional, In the case of the
1520: -- source auction being a super large one,
1521: -- non null value of this parameter

Line 7344: FROM PON_NEG_TEAM_MEMBERS PNTM,

7340: l_last_amendment_update,
7341: l_modified_flag,
7342: l_last_notif_date,
7343: l_auc_business_group_id
7344: FROM PON_NEG_TEAM_MEMBERS PNTM,
7345: FND_USER U,
7346: PER_ALL_PEOPLE_F P,
7347: PER_ALL_ASSIGNMENTS_F A,
7348: PER_ALL_POSITIONS S,

Line 7561: PON_NEG_TEAM_MEMBERS

7557: -- Insert data
7558: --
7559: FORALL x IN 1..l_user_id.COUNT
7560: INSERT INTO
7561: PON_NEG_TEAM_MEMBERS
7562: (
7563: AUCTION_HEADER_ID,
7564: LIST_ID,
7565: USER_ID,

Line 7623: FROM PON_NEG_TEAM_MEMBERS PNTM,

7619: BULK COLLECT
7620: INTO
7621: l_full_name
7622: FROM (SELECT PNTM.USER_ID, P.FULL_NAME
7623: FROM PON_NEG_TEAM_MEMBERS PNTM,
7624: FND_USER U, PER_ALL_PEOPLE_F P
7625: WHERE U.USER_ID = PNTM.USER_ID
7626: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
7627: AND PNTM.MEMBER_TYPE = 'N'

Line 7631: FROM PON_NEG_TEAM_MEMBERS PNTM,

7627: AND PNTM.MEMBER_TYPE = 'N'
7628: AND P.PERSON_ID = U.EMPLOYEE_ID
7629: MINUS
7630: SELECT PNTM.USER_ID, P.FULL_NAME
7631: FROM PON_NEG_TEAM_MEMBERS PNTM,
7632: FND_USER U, PER_ALL_PEOPLE_F P
7633: WHERE U.USER_ID = PNTM.USER_ID
7634: AND PNTM.AUCTION_HEADER_ID = p_auction_header_id
7635: AND P.PERSON_ID = U.EMPLOYEE_ID);

Line 12904: pon_neg_team_members new_collab

12900: FROM
12901: pon_scoring_team_members old_members,
12902: pon_scoring_teams old_team,
12903: pon_scoring_teams new_team,
12904: pon_neg_team_members new_collab
12905: WHERE
12906: new_team.auction_header_id = p_auction_header_id
12907: AND old_team.team_id = new_team.orig_team_id
12908: AND old_members.team_id = old_team.team_id

Line 12992: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format

12988: -- award approval is required;
12989: -- Permissible values are Y or N
12990: --
12991: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
12992: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
12993: --
12994: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
12995: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
12996: --

Line 12995: -- the PON_NEG_TEAM_MEMBERS.USER_ID format

12991: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
12992: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
12993: --
12994: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
12995: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
12996: --
12997: -- IN : p_retain_clause VARCHAR2 Required, flag to carry forward the
12998: -- Contracts related information;
12999: -- Permissible values are Y or N

Line 13235: pon_neg_team_members new_collab

13231: fnd_global.login_id
13232: FROM pon_evaluation_team_members old_members,
13233: pon_evaluation_teams old_team,
13234: pon_evaluation_teams new_team,
13235: pon_neg_team_members new_collab
13236: WHERE new_team.auction_header_id = p_auction_header_id
13237: AND old_team.team_id = new_team.orig_team_id
13238: AND old_members.team_id = old_team.team_id
13239: AND new_collab.user_id = old_members.user_id