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 870: FROM hz_code_assignments

866: /*
867: CURSOR c_old_code_values(c_code_assignment_id NUMBER) IS
868: SELECT owner_table_id,owner_table_name,class_category,
869: class_code,primary_flag, start_date_active, end_date_active
870: FROM hz_code_assignments
871: WHERE code_assignment_id = c_code_assignment_id;
872: */
873:
874: CURSOR c_party_type(c_party_id NUMBER) IS

Line 886: from hz_code_assignments a

882: CURSOR c_new_denorm(p_party_id NUMBER,p_code_id NUMBER) Is
883: SELECT class_category,class_code
884: from (
885: select code_assignment_id,class_category,class_code
886: from hz_code_assignments a
887: --where class_category in ('1972 SIC','1977 SIC','1987 SIC','NAICS_1997') -- Bug 6059383
888: WHERE owner_table_id = p_party_id
889: and sysdate between start_date_active and nvl(end_date_active,sysdate+1)
890: and primary_flag='Y'

Line 893: AND EXISTS (SELECT NULL FROM hz_code_assignments b

889: and sysdate between start_date_active and nvl(end_date_active,sysdate+1)
890: and primary_flag='Y'
891: and code_assignment_id < p_code_id
892: -- Added for Bug 6059383 (remove hard coding for industrial classification)
893: AND EXISTS (SELECT NULL FROM hz_code_assignments b
894: WHERE a.class_category = b.owner_table_key_1
895: AND b.owner_table_name = 'HZ_CLASS_CATEGORIES'
896: AND b.class_category = 'CLASS_CATEGORY_GROUP'
897: AND b.class_code = 'INDUSTRIAL_GROUP'

Line 906: l_primary_flag HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE;

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

Line 915: l_actual_content_src HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;

911: l_start_date DATE;
912: l_end_date DATE;
913:
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;

Line 922: l_acs HZ_CODE_ASSIGNMENTS.actual_content_source%TYPE;

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

Line 936: FROM HZ_CODE_ASSIGNMENTS

932: end_date_active,ROWID,actual_content_source
933: INTO l_object_version_number,l_owner_table_id,l_owner_table_name,
934: l_class_category,l_class_code,l_primary_flag, l_start_date,
935: l_end_date,l_rowid,l_actual_content_src
936: FROM HZ_CODE_ASSIGNMENTS
937: WHERE CODE_ASSIGNMENT_ID = p_code_assignment_rec.code_assignment_id
938: FOR UPDATE OF CODE_ASSIGNMENT_ID NOWAIT;
939:
940: IF NOT ((p_object_version_number is null and l_object_version_number is null)

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

943: l_object_version_number is not null and
944: p_object_version_number = l_object_version_number))
945: THEN
946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
947: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;
951:

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

952: p_object_version_number := nvl(l_object_version_number, 1) + 1;
953:
954: EXCEPTION WHEN NO_DATA_FOUND THEN
955: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
956: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
957: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
958: FND_MSG_PUB.ADD;
959: RAISE FND_API.G_EXC_ERROR;
960: END;

Line 1009: HZ_CODE_ASSIGNMENTS_PKG.Update_Row (

1005: l_acs := NULL;
1006: END IF;
1007:
1008: -- call to table-handler.
1009: HZ_CODE_ASSIGNMENTS_PKG.Update_Row (
1010: X_Rowid => l_rowid,
1011: X_CODE_ASSIGNMENT_ID => p_code_assignment_rec.code_assignment_id,
1012: X_OWNER_TABLE_NAME => p_code_assignment_rec.owner_table_name,
1013: X_OWNER_TABLE_ID => p_code_assignment_rec.owner_table_id,

Line 1852: * added in HZ_CODE_ASSIGNMENTS.

1848: *
1849: * 07-23-2001 Indrajit Sen o Created.
1850: * 01-05-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
1851: * New column ACTUAL_CONTENT_SOURCE is
1852: * added in HZ_CODE_ASSIGNMENTS.
1853: * Called HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation
1854: * to check for user creation privilege and
1855: * to ensure that proper values are set to
1856: * content_source_type / actual_content_source.

Line 1890: p_entity_name => 'HZ_CODE_ASSIGNMENTS',

1886: x_return_status := FND_API.G_RET_STS_SUCCESS;
1887:
1888: -- SSM SST Integration and Extension
1889: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
1890: p_entity_name => 'HZ_CODE_ASSIGNMENTS',
1891: p_entity_attr_id => l_entity_attr_id ,
1892: p_mixnmatch_enabled => NULL,
1893: p_selected_datasources => NULL,
1894: p_content_source_type => l_code_assignment_rec.content_source_type,

Line 1917: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(

1913: l_code_assignment_rec );
1914: END IF;
1915:
1916: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1917: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
1918: p_operation => 'I',
1919: p_code_assignment_id => x_code_assignment_id);
1920: END IF;
1921: END IF;

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

2038: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2040: END IF;
2041:
2042: ---Bug 2963010 make table HZ_CODE_ASSIGNMENTS protected by Data Security
2043: ---Check if the DSS security is granted to the user
2044: --
2045: -- Bug 3818648: do dss check in party context only. check dss
2046: -- profile before call test_instance.

Line 2054: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',

2050: THEN
2051: l_test_security :=
2052: hz_dss_util_pub.test_instance(
2053: p_operation_code => 'UPDATE',
2054: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',
2055: p_instance_pk1_value => l_code_assignment_rec.code_assignment_id,
2056: p_user_name => fnd_global.user_name,
2057: x_return_status => dss_return_status,
2058: x_msg_count => dss_msg_count,

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

2067: -- Bug 3835601: replaced the dss message with a more user friendly message
2068: --
2069: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2070: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2071: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;
2072: RAISE FND_API.G_EXC_ERROR;
2073: end if;
2074: END IF;
2075:

Line 2091: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(

2087: l_old_code_assignment_rec );
2088: END IF;
2089:
2090: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2091: HZ_POPULATE_BOT_PKG.pop_hz_code_assignments(
2092: p_operation => 'U',
2093: p_code_assignment_id => l_code_assignment_rec.code_assignment_id);
2094: END IF;
2095: END IF;

Line 2189: l_rec HZ_CODE_ASSIGNMENTS%ROWTYPE;

2185: x_msg_data OUT NOCOPY VARCHAR2
2186: ) IS
2187:
2188: l_count NUMBER;
2189: l_rec HZ_CODE_ASSIGNMENTS%ROWTYPE;
2190: l_code_assign_rec CODE_ASSIGNMENT_REC_TYPE;
2191:
2192: CURSOR c_code_assign(
2193: p_owner_table_name IN VARCHAR2

Line 2198: IS SELECT * FROM HZ_CODE_ASSIGNMENTS

2194: , p_owner_table_id IN NUMBER
2195: , p_class_category IN VARCHAR2
2196: , p_content_source_type IN VARCHAR2
2197: )
2198: IS SELECT * FROM HZ_CODE_ASSIGNMENTS
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

Line 2250: UPDATE HZ_CODE_ASSIGNMENTS SET

2246: IF (l_rec.PRIMARY_FLAG = 'Y' AND
2247: l_rec.class_code <> p_class_code)
2248: THEN
2249: -- terminate original primary assignment
2250: UPDATE HZ_CODE_ASSIGNMENTS SET
2251: --end_date_active = l_rec.start_date_active
2252:
2253: -- Bug 3614582 : end date with sysdate - (1 second)
2254: end_date_active = SYSDATE - 1/(24*60*60)

Line 2270: UPDATE HZ_CODE_ASSIGNMENTS SET

2266: IF (l_rec.PRIMARY_FLAG = 'N' AND
2267: l_rec.class_code = p_class_code)
2268: THEN
2269: -- terminate original non-primary assignment
2270: UPDATE HZ_CODE_ASSIGNMENTS SET
2271: --end_date_active = l_rec.start_date_active
2272: -- Bug 3614582 : end date with sysdate - (1 second)
2273: end_date_active = SYSDATE - 1/(24*60*60)
2274: WHERE code_assignment_id = l_rec.code_assignment_id;

Line 2753: FROM hz_code_assignments

2749: x_code_assignment_rec.content_source_type,
2750: x_code_assignment_rec.start_date_active,
2751: x_code_assignment_rec.end_date_active,
2752: x_code_assignment_rec.rank
2753: FROM hz_code_assignments
2754: WHERE code_assignment_id = p_code_assignment_id;
2755: END;
2756:
2757: /**

Line 3134: * HZ_CODE_ASSIGNMENTS_PKG.Select_Row

3130: * DESCRIPTION
3131: * Gets code assignment record.
3132: *
3133: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3134: * HZ_CODE_ASSIGNMENTS_PKG.Select_Row
3135: *
3136: * ARGUMENTS
3137: * IN:
3138: * p_init_msg_list Initialize message stack if it is set to

Line 3192: HZ_CODE_ASSIGNMENTS_PKG.Select_Row (

3188: END IF;
3189:
3190: x_code_assignment_rec.code_assignment_id := p_code_assignment_id;
3191:
3192: HZ_CODE_ASSIGNMENTS_PKG.Select_Row (
3193: X_CODE_ASSIGNMENT_ID => x_code_assignment_rec.code_assignment_id,
3194: X_OWNER_TABLE_NAME => x_code_assignment_rec.owner_table_name,
3195: X_OWNER_TABLE_ID => x_code_assignment_rec.owner_table_id,
3196: X_OWNER_TABLE_KEY_1 => x_code_assignment_rec.owner_table_key_1,