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.AP_VENDOR_PUB_PKG dependencies on HZ_PARTIES

Line 2676: FROM hz_parties

2672: x_valid := TRUE;
2673:
2674: SELECT party_id
2675: INTO l_dummy
2676: FROM hz_parties
2677: WHERE party_id = p_party_id;
2678:
2679:
2680: EXCEPTION

Line 3103: sync with Party Site Name of hz_parties and ap_supplier_sites

3099: END Check_org_id_name_site_code;
3100:
3101: /* udhenuko bug 7013954 added procedure
3102: This procedure is used to check if the org_id or operating_unit is in
3103: sync with Party Site Name of hz_parties and ap_supplier_sites
3104: for Supplier Site Contact Interface table*/
3105: PROCEDURE Check_org_id_party_site_name
3106: (p_org_id IN NUMBER,
3107: p_org_name IN VARCHAR2,

Line 3384: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE

3380: x_msg_count OUT NOCOPY NUMBER,
3381: x_msg_data OUT NOCOPY VARCHAR2,
3382: p_vendor_rec IN r_vendor_rec_type,
3383: x_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE,
3384: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE
3385: )
3386: IS
3387:
3388:

Line 3677: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for

3673: l_org_rec.organization_name := l_vendor_rec.vendor_name;
3674: l_org_rec.organization_name_phonetic :=
3675: l_vendor_rec.vendor_name_alt;
3676:
3677: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3678: --individual contractors and employees.
3679: --taxpayer id of individual contractors is stored only in ap_suppliers.
3680: --bug6691916.commented the below if clause and added the one below that.
3681: --as per analysis,only organization lookup code of type individual

Line 3742: l_contact_point_rec.owner_table_name := 'HZ_PARTIES' ;

3738: -- B 7831956 start ...
3739: IF l_vendor_rec.url IS NOT NULL THEN
3740:
3741: --populate contact point record
3742: l_contact_point_rec.owner_table_name := 'HZ_PARTIES' ;
3743: l_contact_point_rec.owner_table_id := l_vendor_rec.party_id ;
3744: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API' ;
3745: l_contact_point_rec.application_id := 200 ;
3746:

Line 14085: l_rel_rec.subject_table_name := 'HZ_PARTIES';

14081:
14082: l_rel_rec.end_date := l_vendor_contact_rec.inactive_date;
14083: l_rel_rec.subject_id := l_per_party_id;
14084: l_rel_rec.subject_type := 'PERSON';
14085: l_rel_rec.subject_table_name := 'HZ_PARTIES';
14086: l_rel_rec.object_id := l_org_party_id;
14087: l_rel_rec.object_type := 'ORGANIZATION';
14088: l_rel_rec.object_table_name := 'HZ_PARTIES';
14089: l_rel_rec.relationship_code := 'CONTACT_OF';

Line 14088: l_rel_rec.object_table_name := 'HZ_PARTIES';

14084: l_rel_rec.subject_type := 'PERSON';
14085: l_rel_rec.subject_table_name := 'HZ_PARTIES';
14086: l_rel_rec.object_id := l_org_party_id;
14087: l_rel_rec.object_type := 'ORGANIZATION';
14088: l_rel_rec.object_table_name := 'HZ_PARTIES';
14089: l_rel_rec.relationship_code := 'CONTACT_OF';
14090: l_rel_rec.relationship_type := 'CONTACT';
14091: l_rel_rec.start_date := sysdate;
14092: l_rel_rec.created_by_module := 'AP_SUPPLIERS_API';

Line 14284: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

14280: l_org_contact_valid <> 'F' AND
14281: l_party_site_valid <> 'F' THEN -- create contact points
14282:
14283: --populate contact point record
14284: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
14285: l_contact_point_rec.owner_table_id := l_vendor_contact_rec.rel_party_id;
14286: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
14287: l_contact_point_rec.application_id := 200;
14288:

Line 15011: l_vend_cont_last_name hz_parties.person_last_name%TYPE ;

15007: -- Bug 8557954 ...
15008: l_vend_party_id NUMBER ;
15009: l_vend_org_id NUMBER ;
15010: l_vend_cont_party_id NUMBER ;
15011: l_vend_cont_last_name hz_parties.person_last_name%TYPE ;
15012: l_combo_ct NUMBER ;
15013:
15014: BEGIN
15015:

Line 15399: from hz_parties hpc,

15395: hr.party_id
15396: into p_vendor_contact_rec.per_party_id,
15397: p_vendor_contact_rec.relationship_id,
15398: p_vendor_contact_rec.rel_party_id
15399: from hz_parties hpc,
15400: hz_contact_points hcpp,
15401: hz_contact_points hcpe,
15402: hz_relationships hr
15403: where hr.subject_id = l_vend_party_id --

Line 15404: And hcpp.owner_table_name(+) = 'HZ_PARTIES'

15400: hz_contact_points hcpp,
15401: hz_contact_points hcpe,
15402: hz_relationships hr
15403: where hr.subject_id = l_vend_party_id --
15404: And hcpp.owner_table_name(+) = 'HZ_PARTIES'
15405: And hcpp.owner_table_id(+) = hr.PARTY_ID
15406: And hcpp.phone_line_type(+) = 'GEN'
15407: And hcpp.contact_point_type(+) = 'PHONE'
15408: And hcpe.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

Line 15408: And hcpe.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

15404: And hcpp.owner_table_name(+) = 'HZ_PARTIES'
15405: And hcpp.owner_table_id(+) = hr.PARTY_ID
15406: And hcpp.phone_line_type(+) = 'GEN'
15407: And hcpp.contact_point_type(+) = 'PHONE'
15408: And hcpe.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
15409: and hcpe.OWNER_TABLE_ID(+) = hr.PARTY_ID
15410: And hcpe.CONTACT_POINT_TYPE(+) = 'EMAIL'
15411: and hr.object_id = hpc.party_id
15412: and hr.subject_type = 'ORGANIZATION'

Line 15413: and hr.subject_table_name = 'HZ_PARTIES'

15409: and hcpe.OWNER_TABLE_ID(+) = hr.PARTY_ID
15410: And hcpe.CONTACT_POINT_TYPE(+) = 'EMAIL'
15411: and hr.object_id = hpc.party_id
15412: and hr.subject_type = 'ORGANIZATION'
15413: and hr.subject_table_name = 'HZ_PARTIES'
15414: and hr.object_table_name = 'HZ_PARTIES'
15415: and hr.object_type = 'PERSON'
15416: and hr.relationship_code = 'CONTACT'
15417: and hr.directional_flag = 'B'

Line 15414: and hr.object_table_name = 'HZ_PARTIES'

15410: And hcpe.CONTACT_POINT_TYPE(+) = 'EMAIL'
15411: and hr.object_id = hpc.party_id
15412: and hr.subject_type = 'ORGANIZATION'
15413: and hr.subject_table_name = 'HZ_PARTIES'
15414: and hr.object_table_name = 'HZ_PARTIES'
15415: and hr.object_type = 'PERSON'
15416: and hr.relationship_code = 'CONTACT'
15417: and hr.directional_flag = 'B'
15418: and hr.relationship_type = 'CONTACT'