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 FND_USER

Line 1191: l_user_id FND_USER.USER_ID%TYPE;

1187:
1188: c_interface_neg_team_rec c_interface_neg_team%ROWTYPE;
1189: l_LAST_AMENDMENT_UPDATE PON_AUCTION_ATTRIBUTES.LAST_AMENDMENT_UPDATE%TYPE;
1190: l_NEG_TEAM_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.NEG_TEAM_ENABLED_FLAG%TYPE;
1191: l_user_id FND_USER.USER_ID%TYPE;
1192: l_check VARCHAR2(20);
1193: BEGIN
1194: print_log('Entering procedure create_neg_team');
1195: OPEN c_interface_neg_team;

Line 1220: FROM fnd_user

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
1221: WHERE user_name LIKE Upper(c_interface_neg_team_rec.user_name)
1222: )
1223: AND MEMBER_TYPE='N';
1224:

Line 1274: l_user_name fnd_user.USER_NAME%TYPE;

1270: l_business_group_id PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE;
1271: l_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;
1272: l_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1273: l_position PER_ALL_POSITIONS.name%TYPE;
1274: l_user_name fnd_user.USER_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;

Line 1275: l_user_id fnd_user.USER_ID%TYPE;

1271: l_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;
1272: l_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1273: l_position PER_ALL_POSITIONS.name%TYPE;
1274: l_user_name fnd_user.USER_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;

Line 1276: l_employee_id fnd_user.EMPLOYEE_ID%TYPE;

1272: l_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1273: l_position PER_ALL_POSITIONS.name%TYPE;
1274: l_user_name fnd_user.USER_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;

Line 1277: l_user_start_date fnd_user.START_DATE%TYPE;

1273: l_position PER_ALL_POSITIONS.name%TYPE;
1274: l_user_name fnd_user.USER_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;

Line 1278: l_user_end_date fnd_user.END_DATE%TYPE;

1274: l_user_name fnd_user.USER_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;

Line 1289: lm_user_name fnd_user.USER_NAME%TYPE;

1285: lm_business_group_id PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE;
1286: lm_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;
1287: lm_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1288: lm_position PER_ALL_POSITIONS.name%TYPE;
1289: lm_user_name fnd_user.USER_NAME%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;

Line 1290: lm_user_id fnd_user.USER_ID%TYPE;

1286: lm_effective_start_date PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;
1287: lm_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1288: lm_position PER_ALL_POSITIONS.name%TYPE;
1289: lm_user_name fnd_user.USER_NAME%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;

Line 1291: lm_employee_id fnd_user.EMPLOYEE_ID%TYPE;

1287: lm_effective_end_date PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;
1288: lm_position PER_ALL_POSITIONS.name%TYPE;
1289: lm_user_name fnd_user.USER_NAME%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;

Line 1292: lm_user_start_date fnd_user.START_DATE%TYPE;

1288: lm_position PER_ALL_POSITIONS.name%TYPE;
1289: lm_user_name fnd_user.USER_NAME%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

Line 1293: lm_user_end_date fnd_user.END_DATE%TYPE;

1289: lm_user_name fnd_user.USER_NAME%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;

Line 1315: FND_USER EMP ,

1311: l_user_name ,
1312: l_user_id ,
1313: l_employee_id
1314: FROM PER_ALL_ASSIGNMENTS_F ASS,
1315: FND_USER EMP ,
1316: PER_ALL_PEOPLE_F PER ,
1317: PER_ALL_POSITIONS POS ,
1318: PON_AUCTION_HEADERS_ALL PAH ,
1319: FINANCIALS_SYSTEM_PARAMS_ALL FSP

Line 1369: FND_USER SUP ,

1365: lm_user_id ,
1366: lm_employee_id
1367: FROM PER_ALL_ASSIGNMENTS_F ASS,
1368: PER_ALL_ASSIGNMENTS_F SUPASS ,
1369: FND_USER SUP ,
1370: FND_USER EMP ,
1371: PER_ALL_PEOPLE_F PER ,
1372: PER_ALL_POSITIONS POS
1373: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID

Line 1370: FND_USER EMP ,

1366: lm_employee_id
1367: FROM PER_ALL_ASSIGNMENTS_F ASS,
1368: PER_ALL_ASSIGNMENTS_F SUPASS ,
1369: FND_USER SUP ,
1370: FND_USER EMP ,
1371: PER_ALL_PEOPLE_F PER ,
1372: PER_ALL_POSITIONS POS
1373: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID
1374: AND ASS.SUPERVISOR_ID = SUP.EMPLOYEE_ID

Line 1434: fnd_user users ,

