DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on DUAL

Line 132: FROM DUAL

128: l_temp NUMBER;
129: duplicate_wip_entity EXCEPTION;
130: CURSOR Cur_wip_entity IS
131: SELECT 1
132: FROM DUAL
133: WHERE EXISTS (SELECT 1
134: FROM wip_entities
135: WHERE organization_id = p_organization_id
136: AND wip_entity_name = p_batch_no);

Line 332: FROM DUAL

328: ,v_batch_no VARCHAR2
329: ,v_batch_type VARCHAR2)
330: IS
331: SELECT 1
332: FROM DUAL
333: WHERE EXISTS (
334: SELECT 1
335: FROM gme_batch_header
336: WHERE batch_no = v_batch_no

Line 1348: SELECT trim(TO_CHAR(systimestamp,'DD:MM:YYYY HH24:MI:SS:FF6')) INTO l_doc_timestamp FROM DUAL;

1344: /*5698727 rework Begin we use timestamp initially as its unique. later we update
1345: with actual batch_no
1346: gme_common_pvt.create_document_no (l_in_batch_header
1347: ,x_batch_header_rec);*/
1348: SELECT trim(TO_CHAR(systimestamp,'DD:MM:YYYY HH24:MI:SS:FF6')) INTO l_doc_timestamp FROM DUAL;
1349:
1350: IF g_debug <= gme_debug.g_log_statement THEN
1351: gme_debug.put_line ( g_pkg_name
1352: || '.'