APPS.GHG_TRANSACTIONS_API_PKG dependencies on DUAL

Line 30: -- select sailen_s.nextval, x_text from dual;

26: procedure x_debug (x_text varchar2) is
27: begin
28: v_debug := x_text;
29: -- insert into sailen
30: -- select sailen_s.nextval, x_text from dual;
31: -- fnd_message.debug(x_text);
32: -- dbms_output.put_line(x_text);
33: null;
34: end;

Line 304: -- select sailen_s.nextval, x_text from dual;

300: procedure x_debug (x_text varchar2) is
301: begin
302: v_debug := x_text;
303: -- insert into sailen
304: -- select sailen_s.nextval, x_text from dual;
305: -- fnd_message.debug(x_text);
306: -- dbms_output.put_line(x_text);
307: null;
308: end;

Line 725: FROM dual;

721: -- Get Key Data
722: -----------------------------------------------------------------------------------------
723: SELECT GHG_TRANSACTIONS_S.NEXTVAL
724: into v_emission_id
725: FROM dual;
726:
727: v_uom_conversion := GHG_UTILITIES_PKG.get_conversion(p_emission_uom, v_emission_source_id, 'GENERAL','API');
728:
729: SELECT NVL(MAX(transaction_line_number),0)+1

Line 751: FROM DUAL;

747: IF v_emission_batch_id is NULL THEN
748:
749: SELECT GHG_TRANSACTION_BATCHES_s.NEXTVAL
750: INTO v_emission_batch_id
751: FROM DUAL;
752:
753: GHG_TRANSACTION_BATCHES_PKG.insert_row (x_rowid => v_batch_rowid,
754: x_transaction_batch_id => v_emission_batch_id,
755: x_transaction_batch_number => p_batch_number,

Line 1007: SELECT USERENV('LANG') INTO v_language from dual;

1003: FND_MESSAGE.SET_NAME('GHG', 'GHG_DW_DB_LINK_MISSING');
1004: RAISE raise_error;
1005: END IF;
1006:
1007: SELECT USERENV('LANG') INTO v_language from dual;
1008:
1009:
1010: write_to_log('Cleardown Data Warehouse');
1011: