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_AUC_DOCTYPES

Line 46: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

42: -- Global variable to hold the Document Number variable
43: g_neg_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
44:
45: -- Global variable for message sufix
46: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
47:
48: -- Global variable for auction_origination_code
49: g_auc_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
50:

Line 649: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;

645: l_retain_attachments VARCHAR2(1);
646: l_last_amendment_number NUMBER := 0;
647: l_org_id NUMBER := 0;
648: l_round_number NUMBER := 0;
649: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
650: l_source_auc_orig_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
651: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
652:
653: --This variable is used to store the document number of the new auction

Line 959: FROM PON_AUCTION_HEADERS_ALL A, PON_AUC_DOCTYPES D

955: A.PRICE_BREAK_RESPONSE
956: INTO l_source_doctype_id, l_source_orig_round_id, l_source_prev_round_id, l_round_number,
957: l_last_amendment_number, l_source_orig_amend_id, l_org_id, l_source_doctype_grp_name,
958: g_message_suffix, l_source_auc_orig_code,l_source_doc_num, g_price_break_response
959: FROM PON_AUCTION_HEADERS_ALL A, PON_AUC_DOCTYPES D
960: WHERE auction_header_id = p_source_auction_header_id AND D.DOCTYPE_ID = A.DOCTYPE_ID ;
961: EXCEPTION
962: WHEN NO_DATA_FOUND THEN
963: -- The way I am adding this error may get changed in the future.

Line 1484: l_destination_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;

1480: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1481: l_contract_terms_exisits VARCHAR2(2);
1482: l_contract_doctype VARCHAR2(50);
1483: l_is_award_approval_reqd VARCHAR2(2);
1484: l_destination_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1485:
1486: l_disp_best_price_blind VARCHAR2(1) := NULL;
1487: l_val2 VARCHAR2(300) := NULL;
1488: l_val3 VARCHAR2(300) := NULL;

Line 1525: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A

1521: IF ( p_copy_type = g_rfi_to_other_copy) THEN
1522: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1523: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1524: l_source_doc_number
1525: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1526: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1527: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1528:
1529: LOG_MESSAGE('copy_negotiation','1.1.0.1 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);

Line 1546: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A

1542: IF ( p_copy_type = g_new_rnd_copy AND p_doctype_id <> p_source_doctype_id) THEN
1543: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1544: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1545: l_source_doc_number
1546: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1547: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1548: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1549:
1550: LOG_MESSAGE('copy_negotiation','1.1.0.2 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);

Line 1806: FROM PON_AUC_DOCTYPES

1802: BEGIN
1803: g_err_loc := '1.2 Checking the destination doctype group name';
1804: SELECT DOCTYPE_GROUP_NAME
1805: INTO l_destination_doctype_grp_name
1806: FROM PON_AUC_DOCTYPES
1807: WHERE DOCTYPE_ID = p_doctype_id;
1808: EXCEPTION
1809: WHEN OTHERS THEN
1810: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');

Line 8230: PON_AUC_DOCTYPES doctypes

8226: l_d_doctype_name,
8227: l_d_hdr_attr_enabled_flag
8228: FROM
8229: PON_AUCTION_HEADERS_ALL hdr,
8230: PON_AUC_DOCTYPES doctypes
8231: WHERE
8232: hdr.auction_header_id = l_auction_header_id AND
8233: doctypes.DOCTYPE_ID = p_doctype_id;
8234:

Line 8308: PON_AUC_DOCTYPES doctypes

8304: l_s_hdr_attr_enabled_flag,
8305: l_s_pe_enabled_flag
8306: FROM
8307: PON_AUCTION_HEADERS_ALL hdr,
8308: PON_AUC_DOCTYPES doctypes
8309: WHERE
8310: auction_header_id = p_source_auction_header_id AND
8311: doctypes.DOCTYPE_ID = hdr.DOCTYPE_ID;
8312:

Line 9295: FROM PON_AUC_DOCTYPES

9291: BEGIN
9292: g_err_loc := '1.1.2 Checking if this is copy to RFI';
9293: SELECT DOCTYPE_ID
9294: INTO l_rfi_doctype_id
9295: FROM PON_AUC_DOCTYPES
9296: WHERE DOCTYPE_GROUP_NAME = 'REQUEST_FOR_INFORMATION';
9297: EXCEPTION
9298: WHEN OTHERS THEN
9299: -- The way I am adding this error may get changed in the future.

Line 9313: FROM PON_AUC_DOCTYPES

9309: BEGIN
9310: g_err_loc := '1.1.2 Checking if this is copy to RFQ';
9311: SELECT DOCTYPE_ID
9312: INTO l_rfq_doctype_id
9313: FROM PON_AUC_DOCTYPES
9314: WHERE DOCTYPE_GROUP_NAME = 'REQUEST_FOR_QUOTE';
9315: EXCEPTION
9316: WHEN OTHERS THEN
9317: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');

Line 9329: FROM PON_AUC_DOCTYPES

9325: BEGIN
9326: g_err_loc := '1.1.2 Checking if this is copy to Auction';
9327: SELECT DOCTYPE_ID
9328: INTO l_auction_doctype_id
9329: FROM PON_AUC_DOCTYPES
9330: WHERE DOCTYPE_GROUP_NAME = 'BUYER_AUCTION';
9331: EXCEPTION
9332: WHEN OTHERS THEN
9333: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');