APPS.PA_SYSTEM_NUMBERS_PKG dependencies on PA_SYSTEM_NUMBERS

Line 1: PACKAGE BODY PA_SYSTEM_NUMBERS_PKG AS

1: PACKAGE BODY PA_SYSTEM_NUMBERS_PKG AS
2: --$Header: PASNUMTB.pls 120.0 2005/05/30 07:05:56 appldev noship $
3:
4: procedure GET_NEXT_NUMBER (
5: p_system_number_id IN NUMBER := NULL

Line 24: FROM PA_SYSTEM_NUMBERS

20:
21: /*CURSOR lock_number_record
22: IS
23: SELECT system_number_id
24: FROM PA_SYSTEM_NUMBERS
25: WHERE p_object1_pk1_value = object1_pk1_value
26: FOR UPDATE of system_number_id NOWAIT; */
27:
28: CURSOR c_next_num IS

Line 30: from PA_SYSTEM_NUMBERS

26: FOR UPDATE of system_number_id NOWAIT; */
27:
28: CURSOR c_next_num IS
29: SELECT system_number_id, next_number
30: from PA_SYSTEM_NUMBERS
31: where system_number_id = p_system_number_id;
32:
33: cp_next_num c_next_num%ROWTYPE;
34:

Line 37: from PA_SYSTEM_NUMBERS

33: cp_next_num c_next_num%ROWTYPE;
34:
35: CURSOR c_next_obj_num IS
36: SELECT system_number_id, next_number
37: from PA_SYSTEM_NUMBERS
38: where p_object1_pk1_value = object1_pk1_value
39: and p_object1_type = object1_type
40: and nvl(p_object2_pk1_value,0) = nvl(object2_pk1_value,0)
41: and nvl(p_object2_type,' ') = nvl(object2_type,' ')

Line 48: pa_debug.init_err_stack('PA_SYSTEM_NUMBERS_PKG:GET_NEXT_NUMBER');

44: cp_next_obj_num c_next_obj_num%ROWTYPE;
45:
46: BEGIN
47:
48: pa_debug.init_err_stack('PA_SYSTEM_NUMBERS_PKG:GET_NEXT_NUMBER');
49:
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: if p_system_number_id is null then

Line 136: cursor C is select ROWID from PA_SYSTEM_NUMBERS

132: l_next_number NUMBER;
133: l_rowid ROWID;
134:
135:
136: cursor C is select ROWID from PA_SYSTEM_NUMBERS
137: where system_number_id = l_system_id;
138:
139:
140: BEGIN

Line 146: SELECT pa.pa_system_numbers_s.nextval */

142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: --get the unique system number id from the Oracle Sequence
145: /* Commented for bug 3866224 to remove hard coded schema reference and modified as below
146: SELECT pa.pa_system_numbers_s.nextval */
147: SELECT pa_system_numbers_s.nextval
148: INTO l_system_id
149: FROM DUAL;
150:

Line 147: SELECT pa_system_numbers_s.nextval

143:
144: --get the unique system number id from the Oracle Sequence
145: /* Commented for bug 3866224 to remove hard coded schema reference and modified as below
146: SELECT pa.pa_system_numbers_s.nextval */
147: SELECT pa_system_numbers_s.nextval
148: INTO l_system_id
149: FROM DUAL;
150:
151: if p_next_number is NULL then

Line 157: insert into PA_SYSTEM_NUMBERS (

153: else
154: l_next_number := p_next_number;
155: end if;
156:
157: insert into PA_SYSTEM_NUMBERS (
158: system_number_id
159: ,object1_pk1_value
160: ,object1_type
161: ,object2_pk1_value

Line 225: update PA_SYSTEM_NUMBERS set

221: ) is
222: begin
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: update PA_SYSTEM_NUMBERS set
226: object1_pk1_value = Nvl(p_object1_pk1_value,object1_pk1_value)
227: ,object1_type = Nvl(p_object1_type,object1_type)
228: ,object2_pk1_value = Nvl(p_object2_pk1_value,object2_pk1_value)
229: ,object2_type = Nvl(p_object2_type,object2_type)

Line 269: DELETE FROM PA_SYSTEM_NUMBERS

265: ) is
266: begin
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268:
269: DELETE FROM PA_SYSTEM_NUMBERS
270: where system_number_id = nvl(p_system_number_id,0)
271: OR (object1_pk1_value = p_object1_pk1_value AND
272: p_object1_type = p_object1_type AND
273: nvl(object2_pk1_value, 0) = nvl(p_object2_pk1_value,0) AND

Line 284: END PA_SYSTEM_NUMBERS_PKG;

280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: RAISE;
282: end DELETE_ROW;
283:
284: END PA_SYSTEM_NUMBERS_PKG;