APPS.PON_NEGOTIATION_COPY_GRP dependencies on DUAL

Line 1112: FROM DUAL;

1108: -- the PON_AUCTION_HEADERS_ALL_S sequence
1109: --
1110: SELECT PON_AUCTION_HEADERS_ALL_S.NEXTVAL
1111: INTO l_auction_header_id
1112: FROM DUAL;
1113: --
1114: --Initialise global variables here
1115: --
1116:

Line 4388: RESIDUAL_QUANTITY,

4384: AUCTION_HEADER_ID_PREV_ROUND,
4385: LINE_NUMBER_ORIGINAL_ROUND,
4386: LINE_NUMBER_PREV_ROUND,
4387: MULTIPLE_PRICES_FLAG,
4388: RESIDUAL_QUANTITY,
4389: PENDING_QUANTITY,
4390: CANCEL_QUANTITY,
4391: NUMBER_OF_COMMITMENTS,
4392: NUMBER_OF_PENDING_COMMITMENTS,

Line 4549: NULL, -- RESIDUAL_QUANTITY

4545: NULL, -- AUCTION_HEADER_ID_PREV_ROUND, No need to take care, they're not used ?
4546: NULL, -- LINE_NUMBER_ORIGINAL_ROUND, No need to take care, they're not used ?
4547: NULL, -- LINE_NUMBER_PREV_ROUND, No need to take care, they're not used ?
4548: l_multiple_prices_flag(x),
4549: NULL, -- RESIDUAL_QUANTITY
4550: NULL, -- PENDING_QUANTITY, defaulted to NULL
4551: NULL, -- CANCEL_QUANTITY, defaulted to NULL
4552: NULL, -- NUMBER_OF_COMMITMENTS, defaulted to NULL
4553: NULL, -- NUMBER_OF_PENDING_COMMITMENTS, defaulted to NULL

Line 8481: FROM DUAL;

8477: SELECT
8478: PON_FORM_FIELD_VALUES_S.NEXTVAL
8479: INTO
8480: l_new_field_values_fk
8481: FROM DUAL;
8482:
8483: INSERT INTO
8484: PON_FORM_FIELD_VALUES
8485: (

Line 13151: from dual;

13147: select
13148: nvl((select (max(revision)+1) from pon_auction_headers_all where auction_header_id_orig_amend =
13149: (select auction_header_id_orig_amend from pon_auction_headers_all where auction_header_id = p_auction_header_id)),0)
13150: INTO l_revision
13151: from dual;
13152:
13153: return l_revision;
13154:
13155: END GET_REVISION_NUMBER;