DBA Data[Home] [Help]

APPS.HZ_CLASS_VALIDATE_V2PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 572: FROM hz_code_assignments a,

568: IS
569: CURSOR c1
570: IS
571: SELECT 'Y'
572: FROM hz_code_assignments a,
573: hz_class_code_relations b
574: WHERE a.class_category = p_class_category
575: AND b.class_category = p_class_category
576: AND a.class_code = b.class_code

Line 747: FROM hz_code_assignments ca, fnd_lookup_values_vl lv

743: IS
744: SELECT DISTINCT actual_content_source,
745: owner_table_name,
746: owner_table_id
747: FROM hz_code_assignments ca, fnd_lookup_values_vl lv
748: WHERE ca.class_category = p_class_category
749: AND ca.class_category = lv.lookup_type
750: AND ca.class_code = lv.lookup_code;
751:

Line 757: FROM hz_code_assignments

753: IS
754: SELECT class_code,
755: start_date_active,
756: end_date_active
757: FROM hz_code_assignments
758: WHERE class_category = p_class_category
759: AND actual_content_source = l_content_source_type
760: AND owner_table_name = l_owner_table_name
761: AND owner_table_id = l_owner_table_id;

Line 1388: FROM hz_code_assignments

1384: IS
1385: SELECT class_code,
1386: start_date_active,
1387: end_date_active
1388: FROM hz_code_assignments
1389: WHERE owner_table_name = p_owner_table_name
1390: AND owner_table_id = p_owner_table_id
1391: AND class_category = p_class_category
1392: AND actual_content_source = p_content_source_type

Line 1623: FROM hz_code_assignments

1619: cursor c0
1620: is
1621: SELECT code_assignment_id,
1622: end_date_active
1623: FROM hz_code_assignments
1624: WHERE owner_table_name = p_owner_table_name
1625: AND owner_table_id = p_owner_table_id
1626: AND class_category = p_class_category
1627: AND class_code = p_class_code

Line 1664: FROM hz_code_assignments

1660: is
1661: SELECT class_code,
1662: start_date_active,
1663: end_date_active
1664: FROM hz_code_assignments
1665: WHERE owner_table_name = p_owner_table_name
1666: AND owner_table_id = p_owner_table_id
1667: AND class_category = p_class_category
1668: AND actual_content_source = p_content_source_type

Line 1677: FROM hz_code_assignments

1673: is
1674: SELECT class_code,
1675: start_date_active,
1676: end_date_active
1677: FROM hz_code_assignments
1678: WHERE owner_table_name = p_owner_table_name
1679: AND owner_table_id = p_owner_table_id
1680: AND class_category = p_class_category
1681: AND actual_content_source = p_content_source_type

Line 1729: FROM hz_code_assignments

1725: is
1726: SELECT class_code,
1727: start_date_active,
1728: end_date_active
1729: FROM hz_code_assignments
1730: WHERE owner_table_name = p_owner_table_name
1731: AND owner_table_id = p_owner_table_id
1732: AND class_category = p_class_category
1733: AND class_code = p_class_code

Line 1742: FROM hz_code_assignments

1738: is
1739: SELECT class_code,
1740: start_date_active,
1741: end_date_active
1742: FROM hz_code_assignments
1743: WHERE owner_table_name = p_owner_table_name
1744: AND owner_table_id = p_owner_table_id
1745: AND class_category = p_class_category
1746: AND class_code = p_class_code

Line 1794: FROM hz_code_assignments

1790: is
1791: SELECT class_code,
1792: start_date_active,
1793: end_date_active
1794: FROM hz_code_assignments
1795: WHERE owner_table_name = p_owner_table_name
1796: AND owner_table_id = p_owner_table_id
1797: AND class_category = p_class_category
1798: AND class_code = p_class_code

Line 1808: FROM hz_code_assignments

1804: is
1805: SELECT class_code,
1806: start_date_active,
1807: end_date_active
1808: FROM hz_code_assignments
1809: WHERE owner_table_name = p_owner_table_name
1810: AND owner_table_id = p_owner_table_id
1811: AND class_category = p_class_category
1812: AND class_code = p_class_code

Line 1957: l_class_category hz_code_assignments.class_category%TYPE;

1953: l_owner_table_keys varchar2(2000);
1954:
1955:
1956:
1957: l_class_category hz_code_assignments.class_category%TYPE;
1958: l_class_code hz_code_assignments.class_code%TYPE;
1959: l_status hz_code_assignments.status%TYPE;
1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;

Line 1958: l_class_code hz_code_assignments.class_code%TYPE;

