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 873: l_organization_rec hz_party_v2pub.organization_rec_type;

869: x_profile_id NUMBER;
870: dss_msg_count NUMBER := 0;
871: dss_msg_data VARCHAR2(2000):= null;
872:
873: l_organization_rec hz_party_v2pub.organization_rec_type;
874: l_party_rec hz_party_v2pub.party_rec_type;
875:
876: --Commented code for Bug No. 4091181.
877: --Bug No: 3216842

Line 874: l_party_rec hz_party_v2pub.party_rec_type;

870: dss_msg_count NUMBER := 0;
871: dss_msg_data VARCHAR2(2000):= null;
872:
873: l_organization_rec hz_party_v2pub.organization_rec_type;
874: l_party_rec hz_party_v2pub.party_rec_type;
875:
876: --Commented code for Bug No. 4091181.
877: --Bug No: 3216842
878: /*

Line 1099: HZ_PARTY_V2PUB.update_organization(

1095: l_organization_rec.actual_content_source:=l_actual_content_src;
1096:
1097: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES
1098:
1099: HZ_PARTY_V2PUB.update_organization(
1100: 'T',
1101: l_organization_rec,
1102: l_object_version_number,
1103: x_profile_id,

Line 1149: HZ_PARTY_V2PUB.update_organization(

1145: l_organization_rec.actual_content_source:=l_actual_content_src;
1146:
1147: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES
1148:
1149: HZ_PARTY_V2PUB.update_organization(
1150: 'T',
1151: l_organization_rec,
1152: l_object_version_number,
1153: x_profile_id,

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

2225: WHERE
2226: owner_table_name = p_owner_table_name AND
2227: owner_table_id = p_owner_table_id AND
2228: class_category = p_class_category AND
2229: actual_content_source = NVL(p_content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE) AND
2230: (end_date_active is null
2231: OR sysdate between start_date_active and end_date_active);
2232:
2233: --FOR UPDATE OF end_date_active;