APPS.PON_AUCTION_APPROVAL_PKG dependencies on PON_NEG_TEAM_MEMBERS

Line 137: from pon_neg_team_members

133: begin
134: select count(auction_header_id),
135: nvl(sum(decode(approval_status,'APPROVED',1,0)),0)
136: into l_approval_count,l_approved_count
137: from pon_neg_team_members
138: where auction_header_id = p_auction_header_id
139: --FOR ERIC TEST ONLY,BEGIN
140: ---------------------------------------------------------
141: --and approver_flag='Y';

Line 251: from pon_neg_team_members neg, pon_auction_headers_all auc

247:
248: select neg.approver_flag, neg.approval_status, auc.approval_status,
249: wf_approval_item_key
250: into l_user_approval,l_user_status,l_auction_status,l_parent_process_itemKey
251: from pon_neg_team_members neg, pon_auction_headers_all auc
252: where auc.auction_header_id = p_auction_header_id
253: and neg.auction_header_id= auc.auction_header_id
254: and neg.user_id = l_user_id;
255:

Line 257: update pon_neg_team_members

253: and neg.auction_header_id= auc.auction_header_id
254: and neg.user_id = l_user_id;
255:
256: -- update user as not an approver
257: update pon_neg_team_members
258: set approver_flag ='N'
259: where auction_header_id = p_auction_header_id
260: and user_id = l_user_id;
261: l_itemKey := l_parent_process_itemKey || '_' || l_user_id;

Line 313: from pon_neg_team_members neg, pon_auction_headers_all auc

309: begin
310: select neg.approver_flag, neg.approval_status, auc.approval_status,
311: wf_approval_item_key
312: into l_user_approval,l_user_status,l_auction_status,l_itemKey
313: from pon_neg_team_members neg, pon_auction_headers_all auc
314: where auc.auction_header_id = p_auction_header_id
315: and neg.auction_header_id= auc.auction_header_id
316: and neg.user_id = l_user_id;
317:

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

877: trading_partner_contact_id auction_contact_id,
878: nvl(auc.publish_auction_now_flag,'N') publish_auction_now_flag,
879: nvl(auc.open_auction_now_flag,'N') open_auction_now_flag,
880: auc.auction_header_id_orig_amend
881: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u
882: where neg.auction_header_id = auc.auction_header_id and
883: auc.auction_header_id = p_auction_header_id
884: and neg.APPROVER_FLAG ='Y'
885: AND neg.MENU_NAME <> 'EMD_ADMIN' --FOR ERIC TEST ONLY

Line 1291: , pon_neg_team_members neg

1287: SELECT 'Y'
1288: INTO l_result
1289: FROM
1290: pon_auction_headers_all auc
1291: , pon_neg_team_members neg
1292: WHERE auc.auction_header_id = neg.auction_header_id
1293: AND auc.auction_header_id = p_auction_header_id
1294: AND auc.approval_status = 'INPROCESS'
1295: AND neg.user_id = p_user_id

Line 1314: pon_neg_team_members neg

1310: begin
1311: select 'Y'
1312: into l_result
1313: from pon_auction_headers_all auc,
1314: pon_neg_team_members neg
1315: where auc.auction_header_id = neg.auction_header_id
1316: and auc.auction_header_id = p_auction_header_id
1317: and auc.approval_status = 'INPROCESS'
1318: and neg.user_id = p_user_id

Line 1910: Update pon_neg_team_members

1906:
1907: if p_upd_history_type = 'USER' then
1908: --INSERT INTO ERIC_LOG VALUES ('ENTER USER Branch','','','','','','',''); --for eric test only
1909: if (p_status <> 'SUBMIT') then
1910: Update pon_neg_team_members
1911: set approval_status = decode(p_status,'APPROVE','APPROVED','REJECT','REJECTED',p_status)
1912: where auction_header_id = p_auction_header_id
1913: and user_id = p_user_id
1914: AND approver_flag = 'Y' -- for eric test only

Line 1918: --INSERT INTO ERIC_LOG VALUES (i ||'row(s) has been updated in pon_neg_team_members','','','','','','',''); --for eric test only

1914: AND approver_flag = 'Y' -- for eric test only
1915: AND MENU_NAME<>'EMD_ADMIN'; -- for eric test only
1916:
1917: i:=SQL%ROWCOUNT ;-- for eric test only
1918: --INSERT INTO ERIC_LOG VALUES (i ||'row(s) has been updated in pon_neg_team_members','','','','','','',''); --for eric test only
1919: end if;
1920:
1921: insert into pon_action_history
1922: (object_id,

Line 1952: UPDATE pon_neg_team_members

1948:
1949:
1950: IF (p_status <> 'SUBMIT')
1951: THEN
1952: UPDATE pon_neg_team_members
1953: SET approval_status = decode(p_status
1954: ,'APPROVE'
1955: ,'APPROVED'
1956: ,'REJECT'

Line 1966: --INSERT INTO ERIC_LOG VALUES (i ||'row(s) has been updated in pon_neg_team_members','','','','','','',''); --for eric test only

1962: AND MENU_NAME='EMD_ADMIN'
1963: AND approver_flag = 'Y';
1964:
1965: i:=SQL%ROWCOUNT ;-- for eric test only
1966: --INSERT INTO ERIC_LOG VALUES (i ||'row(s) has been updated in pon_neg_team_members','','','','','','',''); --for eric test only
1967: END IF;
1968:
1969: INSERT INTO pon_action_history
1970: (object_id

Line 2180: pon_neg_team_members neg

2176: , nvl(auc.publish_auction_now_flag ,'N') publish_auction_now_flag
2177: , nvl(auc.open_auction_now_flag,'N') open_auction_now_flag
2178: , auc.auction_header_id_orig_amend
2179: FROM
2180: pon_neg_team_members neg
2181: , pon_auction_headers_all auc
2182: , fnd_user u
2183: WHERE neg.auction_header_id = auc.auction_header_id
2184: AND auc.auction_header_id = p_auction_header_id