APPS.PON_SOURCING_OPENAPI_GRP dependencies on FND_USER

Line 511: select fnd_user.employee_id

507:
508: -- copy any contracts from Blanket onto the new Document
509: if (pon_conterms_utl_pvt.is_contracts_installed() = 'T') then
510: begin
511: select fnd_user.employee_id
512: into v_auc_contact_id
513: from
514: fnd_user,
515: hz_relationships

Line 514: fnd_user,

510: begin
511: select fnd_user.employee_id
512: into v_auc_contact_id
513: from
514: fnd_user,
515: hz_relationships
516: where
517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id

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

513: from
514: fnd_user,
515: hz_relationships
516: where
517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'

Line 519: and hz_relationships.subject_id = fnd_user.person_party_id

515: hz_relationships
516: where
517: fnd_user.user_id = fnd_global.user_id()
518: and hz_relationships.object_id = v_site_id
519: and hz_relationships.subject_id = fnd_user.person_party_id
520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE
523: and hz_relationships.end_date >= SYSDATE

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

520: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
521: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
522: and hz_relationships.start_date <= SYSDATE
523: and hz_relationships.end_date >= SYSDATE
524: and nvl(fnd_user.end_date,sysdate) >= sysdate;
525: exception
526: when others then
527: v_auc_contact_id := null;
528: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

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

527: v_auc_contact_id := null;
528: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
529: fnd_log.string(fnd_log.level_statement,
530: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface',
531: 'Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
532: end if;
533: end;
534:
535: v_contracts_doctype := pon_conterms_utl_pvt.get_negotiation_doc_type(v_doctype_id);

Line 2732: FROM fnd_user

2728: AND status = 'A'
2729: AND ROWNUM = 1;
2730:
2731: SELECT user_name INTO x_trading_partner_contact_name
2732: FROM fnd_user
2733: WHERE person_party_id = x_trading_partner_contact_id
2734: AND nvl(fnd_user.end_date,sysdate) >= sysdate;
2735:
2736: EXCEPTION

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

2730:
2731: SELECT user_name INTO x_trading_partner_contact_name
2732: FROM fnd_user
2733: WHERE person_party_id = x_trading_partner_contact_id
2734: AND nvl(fnd_user.end_date,sysdate) >= sysdate;
2735:
2736: EXCEPTION
2737:
2738: WHEN too_many_rows THEN

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

2738: WHEN too_many_rows THEN
2739: IF ( FND_LOG.level_error >= fnd_log.g_current_runtime_level) then
2740: FND_LOG.string(log_level => FND_LOG.level_error,
2741: module => ' get_trading_partner_info ',
2742: message => ' Error while fetching UserName from fnd_user '|| SQLERRM);
2743: END IF;
2744:
2745: SELECT user_name
2746: INTO x_trading_partner_contact_name

Line 2747: FROM fnd_user

2743: END IF;
2744:
2745: SELECT user_name
2746: INTO x_trading_partner_contact_name
2747: FROM fnd_user
2748: WHERE person_party_id = x_trading_partner_contact_id
2749: AND nvl(end_date,sysdate) >= sysdate
2750: AND ROWNUM = 1;
2751: RETURN;