APPS.BOMPCOAN dependencies on ENG_AUTO_NUMBER_ECN

Line 34: p_next_number ENG_AUTO_NUMBER_ECN.NEXT_AVAILABLE_NUMBER%TYPE;

30: , p_change_notice IN VARCHAR2
31: , x_return_status IN OUT NOCOPY VARCHAR2)
32:
33: IS
34: p_next_number ENG_AUTO_NUMBER_ECN.NEXT_AVAILABLE_NUMBER%TYPE;
35: p_prefix_temp VARCHAR2(12);
36: p_prefix_temp1 VARCHAR2(12);
37: p_greatest_num NUMBER;
38: l_return_status VARCHAR2(1);

Line 48: FROM eng_auto_number_ecn

44: c_prefix IN VARCHAR2) IS
45: SELECT
46: alpha_prefix,
47: next_available_number
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 alpha_prefix = c_prefix
52: AND change_type_id IS NULL

Line 138: p_next_number ENG_AUTO_NUMBER_ECN.NEXT_AVAILABLE_NUMBER%TYPE;

134: P_PREFIX IN OUT NOCOPY VARCHAR2,
135: x_return_status IN OUT NOCOPY VARCHAR2)
136: IS
137:
138: p_next_number ENG_AUTO_NUMBER_ECN.NEXT_AVAILABLE_NUMBER%TYPE;
139: p_prefix_temp VARCHAR2(12);
140: p_output_user_id NUMBER;
141: p_output_org_id NUMBER;
142: p_greatest_num NUMBER;

Line 157: FROM eng_auto_number_ecn

153: alpha_prefix,
154: next_available_number,
155: user_id,
156: organization_id
157: FROM eng_auto_number_ecn
158: WHERE nvl(organization_id, c_org_id) = c_org_id
159: AND nvl(user_id, c_user_id) = c_user_id
160: AND change_type_id IS NULL --* Added for bug #3959772
161: ORDER BY user_id, organization_id

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

163:
164:
165: BEGIN
166:
167: /* P_MODE = 1 --> update ENG_AUTO_NUMBER_ECN to show next available
168: number
169: */
170:
171: OPEN PREFIX_CURSOR(P_USER_ID, P_ORGANIZATION_ID);

Line 225: UPDATE ENG_AUTO_NUMBER_ECN

221:
222: if P_MODE = 1 -- Only update the autonumber table if P_MODE is 1
223: then
224: --Added rowd_id ,as for case 4 ,the update statement updated all the records ,which is not desirable
225: UPDATE ENG_AUTO_NUMBER_ECN
226: SET NEXT_AVAILABLE_NUMBER = P_NEXT_NUMBER+1
227: WHERE NVL(ORGANIZATION_ID, -999) = NVL(P_OUTPUT_ORG_ID, -999)
228: AND NVL(USER_ID, -999) = NVL(P_OUTPUT_USER_ID, -999)
229: AND rowid =l_rowid;