APPS.HZ_CLASSIFICATION_V2PUB dependencies on HZ_PARTY_V2PUB

Line 586: l_organization_rec hz_party_v2pub.organization_rec_type;

582:
583: l_object_version_number NUMBER;
584: l_organization_name VARCHAR2(360);
585: x_profile_id NUMBER;
586: l_organization_rec hz_party_v2pub.organization_rec_type;
587: l_party_rec hz_party_v2pub.party_rec_type;
588:
589: --Bug No: 3216842
590:

Line 587: l_party_rec hz_party_v2pub.party_rec_type;

583: l_object_version_number NUMBER;
584: l_organization_name VARCHAR2(360);
585: x_profile_id NUMBER;
586: l_organization_rec hz_party_v2pub.organization_rec_type;
587: l_party_rec hz_party_v2pub.party_rec_type;
588:
589: --Bug No: 3216842
590:
591: CURSOR c_party_type(c_party_id NUMBER) IS

Line 763: HZ_PARTY_V2PUB.update_organization(

759: l_organization_rec.actual_content_source:=p_code_assignment_rec.actual_content_source;
760:
761: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES
762:
763: HZ_PARTY_V2PUB.update_organization(
764: 'T',
765: l_organization_rec,
766: l_object_version_number,
767: x_profile_id,

Line 861: l_organization_rec hz_party_v2pub.organization_rec_type;

857: x_profile_id NUMBER;
858: dss_msg_count NUMBER := 0;
859: dss_msg_data VARCHAR2(2000):= null;
860:
861: l_organization_rec hz_party_v2pub.organization_rec_type;
862: l_party_rec hz_party_v2pub.party_rec_type;
863:
864: --Commented code for Bug No. 4091181.
865: --Bug No: 3216842

Line 862: l_party_rec hz_party_v2pub.party_rec_type;

858: dss_msg_count NUMBER := 0;
859: dss_msg_data VARCHAR2(2000):= null;
860:
861: l_organization_rec hz_party_v2pub.organization_rec_type;
862: l_party_rec hz_party_v2pub.party_rec_type;
863:
864: --Commented code for Bug No. 4091181.
865: --Bug No: 3216842
866: /*

Line 1087: HZ_PARTY_V2PUB.update_organization(

1083: l_organization_rec.actual_content_source:=l_actual_content_src;
1084:
1085: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES
1086:
1087: HZ_PARTY_V2PUB.update_organization(
1088: 'T',
1089: l_organization_rec,
1090: l_object_version_number,
1091: x_profile_id,

Line 1137: HZ_PARTY_V2PUB.update_organization(

1133: l_organization_rec.actual_content_source:=l_actual_content_src;
1134:
1135: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES
1136:
1137: HZ_PARTY_V2PUB.update_organization(
1138: 'T',
1139: l_organization_rec,
1140: l_object_version_number,
1141: x_profile_id,

Line 2203: actual_content_source = NVL(p_content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE) AND

2199: WHERE
2200: owner_table_name = p_owner_table_name AND
2201: owner_table_id = p_owner_table_id AND
2202: class_category = p_class_category AND
2203: actual_content_source = NVL(p_content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE) AND
2204: (end_date_active is null
2205: OR sysdate between start_date_active and end_date_active);
2206:
2207: --FOR UPDATE OF end_date_active;