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_CODE_ASSIGNMENTS

Line 106: FROM hz_code_assignments

102: l_yes_no VARCHAR2(10);
103:
104: CURSOR c_check_industrial_group (l_class_category VARCHAR2) IS
105: SELECT 'Y'
106: FROM hz_code_assignments
107: WHERE owner_table_name = 'HZ_CLASS_CATEGORIES'
108: AND class_category = 'CLASS_CATEGORY_GROUP'
109: AND class_code = 'INDUSTRIAL_GROUP'
110: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1)

Line 653: HZ_CODE_ASSIGNMENTS_PKG.Insert_Row (

649: END IF;
650:
651:
652:
653: HZ_CODE_ASSIGNMENTS_PKG.Insert_Row (
654: X_CODE_ASSIGNMENT_ID => p_code_assignment_rec.code_assignment_id,
655: X_OWNER_TABLE_NAME => p_code_assignment_rec.owner_table_name,
656: X_OWNER_TABLE_ID => p_code_assignment_rec.owner_table_id,
657: X_OWNER_TABLE_KEY_1 => p_code_assignment_rec.owner_table_key_1,

Line 688: ---Bug 2963010 make table HZ_CODE_ASSIGNMENTS protected by Data Security

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 :=
691: hz_dss_util_pub.test_instance(
692: p_operation_code => 'INSERT',

Line 693: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',

689: ---Check if the DSS security is granted to the user
690: l_test_security :=
691: hz_dss_util_pub.test_instance(
692: p_operation_code => 'INSERT',
693: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',
694: p_instance_pk1_value => p_code_assignment_rec.code_assignment_id,
695: p_user_name => fnd_global.user_name,
696: x_return_status => dss_return_status,
697: x_msg_count => dss_msg_count,

Line 710: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null));

706: -- Bug 3835601: replaced the dss message with a more user friendly message
707: --
708: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
709: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
710: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null));
711: FND_MSG_PUB.ADD;
712: RAISE FND_API.G_EXC_ERROR;
713: end if;
714: END IF;

Line 882: FROM hz_code_assignments

878: /*
879: CURSOR c_old_code_values(c_code_assignment_id NUMBER) IS
880: SELECT owner_table_id,owner_table_name,class_category,
881: class_code,primary_flag, start_date_active, end_date_active
882: FROM hz_code_assignments
883: WHERE code_assignment_id = c_code_assignment_id;
884: */
885:
886: CURSOR c_party_type(c_party_id NUMBER) IS

Line 898: from hz_code_assignments a

