APPS.PON_AUCTION_APPROVAL_PKG dependencies on PON_NEG_TEAM_MEMBERS

Line 41: from pon_neg_team_members

37: begin
38: select count(auction_header_id),
39: nvl(sum(decode(approval_status,'APPROVED',1,0)),0)
40: into l_approval_count,l_approved_count
41: from pon_neg_team_members
42: where auction_header_id = p_auction_header_id
43: and approver_flag='Y';
44: if l_approval_count =0 then
45: l_auction_approval_status := 'NOT_REQUIRED';

Line 125: from pon_neg_team_members neg, pon_auction_headers_all auc

121:
122: select neg.approver_flag, neg.approval_status, auc.approval_status,
123: wf_approval_item_key
124: into l_user_approval,l_user_status,l_auction_status,l_parent_process_itemKey
125: from pon_neg_team_members neg, pon_auction_headers_all auc
126: where auc.auction_header_id = p_auction_header_id
127: and neg.auction_header_id= auc.auction_header_id
128: and neg.user_id = l_user_id;
129:

Line 131: update pon_neg_team_members

127: and neg.auction_header_id= auc.auction_header_id
128: and neg.user_id = l_user_id;
129:
130: -- update user as not an approver
131: update pon_neg_team_members
132: set approver_flag ='N'
133: where auction_header_id = p_auction_header_id
134: and user_id = l_user_id;
135: l_itemKey := l_parent_process_itemKey || '_' || l_user_id;

Line 181: from pon_neg_team_members neg, pon_auction_headers_all auc

177: begin
178: select neg.approver_flag, neg.approval_status, auc.approval_status,
179: wf_approval_item_key
180: into l_user_approval,l_user_status,l_auction_status,l_itemKey
181: from pon_neg_team_members neg, pon_auction_headers_all auc
182: where auc.auction_header_id = p_auction_header_id
183: and neg.auction_header_id= auc.auction_header_id
184: and neg.user_id = l_user_id;
185:

Line 667: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u

663: trading_partner_contact_id auction_contact_id,
664: nvl(auc.publish_auction_now_flag,'N') publish_auction_now_flag,
665: nvl(auc.open_auction_now_flag,'N') open_auction_now_flag,
666: auc.auction_header_id_orig_amend
667: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u
668: where neg.auction_header_id = auc.auction_header_id and
669: auc.auction_header_id = p_auction_header_id
670: and neg.APPROVER_FLAG ='Y'
671: and u.user_id = neg.user_id;

Line 1026: pon_neg_team_members neg

1022: begin
1023: select 'Y'
1024: into l_result
1025: from pon_auction_headers_all auc,
1026: pon_neg_team_members neg
1027: where auc.auction_header_id = neg.auction_header_id
1028: and auc.auction_header_id = p_auction_header_id
1029: and auc.approval_status = 'INPROCESS'
1030: and neg.user_id = p_user_id

Line 1427: Update pon_neg_team_members

1423: begin
1424:
1425: if p_upd_history_type = 'USER' then
1426: if (p_status <> 'SUBMIT') then
1427: Update pon_neg_team_members
1428: set approval_status = decode(p_status,'APPROVE','APPROVED','REJECT','REJECTED',p_status)
1429: where auction_header_id = p_auction_header_id
1430: and user_id = p_user_id;
1431: end if;