APPS.ENG_ECO_PVT dependencies on ENG_ENGINEERING_CHANGES

Line 28: FROM eng_engineering_changes

24: RETURN NUMBER
25: IS
26: CURSOR check_co_sch IS
27: SELECT status_type
28: FROM eng_engineering_changes
29: WHERE change_notice = p_change_notice
30: AND organization_id = p_organization_id
31: AND nvl(plm_or_erp_change, 'PLM') = 'PLM'; -- Added for bug 3692807
32:

Line 33: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

29: WHERE change_notice = p_change_notice
30: AND organization_id = p_organization_id
31: AND nvl(plm_or_erp_change, 'PLM') = 'PLM'; -- Added for bug 3692807
32:
33: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
34: BEGIN
35: OPEN check_co_sch;
36: FETCH check_co_sch INTO l_chk_co_sch;
37: IF check_co_sch%FOUND THEN

Line 8904: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

8900:
8901: -- Bug 2918350 // kamohan
8902: -- Start Changes
8903:
8904: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
8905:
8906: -- End Changes
8907:
8908: BEGIN

Line 10327: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

10323:
10324: -- Bug 2918350 // kamohan
10325: -- Start Changes
10326:
10327: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
10328:
10329: -- End Changes
10330:
10331: BEGIN

Line 11873: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

11869:
11870: EXC_FAT_QUIT_BRANCH EXCEPTION ;
11871: EXC_SEV_QUIT_OBJECT EXCEPTION;
11872:
11873: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
11874: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;
11875:
11876: BEGIN
11877:

Line 13077: l_chk_co_sch eng_engineering_changes.status_type%TYPE;

13073:
13074: -- Bug 2918350 // kamohan
13075: -- Start Changes
13076:
13077: l_chk_co_sch eng_engineering_changes.status_type%TYPE;
13078:
13079: -- Bug 2918350 // kamohan
13080: -- End Changes
13081:

Line 14147: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot

14143: -- Start Changes
14144:
14145: CURSOR check_co_type ( p_change_notice VARCHAR2, p_organization_id NUMBER) IS
14146: SELECT ecot.type_name CHANGE_ORDER_TYPE, eec.assignee_id
14147: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot
14148: WHERE eec.change_notice =p_change_notice
14149: AND eec.organization_id = p_organization_id
14150: AND eec.change_order_type_id = ecot.change_order_type_id;
14151: