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 847: | HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party

843: |
844: | MODIFICATION HISTORY
845: |
846: | 20-Nov-2003 Ramesh Ch Bug No: 3216842. Denormalized SIC_CODE and SIC_CODE_TYPE columns into
847: | HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party
848: | primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
849: | class category type.
850: | 05-Jan-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
851: | Passed the value of actual_content_source to

Line 889: FROM HZ_PARTIES

885:
886: CURSOR c_party_type(c_party_id NUMBER) IS
887: SELECT party_type,object_version_number,
888: sic_code_type,sic_code /* Bug 4156312 */
889: FROM HZ_PARTIES
890: WHERE party_id=c_party_id;
891:
892:
893: -- Bug 4059298.

Line 917: l_party_type HZ_PARTIES.party_type%TYPE;

913: order by code_assignment_id desc
914: )
915: where rownum=1;
916:
917: l_party_type HZ_PARTIES.party_type%TYPE;
918: l_primary_flag HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE;
919: l_denorm_flag BOOLEAN :=FALSE;
920: -- End Of 3216842.
921:

Line 930: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;

926: -- Bug 4091181
927: l_actual_content_src HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;
928:
929: -- Bug 4156312
930: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;
931: l_sic_code HZ_PARTIES.sic_code%TYPE;
932:
933: -- Bug 4693719 : Added for local assignment
934: l_acs HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;

Line 931: l_sic_code HZ_PARTIES.sic_code%TYPE;

927: l_actual_content_src HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;
928:
929: -- Bug 4156312
930: l_sic_code_type HZ_PARTIES.sic_code_type%TYPE;
931: l_sic_code HZ_PARTIES.sic_code%TYPE;
932:
933: -- Bug 4693719 : Added for local assignment
934: l_acs HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;
935:

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

1044: X_ACTUAL_CONTENT_SOURCE => l_acs
1045: );
1046:
1047: -- Bug No: 4091181. Modified logic to denormalize SIC_CODE and SIC_CODE_TYPE to
1048: -- HZ_PARTIES and HZ_ORGANIZATION_PROFILES tables for ORGANIZATION party
1049: -- Primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
1050: -- class category type.
1051:
1052:

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

1049: -- Primary code assignments of 1972 SIC,1977 SIC,1987 SIC and NAICS_1997
1050: -- class category type.
1051:
1052:
1053: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'
1054: AND
1055: -- Bug 6059383 : Denormalize for all industrial class and not only the hard coded values
1056: -- nvl(p_code_assignment_rec.class_category,l_class_category)
1057: -- in ('1972 SIC' , '1977 SIC' , '1987 SIC' , 'NAICS_1997')

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

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

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

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

Line 1166: -- class category to HZ_PARTIES

1162: END IF;
1163:
1164:
1165: -- Bug 4091181. Modified logic to denormalize class code for 'CUSTOMER_CATEGORY'
1166: -- class category to HZ_PARTIES
1167:
1168: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'
1169: AND
1170: nvl(p_code_assignment_rec.class_category,l_class_category)='CUSTOMER_CATEGORY'

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

1164:
1165: -- Bug 4091181. Modified logic to denormalize class code for 'CUSTOMER_CATEGORY'
1166: -- class category to HZ_PARTIES
1167:
1168: IF UPPER(nvl(p_code_assignment_rec.owner_table_name,l_owner_table_name)) = 'HZ_PARTIES'
1169: AND
1170: nvl(p_code_assignment_rec.class_category,l_class_category)='CUSTOMER_CATEGORY'
1171: THEN
1172: IF

Line 1188: UPDATE HZ_PARTIES

1184: )
1185: OR (p_code_assignment_rec.primary_flag='N' AND l_primary_flag='Y')
1186: THEN
1187: -- terminating
1188: UPDATE HZ_PARTIES
1189: SET CATEGORY_CODE = NULL,
1190: last_update_date = hz_utility_v2pub.last_update_date,
1191: last_updated_by = hz_utility_v2pub.last_updated_by,
1192: last_update_login = hz_utility_v2pub.last_update_login

Line 1206: update hz_parties

1202: OR nvl(p_code_assignment_rec.end_date_active,l_end_date)=fnd_api.g_miss_date
1203: OR nvl(p_code_assignment_rec.end_date_active,l_end_date)>sysdate
1204: )
1205: THEN
1206: update hz_parties
1207: set category_code = nvl(p_code_assignment_rec.class_code,l_class_code),
1208: last_update_date = hz_utility_v2pub.last_update_date,
1209: last_updated_by = hz_utility_v2pub.last_updated_by,
1210: last_update_login = hz_utility_v2pub.last_update_login

Line 2075: l_old_code_assignment_rec.owner_table_name = 'HZ_PARTIES'

2071: -- Bug 3818648: do dss check in party context only. check dss
2072: -- profile before call test_instance.
2073: --
2074: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
2075: l_old_code_assignment_rec.owner_table_name = 'HZ_PARTIES'
2076: THEN
2077: l_test_security :=
2078: hz_dss_util_pub.test_instance(
2079: p_operation_code => 'UPDATE',