DBA Data[Home] [Help]

APPS.PON_CONTERMS_UTL_PVT dependencies on PON_AUC_DOCTYPES

Line 72: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;

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

Line 77: from pon_auc_doctypes

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

Line 94: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;

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

Line 99: from pon_auc_doctypes

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