DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on DUAL

Line 1009: FROM DUAL;

1005: -- the PON_AUCTION_HEADERS_ALL_S sequence
1006: --
1007: SELECT PON_AUCTION_HEADERS_ALL_S.NEXTVAL
1008: INTO l_auction_header_id
1009: FROM DUAL;
1010: --
1011: --Initialise global variables here
1012: --
1013:

Line 3436: RESIDUAL_QUANTITY,

3432: AUCTION_HEADER_ID_PREV_ROUND,
3433: LINE_NUMBER_ORIGINAL_ROUND,
3434: LINE_NUMBER_PREV_ROUND,
3435: MULTIPLE_PRICES_FLAG,
3436: RESIDUAL_QUANTITY,
3437: PENDING_QUANTITY,
3438: CANCEL_QUANTITY,
3439: NUMBER_OF_COMMITMENTS,
3440: NUMBER_OF_PENDING_COMMITMENTS,

Line 3570: NULL, -- RESIDUAL_QUANTITY

3566: NULL, -- AUCTION_HEADER_ID_PREV_ROUND, No need to take care, they're not used ?
3567: NULL, -- LINE_NUMBER_ORIGINAL_ROUND, No need to take care, they're not used ?
3568: NULL, -- LINE_NUMBER_PREV_ROUND, No need to take care, they're not used ?
3569: l_multiple_prices_flag(x),
3570: NULL, -- RESIDUAL_QUANTITY
3571: NULL, -- PENDING_QUANTITY, defaulted to NULL
3572: NULL, -- CANCEL_QUANTITY, defaulted to NULL
3573: NULL, -- NUMBER_OF_COMMITMENTS, defaulted to NULL
3574: NULL, -- NUMBER_OF_PENDING_COMMITMENTS, defaulted to NULL

Line 7313: FROM DUAL;

7309: SELECT
7310: PON_FORM_FIELD_VALUES_S.NEXTVAL
7311: INTO
7312: l_new_field_values_fk
7313: FROM DUAL;
7314:
7315: INSERT INTO
7316: PON_FORM_FIELD_VALUES
7317: (