[Home] [Help]
68: END get_auction_header_id;
69:
70:
71: FUNCTION get_response_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2 IS
72: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;
73: x_response_doc_name Varchar2(30);
74: BEGIN
75: select DOCTYPE_GROUP_NAME
76: into x_doctype_grp_name
73: x_response_doc_name Varchar2(30);
74: BEGIN
75: select DOCTYPE_GROUP_NAME
76: into x_doctype_grp_name
77: from pon_auc_doctypes
78: where DOCTYPE_ID = p_doc_type_id;
79: if(x_doctype_grp_name = SRC_AUCTION) then
80: x_response_doc_name:= BID;
81: elsif (x_doctype_grp_name = SRC_REQUEST_FOR_QUOTE) then
90: END get_response_doc_type;
91:
92:
93: FUNCTION get_negotiation_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2 IS
94: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;
95: x_contract_doc_name Varchar2(30);
96: BEGIN
97: select DOCTYPE_GROUP_NAME
98: into x_doctype_grp_name
95: x_contract_doc_name Varchar2(30);
96: BEGIN
97: select DOCTYPE_GROUP_NAME
98: into x_doctype_grp_name
99: from pon_auc_doctypes
100: where DOCTYPE_ID = p_doc_type_id;
101: if(x_doctype_grp_name = SRC_AUCTION) then
102: x_contract_doc_name:= AUCTION;
103: elsif (x_doctype_grp_name = SRC_REQUEST_FOR_QUOTE) then