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 53: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

49: -- Global variable to hold the Document Number variable
50: g_neg_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
51:
52: -- Global variable for message sufix
53: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
54:
55: -- Global variable for auction_origination_code
56: g_auc_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
57:

Line 692: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;

688: l_retain_attachments VARCHAR2(1);
689: l_last_amendment_number NUMBER := 0;
690: l_org_id NUMBER := 0;
691: l_round_number NUMBER := 0;
692: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
693: l_source_auc_orig_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
694: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
695:
696: --This variable is used to store the document number of the new auction

Line 1062: FROM PON_AUCTION_HEADERS_ALL A, PON_AUC_DOCTYPES D

1058: A.PRICE_BREAK_RESPONSE
1059: INTO l_source_doctype_id, l_source_orig_round_id, l_source_prev_round_id, l_round_number,
1060: l_last_amendment_number, l_source_orig_amend_id, l_org_id, l_source_doctype_grp_name,
1061: g_message_suffix, l_source_auc_orig_code,l_source_doc_num, g_price_break_response
1062: FROM PON_AUCTION_HEADERS_ALL A, PON_AUC_DOCTYPES D
1063: WHERE auction_header_id = p_source_auction_header_id AND D.DOCTYPE_ID = A.DOCTYPE_ID ;
1064: EXCEPTION
1065: WHEN NO_DATA_FOUND THEN
1066: -- The way I am adding this error may get changed in the future.

Line 1384: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A

1380: -- internal name if it is copy from RFI to Auction/RFQ. Set it to NULL
1381: -- for the active negotiation copy. Carry it in all other cases
1382: IF (p_copy_type = g_rfi_to_other_copy) THEN
1383: SELECT INTERNAL_NAME INTO l_source_doc_internal_name
1384: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1385: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1386: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1387: g_auc_origination_code := l_source_doc_internal_name;
1388: ELSIF (p_copy_type = g_active_neg_copy) THEN

Line 1911: l_destination_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;

1907: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1908: l_contract_terms_exisits VARCHAR2(2);
1909: l_contract_doctype VARCHAR2(50);
1910: l_is_award_approval_reqd VARCHAR2(2);
1911: l_destination_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1912:
1913: l_disp_best_price_blind VARCHAR2(1) := NULL;
1914: l_val2 VARCHAR2(300) := NULL;
1915: l_val3 VARCHAR2(300) := NULL;

Line 1977: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A

1973: IF ( p_copy_type = g_rfi_to_other_copy) THEN
1974: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1975: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1976: l_source_doc_number
1977: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1978: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1979: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1980:
1981: LOG_MESSAGE('copy_negotiation','1.1.0.1 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);

Line 1998: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A

1994: IF ( p_copy_type = g_new_rnd_copy AND p_doctype_id <> p_source_doctype_id) THEN
1995: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1996: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1997: l_source_doc_number
1998: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1999: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
2000: AND AUCTION_HEADER_ID = p_source_auction_header_id;
2001:
2002: LOG_MESSAGE('copy_negotiation','1.1.0.2 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);

Line 2446: FROM PON_AUC_DOCTYPES

2442: BEGIN
2443: g_err_loc := '1.2 Checking the destination doctype group name';
2444: SELECT DOCTYPE_GROUP_NAME
2445: INTO l_destination_doctype_grp_name
2446: FROM PON_AUC_DOCTYPES
2447: WHERE DOCTYPE_ID = p_doctype_id;
2448: EXCEPTION
2449: WHEN OTHERS THEN
2450: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');

Line 9400: PON_AUC_DOCTYPES doctypes

9396: l_d_doctype_name,
9397: l_d_hdr_attr_enabled_flag
9398: FROM
9399: PON_AUCTION_HEADERS_ALL hdr,
9400: PON_AUC_DOCTYPES doctypes
9401: WHERE
9402: hdr.auction_header_id = l_auction_header_id AND
9403: doctypes.DOCTYPE_ID = p_doctype_id;
9404: l_test_count := 5;

Line 9478: PON_AUC_DOCTYPES doctypes

9474: l_s_hdr_attr_enabled_flag,
9475: l_s_pe_enabled_flag
9476: FROM
9477: PON_AUCTION_HEADERS_ALL hdr,
9478: PON_AUC_DOCTYPES doctypes
9479: WHERE
9480: auction_header_id = p_source_auction_header_id AND
9481: doctypes.DOCTYPE_ID = hdr.DOCTYPE_ID;
9482:

Line 10567: FROM PON_AUC_DOCTYPES

10563: BEGIN
10564: g_err_loc := '1.1.2 Checking if this is copy to RFI';
10565: SELECT DOCTYPE_ID
10566: INTO l_rfi_doctype_id
10567: FROM PON_AUC_DOCTYPES
10568: WHERE DOCTYPE_GROUP_NAME = 'REQUEST_FOR_INFORMATION';
10569: EXCEPTION
10570: WHEN OTHERS THEN
10571: -- The way I am adding this error may get changed in the future.

Line 10585: FROM PON_AUC_DOCTYPES

10581: BEGIN
10582: g_err_loc := '1.1.2 Checking if this is copy to RFQ';
10583: SELECT DOCTYPE_ID
10584: INTO l_rfq_doctype_id
10585: FROM PON_AUC_DOCTYPES
10586: WHERE DOCTYPE_GROUP_NAME = 'REQUEST_FOR_QUOTE';
10587: EXCEPTION
10588: WHEN OTHERS THEN
10589: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');

Line 10603: FROM PON_AUC_DOCTYPES

10599: BEGIN
10600: g_err_loc := '1.1.2 Checking if this is copy to Solicitation';
10601: SELECT DOCTYPE_ID
10602: INTO l_sol_doctype_id
10603: FROM PON_AUC_DOCTYPES
10604: WHERE DOCTYPE_GROUP_NAME = 'SOLICITATION';
10605: EXCEPTION
10606: WHEN OTHERS THEN
10607: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');

Line 10622: FROM PON_AUC_DOCTYPES

10618: BEGIN
10619: g_err_loc := '1.1.2 Checking if this is copy to Auction';
10620: SELECT DOCTYPE_ID
10621: INTO l_auction_doctype_id
10622: FROM PON_AUC_DOCTYPES
10623: WHERE DOCTYPE_GROUP_NAME = 'BUYER_AUCTION';
10624: EXCEPTION
10625: WHEN OTHERS THEN
10626: FND_MESSAGE.SET_NAME('PON','PON_AUC_NO_DATA_EXISTS');