eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_LARGE_NEG_PF_VALUES

Line 373: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

369: x_msg_data OUT NOCOPY VARCHAR2
370: );
371:
372: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
373: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
374: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
375: p_user_id IN number);
376:
377: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (

Line 374: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

370: );
371:
372: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
373: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
374: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
375: p_user_id IN number);
376:
377: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
378: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

Line 378: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

374: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
375: p_user_id IN number);
376:
377: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
378: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
379: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
380: p_user_id IN number);
381:
382: procedure renumber_lines(p_auction_header_id IN NUMBER);

Line 379: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

375: p_user_id IN number);
376:
377: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
378: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
379: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
380: p_user_id IN number);
381:
382: procedure renumber_lines(p_auction_header_id IN NUMBER);
383:

Line 12388: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

12384: --This procedure willbe called even in the case of publish, and in this case
12385: --p_source_auction_hdr_id = p_destination_auction_hdr_id
12386: --
12387: --p_source_auction_hdr_id IN
12388: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12389: --This parameter is the auction_header_id of the source auction
12390: --
12391: --p_destination_auction_hdr_id IN
12392: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

Line 12392: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

12388: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12389: --This parameter is the auction_header_id of the source auction
12390: --
12391: --p_destination_auction_hdr_id IN
12392: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12393: --This parameter is the auction_header_id of the destination auction
12394: --
12395: --p_user_id IN
12396: --DATATYPE: NUMBER

Line 12401: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

12397: --This parameter is the id of the user invoking the procedure
12398:
12399:
12400: PROCEDURE PON_LRG_DRAFT_TO_ORD_PF_COPY (
12401: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12402: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12403: p_user_id IN number,
12404: p_from_line_number IN NUMBER,
12405: p_to_line_number IN NUMBER)

Line 12402: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

12398:
12399:
12400: PROCEDURE PON_LRG_DRAFT_TO_ORD_PF_COPY (
12401: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12402: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12403: p_user_id IN number,
12404: p_from_line_number IN NUMBER,
12405: p_to_line_number IN NUMBER)
12406: is

Line 12432: LOG_MESSAGE('PON_LRG_DRAFT_TO_ORD_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);

12428: if l_is_large_neg_enabled = 'Y' then
12429:
12430: if l_current_status = 'DRAFT' then
12431:
12432: LOG_MESSAGE('PON_LRG_DRAFT_TO_ORD_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);
12433:
12434: insert into pon_pf_supplier_values(
12435: auction_header_id,
12436: line_number,

Line 12458: pon_large_neg_pf_values largeNegPFVal

12454: p_user_id,
12455: fnd_global.login_id
12456: from
12457: pon_price_elements price_elements,
12458: pon_large_neg_pf_values largeNegPFVal
12459: where
12460: price_elements.AUCTION_HEADER_ID = p_source_auction_hdr_id and
12461: largeNegPFVal.AUCTION_HEADER_ID = price_elements.AUCTION_HEADER_ID and
12462: price_elements.PRICE_ELEMENT_TYPE_ID = largeNegPFVal.PRICE_ELEMENT_TYPE_ID and

Line 12497: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

12493: --This procedure creates the relevant records for a large destination
12494: --auction in the case of a copy from a large DRAFT to a large auction.
12495: --
12496: --p_source_auction_hdr_id IN
12497: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12498: --This parameter is the auction_header_id of the source auction
12499: --
12500: --p_destination_auction_hdr_id IN
12501: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

Line 12501: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

12497: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12498: --This parameter is the auction_header_id of the source auction
12499: --
12500: --p_destination_auction_hdr_id IN
12501: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12502: --This parameter is the auction_header_id of the destination auction
12503: --
12504: --p_user_id IN
12505: --DATATYPE: NUMBER

Line 12509: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

12505: --DATATYPE: NUMBER
12506: --This parameter is the id of the user invoking the procedure
12507:
12508: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
12509: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12510: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12511: p_user_id IN number)
12512: is
12513: BEGIN

Line 12510: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

12506: --This parameter is the id of the user invoking the procedure
12507:
12508: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
12509: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12510: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12511: p_user_id IN number)
12512: is
12513: BEGIN
12514: --{ start of PON_LRG_DRAFT_TO_LRG_PF_COPY

Line 12519: LOG_MESSAGE('PON_LRG_DRAFT_TO_LRG_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);

12515:
12516: IF (g_auc_doctype_rule_data.ALLOW_PRICE_ELEMENT = 'Y') THEN
12517: -- {
12518:
12519: LOG_MESSAGE('PON_LRG_DRAFT_TO_LRG_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);
12520:
12521: insert into pon_large_neg_pf_values(
12522: auction_header_id,
12523: price_element_type_id,

Line 12521: insert into pon_large_neg_pf_values(

12517: -- {
12518:
12519: LOG_MESSAGE('PON_LRG_DRAFT_TO_LRG_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);
12520:
12521: insert into pon_large_neg_pf_values(
12522: auction_header_id,
12523: price_element_type_id,
12524: pricing_basis,
12525: supplier_seq_number,

Line 12543: from pon_large_neg_pf_values p, pon_price_element_types_vl vl

12539: p_user_id,
12540: sysdate,
12541: p_user_id,
12542: fnd_global.login_id
12543: from pon_large_neg_pf_values p, pon_price_element_types_vl vl
12544: where
12545: p.auction_header_id = p_source_auction_hdr_id and
12546: p.price_element_type_id = vl.price_element_type_id and
12547: vl.enabled_flag = 'Y' and

Line 12565: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

12561: --This procedure creates the relevant records for a large destination
12562: --auction in the case of a copy from a normal DRAFT to a large auction.
12563: --
12564: --p_source_auction_hdr_id IN
12565: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12566: --This parameter is the auction_header_id of the source auction
12567: --
12568: --p_destination_auction_hdr_id IN
12569: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

Line 12569: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

12565: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12566: --This parameter is the auction_header_id of the source auction
12567: --
12568: --p_destination_auction_hdr_id IN
12569: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
12570: --This parameter is the auction_header_id of the destination auction
12571: --
12572: --p_user_id IN
12573: --DATATYPE: NUMBER

Line 12577: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

12573: --DATATYPE: NUMBER
12574: --This parameter is the id of the user invoking the procedure
12575:
12576: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
12577: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12578: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12579: p_user_id IN number)
12580: is
12581: BEGIN

Line 12578: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

12574: --This parameter is the id of the user invoking the procedure
12575:
12576: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
12577: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12578: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
12579: p_user_id IN number)
12580: is
12581: BEGIN
12582: --{ start of PON_ORD_DRAFT_TO_LRG_PF_COPY

Line 12586: LOG_MESSAGE('PON_ORD_DRAFT_TO_LRG_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);

12582: --{ start of PON_ORD_DRAFT_TO_LRG_PF_COPY
12583:
12584: IF (g_auc_doctype_rule_data.ALLOW_PRICE_ELEMENT = 'Y') THEN
12585: -- {
12586: LOG_MESSAGE('PON_ORD_DRAFT_TO_LRG_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);
12587:
12588: insert into pon_large_neg_pf_values(
12589: auction_header_id,
12590: price_element_type_id,

Line 12588: insert into pon_large_neg_pf_values(

12584: IF (g_auc_doctype_rule_data.ALLOW_PRICE_ELEMENT = 'Y') THEN
12585: -- {
12586: LOG_MESSAGE('PON_ORD_DRAFT_TO_LRG_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);
12587:
12588: insert into pon_large_neg_pf_values(
12589: auction_header_id,
12590: price_element_type_id,
12591: pricing_basis,
12592: supplier_seq_number,