APPS.BOMPCOAN dependencies on ENG_AUTO_NUMBER_ECN

Line 31: p_next_number ENG_AUTO_NUMBER_ECN.NEXT_AVAILABLE_NUMBER%TYPE;

27: P_MODE IN NUMBER,
28: P_PREFIX IN OUT NOCOPY VARCHAR2)
29: IS
30:
31: p_next_number ENG_AUTO_NUMBER_ECN.NEXT_AVAILABLE_NUMBER%TYPE;
32: p_prefix_temp VARCHAR2(12);
33: p_output_user_id NUMBER;
34: p_output_org_id NUMBER;
35: p_greatest_num NUMBER;

Line 48: FROM eng_auto_number_ecn

44: alpha_prefix,
45: next_available_number,
46: user_id,
47: organization_id
48: FROM eng_auto_number_ecn
49: WHERE nvl(organization_id, c_org_id) = c_org_id
50: AND nvl(user_id, c_user_id) = c_user_id
51: AND change_type_id IS NULL --* Added for bug #3959772
52: ORDER BY user_id, organization_id

Line 58: /* P_MODE = 1 --> update ENG_AUTO_NUMBER_ECN to show next available

54:
55:
56: BEGIN
57:
58: /* P_MODE = 1 --> update ENG_AUTO_NUMBER_ECN to show next available
59: number
60: */
61:
62: OPEN PREFIX_CURSOR(P_USER_ID, P_ORGANIZATION_ID);

Line 108: UPDATE ENG_AUTO_NUMBER_ECN

104: then
105: if P_MODE = 1 -- Only update the autonumber table if P_MODE is 1
106: then
107: --Added rowd_id ,as for case 4 ,the update statement updated all the records ,which is not desirable
108: UPDATE ENG_AUTO_NUMBER_ECN
109: SET NEXT_AVAILABLE_NUMBER = P_NEXT_NUMBER+1
110: WHERE NVL(ORGANIZATION_ID, -999) = NVL(P_OUTPUT_ORG_ID, -999)
111: AND NVL(USER_ID, -999) = NVL(P_OUTPUT_USER_ID, -999)
112: AND rowid =l_rowid;