1954:
1955:
1956:
1957: l_class_category hz_code_assignments.class_category%TYPE;
1958: l_class_code hz_code_assignments.class_code%TYPE;
1959: l_status hz_code_assignments.status%TYPE;
1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;

Line 1959: l_status hz_code_assignments.status%TYPE;

1955:
1956:
1957: l_class_category hz_code_assignments.class_category%TYPE;
1958: l_class_code hz_code_assignments.class_code%TYPE;
1959: l_status hz_code_assignments.status%TYPE;
1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;

Line 1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;

1956:
1957: l_class_category hz_code_assignments.class_category%TYPE;
1958: l_class_code hz_code_assignments.class_code%TYPE;
1959: l_status hz_code_assignments.status%TYPE;
1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;

Line 1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;

1957: l_class_category hz_code_assignments.class_category%TYPE;
1958: l_class_code hz_code_assignments.class_code%TYPE;
1959: l_status hz_code_assignments.status%TYPE;
1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;

Line 1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;

1958: l_class_code hz_code_assignments.class_code%TYPE;
1959: l_status hz_code_assignments.status%TYPE;
1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;

Line 1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;

1959: l_status hz_code_assignments.status%TYPE;
1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;

Line 1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;

1960: l_start_date_active hz_code_assignments.start_date_active%TYPE;
1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;

Line 1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;

1961: l_end_date_active hz_code_assignments.end_date_active%TYPE;
1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;
1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;

Line 1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;

1962: l_owner_table_name hz_code_assignments.owner_table_name%TYPE;
1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;
1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;
1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;

Line 1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;

1963: l_owner_table_id hz_code_assignments.owner_table_id%TYPE;
1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;
1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;
1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;
1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;

Line 1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;

1964: l_owner_table_key_1 hz_code_assignments.owner_table_key_1%TYPE;
1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;
1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;
1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;
1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;
1972:

Line 1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;

1965: l_owner_table_key_2 hz_code_assignments.owner_table_key_2%TYPE;
1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;
1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;
1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;
1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;
1972:
1973: l_primary_flag hz_code_assignments.primary_flag%TYPE;

Line 1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;

1966: l_owner_table_key_3 hz_code_assignments.owner_table_key_3%TYPE;
1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;
1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;
1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;
1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;
1972:
1973: l_primary_flag hz_code_assignments.primary_flag%TYPE;
1974: l_rec hz_code_assignments%ROWTYPE;

Line 1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;

1967: l_owner_table_key_4 hz_code_assignments.owner_table_key_4%TYPE;
1968: l_owner_table_key_5 hz_code_assignments.owner_table_key_5%TYPE;
1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;
1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;
1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;
1972:
1973: l_primary_flag hz_code_assignments.primary_flag%TYPE;
1974: l_rec hz_code_assignments%ROWTYPE;
1975:

Line 1973: l_primary_flag hz_code_assignments.primary_flag%TYPE;

1969: l_content_source_type hz_code_assignments.content_source_type%TYPE;
1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;
1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;
1972:
1973: l_primary_flag hz_code_assignments.primary_flag%TYPE;
1974: l_rec hz_code_assignments%ROWTYPE;
1975:
1976: -- Bug 3293069 - Added local variable to store end_date_active
1977:

Line 1974: l_rec hz_code_assignments%ROWTYPE;

1970: l_actual_content_source hz_code_assignments.actual_content_source%TYPE;
1971: l_created_by_module hz_code_assignments.created_by_module%TYPE;
1972:
1973: l_primary_flag hz_code_assignments.primary_flag%TYPE;
1974: l_rec hz_code_assignments%ROWTYPE;
1975:
1976: -- Bug 3293069 - Added local variable to store end_date_active
1977:
1978: l_date DATE;

Line 1989: SELECT * FROM hz_code_assignments

1985: --p_class_code VARCHAR2,
1986: p_content_source_type VARCHAR2
1987: )
1988: IS
1989: SELECT * FROM hz_code_assignments
1990: WHERE owner_table_name = p_owner_table_name AND
1991: owner_table_id = p_owner_table_id AND
1992: class_category = p_class_category AND
1993: status = 'A' AND

Line 2044: FROM hz_code_assignments

2040: l_owner_table_key_5,
2041: l_content_source_type,
2042: l_actual_content_source,
2043: l_created_by_module
2044: FROM hz_code_assignments
2045: WHERE code_assignment_id = p_in_rec.code_assignment_id
2046: AND rownum=1;
2047: END IF;
2048:

Line 2259: p_entity_name => 'HZ_CODE_ASSIGNMENTS',

2255: p_content_source_type => p_in_rec.content_source_type,
2256: p_old_content_source_type => l_content_source_type,
2257: p_actual_content_source => p_in_rec.actual_content_source,
2258: p_old_actual_content_source => l_actual_content_source,
2259: p_entity_name => 'HZ_CODE_ASSIGNMENTS',
2260: x_return_status => x_return_status);
2261:
2262: --IF l_actual_content_source <> p_in_rec.actual_content_source
2263: -- Bug 4226199 : call for update and for all ACS otehr than UE

Line 2287: p_entity_name => 'HZ_CODE_ASSIGNMENTS',

2283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2284: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege(
2285: p_actual_content_source => l_actual_content_source,
2286: p_new_actual_content_source => p_in_rec.actual_content_source,
2287: p_entity_name => 'HZ_CODE_ASSIGNMENTS',
2288: x_return_status => x_return_status);
2289: -- Bug 4693719 : set global variable to Y
2290: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
2291: END IF;

Line 2372: from hz_code_assignments

2368: -- preserve the functionality that only one of these two can be
2369: -- present for any code assignment.
2370: if(l_owner_table_id is not null) then
2371: select count(1) into l_count_multi
2372: from hz_code_assignments
2373: where class_category = p_in_rec.class_category
2374: AND status='A'
2375: AND code_Assignment_id <> nvl(p_in_rec.code_assignment_id, fnd_api.g_miss_num)
2376: AND owner_table_name = nvl(p_in_rec.owner_table_name, l_owner_table_name)

Line 2413: from hz_code_assignments

2409: (nvl(END_DATE_ACTIVE, to_date('4712/12/31','YYYY/MM/DD')))
2410: )*/;
2411: else
2412: select count(1) into l_count_multi
2413: from hz_code_assignments
2414: where class_category = p_in_rec.class_category
2415: AND status='A'
2416: AND code_Assignment_id <> nvl(p_in_rec.code_assignment_id, fnd_api.g_miss_num)
2417: AND owner_table_name = nvl(p_in_rec.owner_table_name, l_owner_table_name)

Line 2588: FROM hz_code_assignments

2584: BEGIN
2585:
2586: SELECT code_assignment_id, end_date_active
2587: INTO l_id, l_end_date
2588: FROM hz_code_assignments
2589: WHERE owner_table_name = nvl(p_in_rec.owner_table_name, l_owner_table_name) AND
2590: owner_table_id = nvl(p_in_rec.owner_table_id, l_owner_table_id) AND
2591: class_category = nvl(p_in_rec.class_category, l_class_category) AND
2592: class_code = nvl(p_in_rec.class_code, l_class_code) AND

Line 2667: FROM hz_code_assignments

2663: */
2664:
2665: SELECT primary_flag
2666: INTO l_primary_flag
2667: FROM hz_code_assignments
2668: WHERE code_assignment_id = p_in_rec.code_assignment_id;
2669:
2670: --
2671: --- Bugfix:2154581

Line 2852: UPDATE HZ_CODE_ASSIGNMENTS SET

2848: (v_rec.end_date_active >= sysdate)) AND
2849: v_rec.class_code <> p_in_rec.class_code)
2850: THEN
2851: -- terminate original primary assignment
2852: UPDATE HZ_CODE_ASSIGNMENTS SET
2853: end_date_active = SYSDATE
2854: WHERE code_assignment_id = v_rec.code_assignment_id;
2855: END IF;
2856:

Line 2865: UPDATE HZ_CODE_ASSIGNMENTS SET

2861: (v_rec.end_date_active >= sysdate)) AND
2862: v_rec.class_code = p_in_rec.class_code)
2863: THEN
2864: -- terminate original non-primary assignment
2865: UPDATE HZ_CODE_ASSIGNMENTS SET
2866: end_date_active = SYSDATE
2867: WHERE code_assignment_id = v_rec.code_assignment_id;
2868: END IF;
2869: END LOOP;

Line 2889: UPDATE HZ_CODE_ASSIGNMENTS SET

2885: (v_rec.end_date_active >= sysdate))
2886: )
2887: THEN
2888: -- AN PRIMARY ONE EXISTS, terminate it
2889: UPDATE HZ_CODE_ASSIGNMENTS SET
2890: end_date_active = SYSDATE
2891: WHERE code_assignment_id = v_rec.code_assignment_id;
2892: ELSE
2893: -- AN NON-PRIMARY ONE EXISTS