DBA Data[Home] [Help]

APPS.PO_LOCKS dependencies on PO_CORE_S

Line 136: PO_CORE_S.get_document_ids(

132: l_progress := '010';
133:
134: -- Get the header ids for the given doc level ids.
135:
136: PO_CORE_S.get_document_ids(
137: p_doc_type => p_doc_type
138: , p_doc_level => p_doc_level
139: , p_doc_level_id_tbl => p_doc_level_id_tbl
140: , x_doc_id_tbl => l_doc_id_tbl

Line 163: IF (p_doc_type = PO_CORE_S.g_doc_type_REQUISITION) THEN

159: l_progress := '040';
160:
161: -- Cursors lock the rows on OPEN, and we don't need to SELECT anything.
162:
163: IF (p_doc_type = PO_CORE_S.g_doc_type_REQUISITION) THEN
164:
165: l_progress := '050';
166: IF g_debug_stmt THEN
167: PO_DEBUG.debug_stmt(l_log_head,l_progress,'requisition');

Line 175: ELSIF (p_doc_type = PO_CORE_S.g_doc_type_RELEASE) THEN

171: CLOSE l_lock_req_csr;
172:
173: l_progress := '060';
174:
175: ELSIF (p_doc_type = PO_CORE_S.g_doc_type_RELEASE) THEN
176:
177: l_progress := '070';
178: IF g_debug_stmt THEN
179: PO_DEBUG.debug_stmt(l_log_head,l_progress,'release');

Line 187: ELSIF (p_doc_type IN (PO_CORE_S.g_doc_type_PO, PO_CORE_S.g_doc_type_PA)) THEN

183: CLOSE l_lock_release_csr;
184:
185: l_progress := '080';
186:
187: ELSIF (p_doc_type IN (PO_CORE_S.g_doc_type_PO, PO_CORE_S.g_doc_type_PA)) THEN
188:
189: l_progress := '090';
190: IF g_debug_stmt THEN
191: PO_DEBUG.debug_stmt(l_log_head,l_progress,'po, pa');

Line 203: RAISE PO_CORE_S.g_INVALID_CALL_EXC;

199: ELSE
200:
201: l_progress := '190';
202:
203: RAISE PO_CORE_S.g_INVALID_CALL_EXC;
204:
205: END IF;
206:
207: l_progress := '900';

Line 311: PO_CORE_S.get_distribution_ids(

307: l_progress := '010';
308:
309: -- Get the distribution ids for the given doc level ids.
310:
311: PO_CORE_S.get_distribution_ids(
312: p_doc_type => p_doc_type
313: , p_doc_level => p_doc_level
314: , p_doc_level_id_tbl => p_doc_level_id_tbl
315: , x_distribution_id_tbl => l_dist_id_tbl

Line 339: IF (p_doc_type = PO_CORE_S.g_doc_type_REQUISITION) THEN

335: l_progress := '030';
336:
337: -- Cursors lock the rows on OPEN, and we don't need to SELECT into anything.
338:
339: IF (p_doc_type = PO_CORE_S.g_doc_type_REQUISITION) THEN
340:
341: l_progress := '040';
342: IF g_debug_stmt THEN
343: PO_DEBUG.debug_stmt(l_log_head,l_progress,'requisition');

Line 351: ELSIF (p_doc_type IN ( PO_CORE_S.g_doc_type_PO

347: CLOSE l_lock_req_csr;
348:
349: l_progress := '050';
350:
351: ELSIF (p_doc_type IN ( PO_CORE_S.g_doc_type_PO
352: , PO_CORE_S.g_doc_type_PA
353: , PO_CORE_S.g_doc_type_RELEASE ))
354: THEN
355:

Line 352: , PO_CORE_S.g_doc_type_PA

348:
349: l_progress := '050';
350:
351: ELSIF (p_doc_type IN ( PO_CORE_S.g_doc_type_PO
352: , PO_CORE_S.g_doc_type_PA
353: , PO_CORE_S.g_doc_type_RELEASE ))
354: THEN
355:
356: l_progress := '060';

Line 353: , PO_CORE_S.g_doc_type_RELEASE ))

349: l_progress := '050';
350:
351: ELSIF (p_doc_type IN ( PO_CORE_S.g_doc_type_PO
352: , PO_CORE_S.g_doc_type_PA
353: , PO_CORE_S.g_doc_type_RELEASE ))
354: THEN
355:
356: l_progress := '060';
357: IF g_debug_stmt THEN

Line 370: RAISE PO_CORE_S.g_INVALID_CALL_EXC;

366: ELSE
367:
368: l_progress := '090';
369:
370: RAISE PO_CORE_S.g_INVALID_CALL_EXC;
371:
372: END IF;
373:
374: l_progress := '900';