APPS.PON_SOURCING_OPENAPI_GRP dependencies on FND_USER

Line 472: select fnd_user.employee_id

468:
469: -- copy any contracts from Blanket onto the new Document
470: if (pon_conterms_utl_pvt.is_contracts_installed() = 'T') then
471: begin
472: select fnd_user.employee_id
473: into v_auc_contact_id
474: from
475: fnd_user,
476: hz_relationships

Line 475: fnd_user,

471: begin
472: select fnd_user.employee_id
473: into v_auc_contact_id
474: from
475: fnd_user,
476: hz_relationships
477: where
478: fnd_user.user_id = fnd_global.user_id()
479: and hz_relationships.object_id = v_site_id

Line 478: fnd_user.user_id = fnd_global.user_id()

474: from
475: fnd_user,
476: hz_relationships
477: where
478: fnd_user.user_id = fnd_global.user_id()
479: and hz_relationships.object_id = v_site_id
480: and hz_relationships.subject_id = fnd_user.person_party_id
481: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
482: and hz_relationships.relationship_code = 'EMPLOYEE_OF'

Line 480: and hz_relationships.subject_id = fnd_user.person_party_id

476: hz_relationships
477: where
478: fnd_user.user_id = fnd_global.user_id()
479: and hz_relationships.object_id = v_site_id
480: and hz_relationships.subject_id = fnd_user.person_party_id
481: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
482: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
483: and hz_relationships.start_date <= SYSDATE
484: and hz_relationships.end_date >= SYSDATE

Line 485: and nvl(fnd_user.end_date,sysdate) >= sysdate;

481: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
482: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
483: and hz_relationships.start_date <= SYSDATE
484: and hz_relationships.end_date >= SYSDATE
485: and nvl(fnd_user.end_date,sysdate) >= sysdate;
486: exception
487: when others then
488: v_auc_contact_id := null;
489: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 492: 'Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());

488: v_auc_contact_id := null;
489: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
490: fnd_log.string(fnd_log.level_statement,
491: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',
492: 'Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
493: end if;
494: end;
495:
496: v_contracts_doctype := pon_conterms_utl_pvt.get_negotiation_doc_type(v_doctype_id);

Line 2247: FROM fnd_user

2243: AND status = 'A'
2244: AND ROWNUM = 1;
2245:
2246: SELECT user_name INTO x_trading_partner_contact_name
2247: FROM fnd_user
2248: WHERE person_party_id = x_trading_partner_contact_id
2249: AND nvl(fnd_user.end_date,sysdate) >= sysdate;
2250:
2251: EXCEPTION

Line 2249: AND nvl(fnd_user.end_date,sysdate) >= sysdate;

2245:
2246: SELECT user_name INTO x_trading_partner_contact_name
2247: FROM fnd_user
2248: WHERE person_party_id = x_trading_partner_contact_id
2249: AND nvl(fnd_user.end_date,sysdate) >= sysdate;
2250:
2251: EXCEPTION
2252:
2253: WHEN too_many_rows THEN

Line 2257: message => ' Error while fetching UserName from fnd_user '|| SQLERRM);

2253: WHEN too_many_rows THEN
2254: IF ( FND_LOG.level_error >= fnd_log.g_current_runtime_level) then
2255: FND_LOG.string(log_level => FND_LOG.level_error,
2256: module => ' get_trading_partner_info ',
2257: message => ' Error while fetching UserName from fnd_user '|| SQLERRM);
2258: END IF;
2259:
2260: SELECT user_name
2261: INTO x_trading_partner_contact_name

Line 2262: FROM fnd_user

2258: END IF;
2259:
2260: SELECT user_name
2261: INTO x_trading_partner_contact_name
2262: FROM fnd_user
2263: WHERE person_party_id = x_trading_partner_contact_id
2264: AND nvl(end_date,sysdate) >= sysdate
2265: AND ROWNUM = 1;
2266: RETURN;