APPS.PA_UTILS_SQNUM_PKG dependencies on PA_UNIQUE_IDENTIFIER_CONTROL

Line 26: -- PL_DUMMY PA_UNIQUE_IDENTIFIER_CONTROL.NEXT_UNIQUE_IDENTIFIER%TYPE;

22: unique_number IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23: x_status IN OUT NOCOPY NUMBER) is --File.Sql.39 bug 4440895
24: uniqueid NUMBER;
25: -- Commented by Sachin. Bug 3517177
26: -- PL_DUMMY PA_UNIQUE_IDENTIFIER_CONTROL.NEXT_UNIQUE_IDENTIFIER%TYPE;
27: PRAGMA AUTONOMOUS_TRANSACTION; -- Added by Sachin. Bug 3517177
28:
29: BEGIN
30:

Line 36: -- LOCK TABLE PA_UNIQUE_IDENTIFIER_CONTROL IN SHARE UPDATE MODE;

32:
33: -- tsaifee 01/24/97 : First select the number from the table
34: -- then increment and update it.
35:
36: -- LOCK TABLE PA_UNIQUE_IDENTIFIER_CONTROL IN SHARE UPDATE MODE;
37: /* Commented by sachin. Bug 3517177
38: SELECT NEXT_UNIQUE_IDENTIFIER
39: INTO PL_DUMMY
40: FROM PA_UNIQUE_IDENTIFIER_CONTROL

Line 40: FROM PA_UNIQUE_IDENTIFIER_CONTROL

36: -- LOCK TABLE PA_UNIQUE_IDENTIFIER_CONTROL IN SHARE UPDATE MODE;
37: /* Commented by sachin. Bug 3517177
38: SELECT NEXT_UNIQUE_IDENTIFIER
39: INTO PL_DUMMY
40: FROM PA_UNIQUE_IDENTIFIER_CONTROL
41: WHERE TABLE_NAME = x_table_name
42: AND NEXT_UNIQUE_IDENTIFIER IS NOT NULL
43: FOR UPDATE OF NEXT_UNIQUE_IDENTIFIER;
44: */

Line 47: FROM PA_UNIQUE_IDENTIFIER_CONTROL

43: FOR UPDATE OF NEXT_UNIQUE_IDENTIFIER;
44: */
45: SELECT NEXT_UNIQUE_IDENTIFIER
46: INTO uniqueid
47: FROM PA_UNIQUE_IDENTIFIER_CONTROL
48: WHERE TABLE_NAME = x_table_name
49: AND NEXT_UNIQUE_IDENTIFIER IS NOT NULL
50: FOR UPDATE OF NEXT_UNIQUE_IDENTIFIER;
51:

Line 52: UPDATE PA_UNIQUE_IDENTIFIER_CONTROL

48: WHERE TABLE_NAME = x_table_name
49: AND NEXT_UNIQUE_IDENTIFIER IS NOT NULL
50: FOR UPDATE OF NEXT_UNIQUE_IDENTIFIER;
51:
52: UPDATE PA_UNIQUE_IDENTIFIER_CONTROL
53: SET NEXT_UNIQUE_IDENTIFIER = NEXT_UNIQUE_IDENTIFIER + 1,
54: LAST_UPDATED_BY = user_id,
55: LAST_UPDATE_DATE = trunc(SYSDATE)
56: WHERE TABLE_NAME = x_table_name

Line 165: UPDATE PA_UNIQUE_IDENTIFIER_CONTROL

161: PRAGMA AUTONOMOUS_TRANSACTION; -- Added by Sachin. Bug 3517177
162:
163: BEGIN
164:
165: UPDATE PA_UNIQUE_IDENTIFIER_CONTROL
166: SET NEXT_UNIQUE_IDENTIFIER = p_unique_number,
167: LAST_UPDATED_BY = p_user_id,
168: LAST_UPDATE_DATE = trunc(SYSDATE)
169: WHERE TABLE_NAME = p_table_name