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

Line 563: | HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party

559: | May-29-2003 The API needs to be protected by Data security Bug 2963010
560: | Sep-09-2003 Rajib Ranjan Borah o The API defaults the value of content_source_type
561: | to 'USER_ENTERED'.Bug Number -2824772.
562: | 20-Nov-2003 Ramesh Ch Bug No: 3216842. Denormalized SIC_CODE and SIC_CODE_TYPE columns into
563: | HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party
564: | primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
565: | class category type.
566: | 05-Jan-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
567: | Passed the value of actual_content_source to

Line 594: FROM HZ_PARTIES

590:
591: CURSOR c_party_type(c_party_id NUMBER) IS
592: SELECT party_type,object_version_number,
593: sic_code_type,sic_code /* Bug 4156312 */
594: FROM HZ_PARTIES
595: WHERE party_id=c_party_id;
596:
597: l_party_type HZ_PARTIES.party_type%TYPE :=NULL;
598:

Line 597: l_party_type HZ_PARTIES.party_type%TYPE :=NULL;

593: sic_code_type,sic_code /* Bug 4156312 */
594: FROM HZ_PARTIES
595: WHERE party_id=c_party_id;
596:
597: l_party_type HZ_PARTIES.party_type%TYPE :=NULL;
598:
599: -- End Of 3216842.
600:
601: -- Bug 4156312

Line 602: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;

598:
599: -- End Of 3216842.
600:
601: -- Bug 4156312
602: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;
603: l_sic_code HZ_PARTIES.sic_code%TYPE;
604:
605:
606: BEGIN

Line 603: l_sic_code HZ_PARTIES.sic_code%TYPE;

599: -- End Of 3216842.
600:
601: -- Bug 4156312
602: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;
603: l_sic_code HZ_PARTIES.sic_code%TYPE;
604:
605:
606: BEGIN
607:

Line 679: -- IS FOR HZ_PARTIES. IN OTHER WORDS, THE CODE ASSIGNMENT IS

675: );
676:
677: -- VJN INTRODUCED CHANGE
678: -- THE CALL OUT TO DSS SHOULD HAPPEN ONLY IF THE CODE ASSIGNMENT
679: -- IS FOR HZ_PARTIES. IN OTHER WORDS, THE CODE ASSIGNMENT IS
680: -- SECURED ONLY AT THE PARTY LEVEL AND NOT THE DETAILS.
681: --
682: -- Bug 3818648: do dss check in party context only. check dss
683: -- profile before call test_instance.

Line 686: p_code_assignment_rec.owner_table_name = 'HZ_PARTIES'

682: -- Bug 3818648: do dss check in party context only. check dss
683: -- profile before call test_instance.
684: --
685: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
686: p_code_assignment_rec.owner_table_name = 'HZ_PARTIES'
687: THEN
688: ---Bug 2963010 make table HZ_CODE_ASSIGNMENTS protected by Data Security
689: ---Check if the DSS security is granted to the user
690: l_test_security :=

Line 718: -- HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party

714: END IF;
715:
716:
717: -- Bug No: 4091181. Modified logic to denormalize SIC_CODE and SIC_CODE_TYPE to
718: -- HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party
719: -- Primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
720: -- class category type.
721: IF UPPER(p_code_assignment_rec.owner_table_name) = 'HZ_PARTIES'
722: AND

Line 721: IF UPPER(p_code_assignment_rec.owner_table_name) = 'HZ_PARTIES'

717: -- Bug No: 4091181. Modified logic to denormalize SIC_CODE and SIC_CODE_TYPE to
718: -- HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party
719: -- Primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
720: -- class category type.
721: IF UPPER(p_code_assignment_rec.owner_table_name) = 'HZ_PARTIES'
722: AND
723: -- Bug 6059383 : Denormalize for all industrial class and not only the hard coded values
724: -- p_code_assignment_rec.class_category in ('1972 SIC' , '1977 SIC' , '1987 SIC' , 'NAICS_1997')
725: is_industrial_class(p_code_assignment_rec.class_category) = 'Y'

Line 761: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES

757: l_organization_rec.party_rec := l_party_rec;
758:
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,

Line 779: -- class category to HZ_PARTIES

775: END IF;
776: END IF;
777:
778: -- Bug 4091181. Modified logic to denormalize class code for 'CUSTOMER_CATEGORY'
779: -- class category to HZ_PARTIES
780:
781: IF UPPER(p_code_assignment_rec.owner_table_name) = 'HZ_PARTIES'
782: AND
783: p_code_assignment_rec.class_category='CUSTOMER_CATEGORY'

Line 781: IF UPPER(p_code_assignment_rec.owner_table_name) = 'HZ_PARTIES'

777:
778: -- Bug 4091181. Modified logic to denormalize class code for 'CUSTOMER_CATEGORY'
779: -- class category to HZ_PARTIES
780:
781: IF UPPER(p_code_assignment_rec.owner_table_name) = 'HZ_PARTIES'
782: AND
783: p_code_assignment_rec.class_category='CUSTOMER_CATEGORY'
784: THEN
785: IF

Line 796: update hz_parties

792: OR p_code_assignment_rec.end_date_active=fnd_api.g_miss_date
793: OR p_code_assignment_rec.end_date_active>sysdate
794: )
795: THEN
796: update hz_parties
797: set category_code = p_code_assignment_rec.class_code,
798: last_update_date = hz_utility_v2pub.last_update_date,
799: last_updated_by = hz_utility_v2pub.last_updated_by,
800: last_update_login = hz_utility_v2pub.last_update_login

Line 835: | HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party

831: |
832: | MODIFICATION HISTORY
833: |
834: | 20-Nov-2003 Ramesh Ch Bug No: 3216842. Denormalized SIC_CODE and SIC_CODE_TYPE columns into
835: | HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party
836: | primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
837: | class category type.
838: | 05-Jan-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
839: | Passed the value of actual_content_source to

Line 877: FROM HZ_PARTIES

873:
874: CURSOR c_party_type(c_party_id NUMBER) IS
875: SELECT party_type,object_version_number,
876: sic_code_type,sic_code /* Bug 4156312 */
877: FROM HZ_PARTIES
878: WHERE party_id=c_party_id;
879:
880:
881: -- Bug 4059298.

Line 905: l_party_type HZ_PARTIES.party_type%TYPE;

901: order by code_assignment_id desc
902: )
903: where rownum=1;
904:
905: l_party_type HZ_PARTIES.party_type%TYPE;
906: l_primary_flag HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE;
907: l_denorm_flag BOOLEAN :=FALSE;
908: -- End Of 3216842.
909:

Line 918: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;

914: -- Bug 4091181
915: l_actual_content_src HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;
916:
917: -- Bug 4156312
918: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;
919: l_sic_code HZ_PARTIES.sic_code%TYPE;
920:
921: -- Bug 4693719 : Added for local assignment
922: l_acs HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;

Line 919: l_sic_code HZ_PARTIES.sic_code%TYPE;

915: l_actual_content_src HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;
916:
917: -- Bug 4156312
918: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;
919: l_sic_code HZ_PARTIES.sic_code%TYPE;
920:
921: -- Bug 4693719 : Added for local assignment
922: l_acs HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;
923:

Line 1036: -- HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party

1032: X_ACTUAL_CONTENT_SOURCE => l_acs
1033: );
1034:
1035: -- Bug No: 4091181. Modified logic to denormalize SIC_CODE and SIC_CODE_TYPE to
1036: -- HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party
1037: -- Primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
1038: -- class category type.
1039:
1040:

Line 1041: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'

1037: -- Primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
1038: -- class category type.
1039:
1040:
1041: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'
1042: AND
1043: -- Bug 6059383 : Denormalize for all industrial class and not only the hard coded values
1044: -- nvl(p_code_assignment_rec.class_category,l_class_category)
1045: -- in ('1972 SIC' , '1977 SIC' , '1987 SIC' , 'NAICS_1997')

Line 1085: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES

1081: l_organization_rec.party_rec := l_party_rec;
1082:
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,

Line 1135: --Call to Update organization to update both HZ_PARTIES AND HZ_ORGANIZATION_PROFILES

1131: l_organization_rec.party_rec := l_party_rec;
1132:
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,

Line 1154: -- class category to HZ_PARTIES

1150: END IF;
1151:
1152:
1153: -- Bug 4091181. Modified logic to denormalize class code for 'CUSTOMER_CATEGORY'
1154: -- class category to HZ_PARTIES
1155:
1156: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'
1157: AND
1158: nvl(p_code_assignment_rec.class_category,l_class_category)='CUSTOMER_CATEGORY'

Line 1156: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'

1152:
1153: -- Bug 4091181. Modified logic to denormalize class code for 'CUSTOMER_CATEGORY'
1154: -- class category to HZ_PARTIES
1155:
1156: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'
1157: AND
1158: nvl(p_code_assignment_rec.class_category,l_class_category)='CUSTOMER_CATEGORY'
1159: THEN
1160: IF

Line 1176: UPDATE HZ_PARTIES

1172: )
1173: OR (p_code_assignment_rec.primary_flag='N' AND l_primary_flag='Y')
1174: THEN
1175: -- terminating
1176: UPDATE HZ_PARTIES
1177: SET CATEGORY_CODE = NULL,
1178: last_update_date = hz_utility_v2pub.last_update_date,
1179: last_updated_by = hz_utility_v2pub.last_updated_by,
1180: last_update_login = hz_utility_v2pub.last_update_login

Line 1194: update hz_parties

1190: OR nvl(p_code_assignment_rec.end_date_active,l_end_date)=fnd_api.g_miss_date
1191: OR nvl(p_code_assignment_rec.end_date_active,l_end_date)>sysdate
1192: )
1193: THEN
1194: update hz_parties
1195: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1196: last_update_date = hz_utility_v2pub.last_update_date,
1197: last_updated_by = hz_utility_v2pub.last_updated_by,
1198: last_update_login = hz_utility_v2pub.last_update_login

Line 2049: l_old_code_assignment_rec.owner_table_name = 'HZ_PARTIES'

2045: -- Bug 3818648: do dss check in party context only. check dss
2046: -- profile before call test_instance.
2047: --
2048: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
2049: l_old_code_assignment_rec.owner_table_name = 'HZ_PARTIES'
2050: THEN
2051: l_test_security :=
2052: hz_dss_util_pub.test_instance(
2053: p_operation_code => 'UPDATE',