APPS.PA_UTILS_SQNUM_PKG dependencies on PA_IMPLEMENTATIONS

Line 95: PL_DUMMY PA_IMPLEMENTATIONS.NEXT_AUTOMATIC_INVOICE_NUMBER%TYPE;

91: user_id IN NUMBER,
92: unique_number IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
93: x_status IN OUT NOCOPY NUMBER) is --File.Sql.39 bug 4440895
94: uniqueid NUMBER;
95: PL_DUMMY PA_IMPLEMENTATIONS.NEXT_AUTOMATIC_INVOICE_NUMBER%TYPE;
96:
97: BEGIN
98:
99: x_status := 0;

Line 105: -- LOCK TABLE PA_IMPLEMENTATIONS IN SHARE UPDATE MODE;

101: -- tsaifee 01/24/97 : First select the number from the table
102: -- then increment and update it.
103: -- Commented due to bug#634122 by Arindam
104:
105: -- LOCK TABLE PA_IMPLEMENTATIONS IN SHARE UPDATE MODE;
106:
107:
108: SELECT decode(invoice_category, 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER,
109: CC_NEXT_AUTOMATIC_INVOICE_NUM)

Line 111: FROM PA_IMPLEMENTATIONS

107:
108: SELECT decode(invoice_category, 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER,
109: CC_NEXT_AUTOMATIC_INVOICE_NUM)
110: INTO PL_DUMMY
111: FROM PA_IMPLEMENTATIONS
112: FOR UPDATE OF NEXT_AUTOMATIC_INVOICE_NUMBER,CC_NEXT_AUTOMATIC_INVOICE_NUM;
113:
114: SELECT decode(invoice_category, 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER,
115: CC_NEXT_AUTOMATIC_INVOICE_NUM)

Line 117: FROM PA_IMPLEMENTATIONS;

113:
114: SELECT decode(invoice_category, 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER,
115: CC_NEXT_AUTOMATIC_INVOICE_NUM)
116: INTO uniqueid
117: FROM PA_IMPLEMENTATIONS;
118:
119: UPDATE PA_IMPLEMENTATIONS
120: SET NEXT_AUTOMATIC_INVOICE_NUMBER = decode(invoice_category,
121: 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER + 1,

Line 119: UPDATE PA_IMPLEMENTATIONS

115: CC_NEXT_AUTOMATIC_INVOICE_NUM)
116: INTO uniqueid
117: FROM PA_IMPLEMENTATIONS;
118:
119: UPDATE PA_IMPLEMENTATIONS
120: SET NEXT_AUTOMATIC_INVOICE_NUMBER = decode(invoice_category,
121: 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER + 1,
122: NEXT_AUTOMATIC_INVOICE_NUMBER),
123: CC_NEXT_AUTOMATIC_INVOICE_NUM = decode(invoice_category,