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 361: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

357: x_msg_data OUT NOCOPY VARCHAR2
358: );
359:
360: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
361: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
362: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
363: p_user_id IN number);
364:
365: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (

Line 362: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

358: );
359:
360: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
361: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
362: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
363: p_user_id IN number);
364:
365: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
366: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

Line 366: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

362: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
363: p_user_id IN number);
364:
365: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
366: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
367: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
368: p_user_id IN number);
369:
370: procedure renumber_lines(p_auction_header_id IN NUMBER);

Line 367: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

363: p_user_id IN number);
364:
365: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
366: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
367: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
368: p_user_id IN number);
369:
370: procedure renumber_lines(p_auction_header_id IN NUMBER);
371:

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

10943: --This procedure willbe called even in the case of publish, and in this case
10944: --p_source_auction_hdr_id = p_destination_auction_hdr_id
10945: --
10946: --p_source_auction_hdr_id IN
10947: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
10948: --This parameter is the auction_header_id of the source auction
10949: --
10950: --p_destination_auction_hdr_id IN
10951: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

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

10947: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
10948: --This parameter is the auction_header_id of the source auction
10949: --
10950: --p_destination_auction_hdr_id IN
10951: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
10952: --This parameter is the auction_header_id of the destination auction
10953: --
10954: --p_user_id IN
10955: --DATATYPE: NUMBER

Line 10960: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

10956: --This parameter is the id of the user invoking the procedure
10957:
10958:
10959: PROCEDURE PON_LRG_DRAFT_TO_ORD_PF_COPY (
10960: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
10961: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
10962: p_user_id IN number,
10963: p_from_line_number IN NUMBER,
10964: p_to_line_number IN NUMBER)

Line 10961: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

10957:
10958:
10959: PROCEDURE PON_LRG_DRAFT_TO_ORD_PF_COPY (
10960: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
10961: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
10962: p_user_id IN number,
10963: p_from_line_number IN NUMBER,
10964: p_to_line_number IN NUMBER)
10965: is

Line 10991: 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);

10987: if l_is_large_neg_enabled = 'Y' then
10988:
10989: if l_current_status = 'DRAFT' then
10990:
10991: 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);
10992:
10993: insert into pon_pf_supplier_values(
10994: auction_header_id,
10995: line_number,

Line 11017: pon_large_neg_pf_values largeNegPFVal

11013: p_user_id,
11014: fnd_global.login_id
11015: from
11016: pon_price_elements price_elements,
11017: pon_large_neg_pf_values largeNegPFVal
11018: where
11019: price_elements.AUCTION_HEADER_ID = p_source_auction_hdr_id and
11020: largeNegPFVal.AUCTION_HEADER_ID = price_elements.AUCTION_HEADER_ID and
11021: price_elements.PRICE_ELEMENT_TYPE_ID = largeNegPFVal.PRICE_ELEMENT_TYPE_ID and

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

11052: --This procedure creates the relevant records for a large destination
11053: --auction in the case of a copy from a large DRAFT to a large auction.
11054: --
11055: --p_source_auction_hdr_id IN
11056: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
11057: --This parameter is the auction_header_id of the source auction
11058: --
11059: --p_destination_auction_hdr_id IN
11060: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

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

11056: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
11057: --This parameter is the auction_header_id of the source auction
11058: --
11059: --p_destination_auction_hdr_id IN
11060: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
11061: --This parameter is the auction_header_id of the destination auction
11062: --
11063: --p_user_id IN
11064: --DATATYPE: NUMBER

Line 11068: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

11064: --DATATYPE: NUMBER
11065: --This parameter is the id of the user invoking the procedure
11066:
11067: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
11068: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11069: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11070: p_user_id IN number)
11071: is
11072: BEGIN

Line 11069: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

11065: --This parameter is the id of the user invoking the procedure
11066:
11067: PROCEDURE PON_LRG_DRAFT_TO_LRG_PF_COPY (
11068: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11069: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11070: p_user_id IN number)
11071: is
11072: BEGIN
11073: --{ start of PON_LRG_DRAFT_TO_LRG_PF_COPY

Line 11078: 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);

11074:
11075: IF (g_auc_doctype_rule_data.ALLOW_PRICE_ELEMENT = 'Y') THEN
11076: -- {
11077:
11078: 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);
11079:
11080: insert into pon_large_neg_pf_values(
11081: auction_header_id,
11082: price_element_type_id,

Line 11080: insert into pon_large_neg_pf_values(

11076: -- {
11077:
11078: 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);
11079:
11080: insert into pon_large_neg_pf_values(
11081: auction_header_id,
11082: price_element_type_id,
11083: pricing_basis,
11084: supplier_seq_number,

Line 11102: from pon_large_neg_pf_values p, pon_price_element_types_vl vl

11098: p_user_id,
11099: sysdate,
11100: p_user_id,
11101: fnd_global.login_id
11102: from pon_large_neg_pf_values p, pon_price_element_types_vl vl
11103: where
11104: p.auction_header_id = p_source_auction_hdr_id and
11105: p.price_element_type_id = vl.price_element_type_id and
11106: vl.enabled_flag = 'Y' and

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

11120: --This procedure creates the relevant records for a large destination
11121: --auction in the case of a copy from a normal DRAFT to a large auction.
11122: --
11123: --p_source_auction_hdr_id IN
11124: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
11125: --This parameter is the auction_header_id of the source auction
11126: --
11127: --p_destination_auction_hdr_id IN
11128: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type

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

11124: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
11125: --This parameter is the auction_header_id of the source auction
11126: --
11127: --p_destination_auction_hdr_id IN
11128: --DATATYPE: pon_large_neg_pf_values.AUCTION_HEADER_ID%type
11129: --This parameter is the auction_header_id of the destination auction
11130: --
11131: --p_user_id IN
11132: --DATATYPE: NUMBER

Line 11136: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

11132: --DATATYPE: NUMBER
11133: --This parameter is the id of the user invoking the procedure
11134:
11135: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
11136: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11137: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11138: p_user_id IN number)
11139: is
11140: BEGIN

Line 11137: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,

11133: --This parameter is the id of the user invoking the procedure
11134:
11135: PROCEDURE PON_ORD_DRAFT_TO_LRG_PF_COPY (
11136: p_source_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11137: p_destination_auction_hdr_id IN pon_large_neg_pf_values.AUCTION_HEADER_ID%type,
11138: p_user_id IN number)
11139: is
11140: BEGIN
11141: --{ start of PON_ORD_DRAFT_TO_LRG_PF_COPY

Line 11145: 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);

11141: --{ start of PON_ORD_DRAFT_TO_LRG_PF_COPY
11142:
11143: IF (g_auc_doctype_rule_data.ALLOW_PRICE_ELEMENT = 'Y') THEN
11144: -- {
11145: 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);
11146:
11147: insert into pon_large_neg_pf_values(
11148: auction_header_id,
11149: price_element_type_id,

Line 11147: insert into pon_large_neg_pf_values(

11143: IF (g_auc_doctype_rule_data.ALLOW_PRICE_ELEMENT = 'Y') THEN
11144: -- {
11145: 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);
11146:
11147: insert into pon_large_neg_pf_values(
11148: auction_header_id,
11149: price_element_type_id,
11150: pricing_basis,
11151: supplier_seq_number,