DBA Data[Home] [Help]

APPS.PO_PERIODS_SV dependencies on PO_SESSION_GT_S

Line 171: SELECT PO_SESSION_GT_S.nextval

167: l_progress := '060';
168:
169: -- Use the scratchpad to avoid PL/SQL limitations.
170:
171: SELECT PO_SESSION_GT_S.nextval
172: INTO l_date_key
173: FROM DUAL
174: ;
175:

Line 207: UPDATE PO_SESSION_GT SES

203: * Changes made below to how l_rowid_tbl is interpreted.
204: */
205:
206: FORALL i IN 1 .. l_rowid_tbl.COUNT
207: UPDATE PO_SESSION_GT SES
208: SET
209: ( char1 -- period_name
210: , num1 -- period_year
211: , num2 -- period_num

Line 267: FROM PO_SESSION_GT SES

263: l_progress := '110';
264:
265: SELECT FND_API.G_TRUE
266: INTO x_invalid_period_flag
267: FROM PO_SESSION_GT SES
268: WHERE SES.key = l_date_key
269: AND SES.char1 IS NULL
270: AND rownum = 1
271: ;