APPS.PO_PERIODS_SV dependencies on PO_SESSION_GT

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 179: -- PO_SESSION_GT column mapping

175:
176: l_progress := '070';
177:
178: -----------------------------------------
179: -- PO_SESSION_GT column mapping
180: --
181: -- date1 GL date
182: -- char1 period_name
183: -- num1 period_year

Line 193: INSERT INTO PO_SESSION_GT ( key, date1 )

189: * use a table of VARCHAR2 and use the ROWIDTOCHAR() and CHARTOROWID() functions.
190: */
191:
192: FORALL i IN 1 .. p_date_tbl.COUNT
193: INSERT INTO PO_SESSION_GT ( key, date1 )
194: VALUES ( l_date_key, p_date_tbl(i) )
195: RETURNING ROWIDTOCHAR(rowid)
196: BULK COLLECT INTO l_rowid_tbl
197: ;

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: ;