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

Line 1161: --Description : Warpper on PON APIs to copy the data from PON_NEG_TEAM_INTERFACE interface table to PON_NEG_TEAM_MEMBERS

1157: END;
1158: -----------------------------------------------------------------------
1159: --Start of Comments
1160: --Name: create_neg_team
1161: --Description : Warpper on PON APIs to copy the data from PON_NEG_TEAM_INTERFACE interface table to PON_NEG_TEAM_MEMBERS
1162: --Parameters:
1163: --IN:
1164: -- p_api_version
1165: -- p_init_msg_list

Line 1216: FROM PON_NEG_TEAM_MEMBERS

1212: END IF;
1213: IF(c_interface_neg_team_rec.ACTION='DELETE') THEN
1214: print_log('In delete condition');
1215: DELETE
1216: FROM PON_NEG_TEAM_MEMBERS
1217: WHERE AUCTION_HEADER_ID = c_interface_neg_team_rec.auction_header_id
1218: AND USER_ID =
1219: (SELECT USER_ID
1220: FROM fnd_user

Line 1240: --Description : Warpper on PON APIs to insert the colloboration team members PON_NEG_TEAM_MEMBERS

1236: END;
1237: -----------------------------------------------------------------------
1238: --Start of Comments
1239: --Name: create_members_in_collteam
1240: --Description : Warpper on PON APIs to insert the colloboration team members PON_NEG_TEAM_MEMBERS
1241: --Parameters:
1242: --IN:
1243: -- p_api_version
1244: -- p_init_msg_list

Line 1279: l_menu_name PON_NEG_TEAM_MEMBERS.menu_name%TYPE;

1275: l_user_id fnd_user.USER_ID%TYPE;
1276: l_employee_id fnd_user.EMPLOYEE_ID%TYPE;
1277: l_user_start_date fnd_user.START_DATE%TYPE;
1278: l_user_end_date fnd_user.END_DATE%TYPE;
1279: l_menu_name PON_NEG_TEAM_MEMBERS.menu_name%TYPE;
1280: l_member_type PON_NEG_TEAM_MEMBERS.member_type%TYPE;
1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;
1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;

Line 1280: l_member_type PON_NEG_TEAM_MEMBERS.member_type%TYPE;

1276: l_employee_id fnd_user.EMPLOYEE_ID%TYPE;
1277: l_user_start_date fnd_user.START_DATE%TYPE;
1278: l_user_end_date fnd_user.END_DATE%TYPE;
1279: l_menu_name PON_NEG_TEAM_MEMBERS.menu_name%TYPE;
1280: l_member_type PON_NEG_TEAM_MEMBERS.member_type%TYPE;
1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;
1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
1284: lm_person_id PER_ALL_PEOPLE_F.person_id%TYPE;

Line 1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;

1277: l_user_start_date fnd_user.START_DATE%TYPE;
1278: l_user_end_date fnd_user.END_DATE%TYPE;
1279: l_menu_name PON_NEG_TEAM_MEMBERS.menu_name%TYPE;
1280: l_member_type PON_NEG_TEAM_MEMBERS.member_type%TYPE;
1281: l_approver_flag PON_NEG_TEAM_MEMBERS.approver_flag%TYPE;
1282: lm_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1283: lm_employee_number PER_ALL_PEOPLE_F.employee_number%TYPE;
1284: lm_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
1285: lm_business_group_id PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE;

Line 1294: l_auction_header_id PON_NEG_TEAM_MEMBERS.auction_header_id%TYPE;

1290: lm_user_id fnd_user.USER_ID%TYPE;
1291: lm_employee_id fnd_user.EMPLOYEE_ID%TYPE;
1292: lm_user_start_date fnd_user.START_DATE%TYPE;
1293: lm_user_end_date fnd_user.END_DATE%TYPE;
1294: l_auction_header_id PON_NEG_TEAM_MEMBERS.auction_header_id%TYPE;
1295: l_neg_team_enabled_flag pon_auction_headers_all.NEG_TEAM_ENABLED_FLAG%TYPE;
1296: BEGIN
1297: l_auction_header_id:=auction_header_id;
1298: print_log('create_members_in_collteam begin: auction_header_id ' || auction_header_id || ' username ' || username);

Line 1492: FROM PON_NEG_TEAM_MEMBERS pnt

1488: l_count1 NUMBER := 0;
1489: BEGIN
1490: SELECT COUNT(*)
1491: INTO l_count
1492: FROM PON_NEG_TEAM_MEMBERS pnt
1493: WHERE pnt.auction_header_id = p_auction_header_id
1494: AND pnt.list_id = -1
1495: AND pnt.user_id = p_user_id;
1496: IF (l_count > 0 ) THEN

Line 1504: FROM PON_NEG_TEAM_MEMBERS pnt

1500: END IF;
1501: IF (NVL(ispreparer,'N') = 'Y') THEN
1502: SELECT COUNT(*)
1503: INTO l_count1
1504: FROM PON_NEG_TEAM_MEMBERS pnt
1505: WHERE pnt.auction_header_id = p_auction_header_id
1506: AND PNT.LIST_ID = -1
1507: AND member_type = 'C';
1508: IF (l_count > 0 ) THEN

Line 1536: INTO PON_NEG_TEAM_MEMBERS

1532: IS
1533: l_user_id NUMBER;
1534: BEGIN
1535: INSERT
1536: INTO PON_NEG_TEAM_MEMBERS
1537: (
1538: auction_header_id,
1539: list_id ,
1540: user_name ,

Line 3838: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;

3834: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
3835: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
3837: DELETE FROM pon_auc_payments_shipments WHERE auction_header_id = l_auction_header_id;
3838: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
3839: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
3840: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
3841: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
3842: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;

Line 5319: EXISTS(SELECT 1 FROM pon_neg_team_members

5315: BEGIN
5316: SELECT 'Y' INTO approval_required_flag
5317: FROM dual
5318: WHERE
5319: EXISTS(SELECT 1 FROM pon_neg_team_members
5320: WHERE auctioN_header_id = neg_header_record_data.auction_header_id
5321: and approver_flag = 'Y');
5322: EXCEPTION
5323: WHEN OTHERS THEN

Line 7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;

7050: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
7056: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
7057: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
7058: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;

Line 7439: SELECT 'Y' INTO l_check FROM pon_neg_team_members WHERE MENU_NAME='PON_SOURCING_EDITNEG' AND user_name = l_username AND auction_header_id=p_auction_header_id ;

7435: return true;
7436: END IF;
7437: if (g_trading_partner_id = l_auc_tp_id) then
7438: BEGIN
7439: SELECT 'Y' INTO l_check FROM pon_neg_team_members WHERE MENU_NAME='PON_SOURCING_EDITNEG' AND user_name = l_username AND auction_header_id=p_auction_header_id ;
7440: EXCEPTION
7441: WHEN No_Data_Found THEN
7442: l_check:=NULL;
7443: END;

Line 7449: SELECT 'Y' INTO l_check FROM pon_neg_team_members WHERE user_name = l_username AND auction_header_id=p_auction_header_id ;

7445: RETURN TRUE;
7446: END IF;
7447:
7448: BEGIN
7449: SELECT 'Y' INTO l_check FROM pon_neg_team_members WHERE user_name = l_username AND auction_header_id=p_auction_header_id ;
7450: EXCEPTION
7451: WHEN No_Data_Found THEN
7452: l_check:=NULL;
7453: END;