894: CURSOR c_new_denorm(p_party_id NUMBER,p_code_id NUMBER) Is
895: SELECT class_category,class_code
896: from (
897: select code_assignment_id,class_category,class_code
898: from hz_code_assignments a
899: --where class_category in ('1972 SIC','1977 SIC','1987 SIC','NAICS_1997') -- Bug 6059383
900: WHERE owner_table_id = p_party_id
901: and sysdate between start_date_active and nvl(end_date_active,sysdate+1)
902: and primary_flag='Y'

Line 905: AND EXISTS (SELECT NULL FROM hz_code_assignments b

901: and sysdate between start_date_active and nvl(end_date_active,sysdate+1)
902: and primary_flag='Y'
903: and code_assignment_id < p_code_id
904: -- Added for Bug 6059383 (remove hard coding for industrial classification)
905: AND EXISTS (SELECT NULL FROM hz_code_assignments b
906: WHERE a.class_category = b.owner_table_key_1
907: AND b.owner_table_name = 'HZ_CLASS_CATEGORIES'
908: AND b.class_category = 'CLASS_CATEGORY_GROUP'
909: AND b.class_code = 'INDUSTRIAL_GROUP'

Line 918: l_primary_flag HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE;

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:
922: l_category_code VARCHAR2(30);

Line 927: l_actual_content_src HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;

923: l_start_date DATE;
924: l_end_date DATE;
925:
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;

Line 934: l_acs HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;

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:
936: BEGIN
937:
938: -- check whether record has been updated by another user. If not, lock it.

Line 948: FROM HZ_CODE_ASSIGNMENTS

944: end_date_active,ROWID,actual_content_source
945: INTO l_object_version_number,l_owner_table_id,l_owner_table_name,
946: l_class_category,l_class_code,l_primary_flag, l_start_date,
947: l_end_date,l_rowid,l_actual_content_src
948: FROM HZ_CODE_ASSIGNMENTS
949: WHERE CODE_ASSIGNMENT_ID = p_code_assignment_rec.code_assignment_id
950: FOR UPDATE OF CODE_ASSIGNMENT_ID NOWAIT;
951:
952: IF NOT ((p_object_version_number is null and l_object_version_number is null)

Line 959: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');

955: l_object_version_number is not null and
956: p_object_version_number = l_object_version_number))
957: THEN
958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
959: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');
960: FND_MSG_PUB.ADD;
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:

Line 968: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');

964: p_object_version_number := nvl(l_object_version_number, 1) + 1;
965:
966: EXCEPTION WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
968: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
969: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END;

Line 1021: HZ_CODE_ASSIGNMENTS_PKG.Update_Row (

1017: l_acs := NULL;
1018: END IF;
1019:
1020: -- call to table-handler.
1021: HZ_CODE_ASSIGNMENTS_PKG.Update_Row (
1022: X_Rowid => l_rowid,
1023: X_CODE_ASSIGNMENT_ID => p_code_assignment_rec.code_assignment_id,
1024: X_OWNER_TABLE_NAME => p_code_assignment_rec.owner_table_name,
1025: X_OWNER_TABLE_ID => p_code_assignment_rec.owner_table_id,

Line 1878: * added in HZ_CODE_ASSIGNMENTS.

1874: *
1875: * 07-23-2001 Indrajit Sen o Created.
1876: * 01-05-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
1877: * New column ACTUAL_CONTENT_SOURCE is
1878: * added in HZ_CODE_ASSIGNMENTS.
1879: * Called HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation
1880: * to check for user creation privilege and
1881: * to ensure that proper values are set to
1882: * content_source_type / actual_content_source.

Line 1916: p_entity_name => 'HZ_CODE_ASSIGNMENTS',

1912: x_return_status := FND_API.G_RET_STS_SUCCESS;
1913:
1914: -- SSM SST Integration and Extension
1915: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
1916: p_entity_name => 'HZ_CODE_ASSIGNMENTS',
1917: p_entity_attr_id => l_entity_attr_id ,
1918: p_mixnmatch_enabled => NULL,
1919: p_selected_datasources => NULL,
1920: p_content_source_type => l_code_assignment_rec.content_source_type,

Line 1943: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(

1939: l_code_assignment_rec );
1940: END IF;
1941:
1942: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1943: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
1944: p_operation => 'I',
1945: p_code_assignment_id => x_code_assignment_id);
1946: END IF;
1947: END IF;

Line 2068: ---Bug 2963010 make table HZ_CODE_ASSIGNMENTS protected by Data Security

2064: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2066: END IF;
2067:
2068: ---Bug 2963010 make table HZ_CODE_ASSIGNMENTS protected by Data Security
2069: ---Check if the DSS security is granted to the user
2070: --
2071: -- Bug 3818648: do dss check in party context only. check dss
2072: -- profile before call test_instance.

Line 2080: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',

2076: THEN
2077: l_test_security :=
2078: hz_dss_util_pub.test_instance(
2079: p_operation_code => 'UPDATE',
2080: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',
2081: p_instance_pk1_value => l_code_assignment_rec.code_assignment_id,
2082: p_user_name => fnd_global.user_name,
2083: x_return_status => dss_return_status,
2084: x_msg_count => dss_msg_count,

Line 2097: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;

2093: -- Bug 3835601: replaced the dss message with a more user friendly message
2094: --
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2096: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2097: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_ERROR;
2099: end if;
2100: END IF;
2101:

Line 2117: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(

2113: l_old_code_assignment_rec );
2114: END IF;
2115:
2116: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2117: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
2118: p_operation => 'U',
2119: p_code_assignment_id => l_code_assignment_rec.code_assignment_id);
2120: END IF;
2121: END IF;

Line 2215: l_rec HZ_CODE_ASSIGNMENTS%ROWTYPE;

2211: x_msg_data OUT NOCOPY VARCHAR2
2212: ) IS
2213:
2214: l_count NUMBER;
2215: l_rec HZ_CODE_ASSIGNMENTS%ROWTYPE;
2216: l_code_assign_rec CODE_ASSIGNMENT_REC_TYPE;
2217:
2218: CURSOR c_code_assign(
2219: p_owner_table_name IN VARCHAR2

Line 2224: IS SELECT * FROM HZ_CODE_ASSIGNMENTS

2220: , p_owner_table_id IN NUMBER
2221: , p_class_category IN VARCHAR2
2222: , p_content_source_type IN VARCHAR2
2223: )
2224: IS SELECT * FROM HZ_CODE_ASSIGNMENTS
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

Line 2276: UPDATE HZ_CODE_ASSIGNMENTS SET

2272: IF (l_rec.PRIMARY_FLAG = 'Y' AND
2273: l_rec.class_code <> p_class_code)
2274: THEN
2275: -- terminate original primary assignment
2276: UPDATE HZ_CODE_ASSIGNMENTS SET
2277: --end_date_active = l_rec.start_date_active
2278:
2279: -- Bug 3614582 : end date with sysdate - (1 second)
2280: end_date_active = SYSDATE - 1/(24*60*60)

Line 2296: UPDATE HZ_CODE_ASSIGNMENTS SET

2292: IF (l_rec.PRIMARY_FLAG = 'N' AND
2293: l_rec.class_code = p_class_code)
2294: THEN
2295: -- terminate original non-primary assignment
2296: UPDATE HZ_CODE_ASSIGNMENTS SET
2297: --end_date_active = l_rec.start_date_active
2298: -- Bug 3614582 : end date with sysdate - (1 second)
2299: end_date_active = SYSDATE - 1/(24*60*60)
2300: WHERE code_assignment_id = l_rec.code_assignment_id;

Line 2779: FROM hz_code_assignments

2775: x_code_assignment_rec.content_source_type,
2776: x_code_assignment_rec.start_date_active,
2777: x_code_assignment_rec.end_date_active,
2778: x_code_assignment_rec.rank
2779: FROM hz_code_assignments
2780: WHERE code_assignment_id = p_code_assignment_id;
2781: END;
2782:
2783: /**

Line 3160: * HZ_CODE_ASSIGNMENTS_PKG.Select_Row

3156: * DESCRIPTION
3157: * Gets code assignment record.
3158: *
3159: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3160: * HZ_CODE_ASSIGNMENTS_PKG.Select_Row
3161: *
3162: * ARGUMENTS
3163: * IN:
3164: * p_init_msg_list Initialize message stack if it is set to

Line 3218: HZ_CODE_ASSIGNMENTS_PKG.Select_Row (

3214: END IF;
3215:
3216: x_code_assignment_rec.code_assignment_id := p_code_assignment_id;
3217:
3218: HZ_CODE_ASSIGNMENTS_PKG.Select_Row (
3219: X_CODE_ASSIGNMENT_ID => x_code_assignment_rec.code_assignment_id,
3220: X_OWNER_TABLE_NAME => x_code_assignment_rec.owner_table_name,
3221: X_OWNER_TABLE_ID => x_code_assignment_rec.owner_table_id,
3222: X_OWNER_TABLE_KEY_1 => x_code_assignment_rec.owner_table_key_1,