APPS.PON_AUCTION_PKG dependencies on PON_NEG_TEAM_MEMBERS

Line 9491: from pon_neg_team_members

9487: BEGIN
9488: v_member_type := 'X';
9489: select nvl(member_type,'X')
9490: into v_member_type
9491: from pon_neg_team_members
9492: where auction_header_id =p_auction_header_id
9493: and user_id = p_user_id;
9494:
9495: return v_member_type;

Line 9822: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;

9818: l_preview_date DATE;
9819: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
9820: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9821: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
9822: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
9823: l_task_target_date DATE;
9824: l_task_assignment_date DATE;
9825: l_task_assigned_subject VARCHAR2(2000);
9826: l_timezone_disp VARCHAR2(240);

Line 9896: pon_neg_team_members pntm,

9892: l_publish_auction_now_flag
9893:
9894: from pon_auction_headers_all auh,
9895: hz_parties hz,
9896: pon_neg_team_members pntm,
9897: fnd_user fu,
9898: pon_auc_doctypes pad
9899: where auh.auction_header_id = p_auction_header_id
9900: AND hz.party_id = auh.trading_partner_id

Line 10153: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;

10149: l_preview_date DATE;
10150: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10151: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10152: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10153: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10154: l_task_target_date DATE;
10155: l_task_completion_date DATE;
10156: l_task_completed_subject VARCHAR2(2000);
10157: l_timezone_disp VARCHAR2(240);

Line 10308: pon_neg_team_members pntm,

10304: l_task_target_date,
10305: l_task_completion_date,
10306: l_user_name
10307: from hz_parties hz,
10308: pon_neg_team_members pntm,
10309: fnd_user fu
10310: where pntm.auction_header_id = p_auction_header_id
10311: AND hz.party_id = l_trading_partner_id
10312: AND pntm.user_id = p_user_id

Line 11002: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;

10998: l_subject PON_THREADS.SUBJECT%TYPE;
10999: l_sender_name VARCHAR2(350);
11000: l_recipient_name VARCHAR2(350);
11001: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11002: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
11003: l_task_target_date DATE;
11004: l_task_assignment_date DATE;
11005: l_msg_sent_subject VARCHAR2(2000);
11006: l_timezone_disp VARCHAR2(240);

Line 11038: FROM pon_neg_team_members pntm,

11034: hz.party_id TO_PARTY_ID,
11035: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11036: hz.person_first_name FIRST_NAME,
11037: hz.person_last_name LAST_NAME
11038: FROM pon_neg_team_members pntm,
11039: HZ_PARTIES hz,
11040: fnd_user fu
11041: WHERE hz.party_id=fu.person_party_id
11042: AND nvl(fu.end_date,sysdate+1) > sysdate