APPS.PA_SYSTEM_NUMBERS_PKG dependencies on PA_SYSTEM_NUMBERS_S

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 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)