1430: INTO l_user_id
1431: FROM
1432: (SELECT users.user_id
1433: FROM pon_employees_current_v emp,
1434: fnd_user users ,
1435: hr_all_organization_units_tl orgs
1436: WHERE emp.person_id = users.employee_id
1437: AND users.start_date <= SYSDATE
1438: AND NVL(users.end_date, SYSDATE) >= SYSDATE

Line 2174: g_user_id fnd_user.user_id%type;

2170: x_result VARCHAR2(1);
2171: x_error_code VARCHAR2(10);
2172: x_error_message VARCHAR2(50);
2173: l_doctype_id pon_auction_headers_all.doctype_id%type;
2174: g_user_id fnd_user.user_id%type;
2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;
2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;

Line 4940: l_tpc_id fnd_user.user_id%TYPE;

4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4940: l_tpc_id fnd_user.user_id%TYPE;
4941: l_tpc_name fnd_user.user_Name%TYPE;
4942:
4943: l_dummy_data VARCHAR2(100);
4944: l_extra_info VARCHAR2(100);

Line 4941: l_tpc_name fnd_user.user_Name%TYPE;

4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4940: l_tpc_id fnd_user.user_id%TYPE;
4941: l_tpc_name fnd_user.user_Name%TYPE;
4942:
4943: l_dummy_data VARCHAR2(100);
4944: l_extra_info VARCHAR2(100);
4945: l_row_in_hr VARCHAR2(100);

Line 4968: FROM fnd_user

4964: SELECT DOCTYPE_ID INTO rfi_doctype_id FROM pon_auc_doctypes WHERE INTERNAL_NAME='REQUEST_FOR_INFORMATION';
4965:
4966: BEGIN
4967: SELECT user_id INTO l_tpc_id
4968: FROM fnd_user
4969: WHERE user_Name = l_tpc_name
4970: AND Nvl(end_date,SYSDATE + 1) > sysdate;
4971:
4972: pon_sourcing_user_manager_pkg.validate_user_data(l_tpc_name,

Line 6317: FROM fnd_user usr,pon_auction_headers_interface pahi

6313: END IF;
6314:
6315: SELECT person_party_id,user_name
6316: INTO neg_header_record_data.trading_partner_contact_id,neg_header_record_data.trading_partner_contact_name
6317: FROM fnd_user usr,pon_auction_headers_interface pahi
6318: WHERE batch_id = p_batch_id
6319: AND usr.user_name = pahi.trading_partner_contact_name
6320: AND Nvl(usr.end_date,SYSDATE + 1) > SYSDATE ;
6321:

Line 7093: l_username fnd_user.user_name%TYPE;

7089: x_msg_data IN OUT NOCOPY varchar2)
7090: IS
7091: l_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7092: l_tpc_name pon_auction_headers_all.trading_partner_contact_name%TYPE;
7093: l_username fnd_user.user_name%TYPE;
7094: l_mgr_id fnd_user.user_id%TYPE;
7095: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
7096: P_ERROR_CODE VARCHAR2(50);
7097: P_ERROR_MESSAGE VARCHAR2(50);

Line 7094: l_mgr_id fnd_user.user_id%TYPE;

7090: IS
7091: l_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7092: l_tpc_name pon_auction_headers_all.trading_partner_contact_name%TYPE;
7093: l_username fnd_user.user_name%TYPE;
7094: l_mgr_id fnd_user.user_id%TYPE;
7095: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
7096: P_ERROR_CODE VARCHAR2(50);
7097: P_ERROR_MESSAGE VARCHAR2(50);
7098: o_auction_header_id NUMBER;

Line 7151: FND_USER SUP ,

7147: SELECT DISTINCT EMP.USER_NAME, emp.person_party_id, SUP.USER_ID
7148: INTO l_username, l_tpc_id, l_mgr_id
7149: FROM PER_ALL_ASSIGNMENTS_F ASS,
7150: PER_ALL_ASSIGNMENTS_F SUPASS ,
7151: FND_USER SUP ,
7152: FND_USER EMP ,
7153: PER_ALL_PEOPLE_F PER ,
7154: PER_ALL_POSITIONS POS
7155: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID

Line 7152: FND_USER EMP ,

7148: INTO l_username, l_tpc_id, l_mgr_id
7149: FROM PER_ALL_ASSIGNMENTS_F ASS,
7150: PER_ALL_ASSIGNMENTS_F SUPASS ,
7151: FND_USER SUP ,
7152: FND_USER EMP ,
7153: PER_ALL_PEOPLE_F PER ,
7154: PER_ALL_POSITIONS POS
7155: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID
7156: AND ASS.SUPERVISOR_ID = SUP.EMPLOYEE_ID

Line 7371: l_username fnd_user.user_name%TYPE;

7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;
7371: l_username fnd_user.user_name%TYPE;
7372: P_ERROR_CODE VARCHAR2(50);
7373: P_ERROR_MESSAGE VARCHAR2(50);
7374: l_check VARCHAR(1);
7375: DRAFT_AMENDMENT_COUNT NUMBER;

Line 7432: SELECT user_name INTO l_username FROM fnd_user WHERE user_id = p_tpc_id;

7428:
7429: IF (DRAFT_AMENDMENT_COUNT >0) THEN
7430: RETURN FALSE;
7431: END IF;
7432: SELECT user_name INTO l_username FROM fnd_user WHERE user_id = p_tpc_id;
7433:
7434: if (p_tpc_id = l_auc_tpc_id) then
7435: return true;
7436: END IF;