DBA Data[Home] [Help]

APPS.PON_CONTERMS_UTL_PVT dependencies on PON_AUC_DOCTYPES

Line 70: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;

66: END get_auction_header_id;
67:
68:
69: FUNCTION get_response_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2 IS
70: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;
71: x_response_doc_name Varchar2(30);
72: BEGIN
73: select DOCTYPE_GROUP_NAME
74: into x_doctype_grp_name

Line 75: from pon_auc_doctypes

71: x_response_doc_name Varchar2(30);
72: BEGIN
73: select DOCTYPE_GROUP_NAME
74: into x_doctype_grp_name
75: from pon_auc_doctypes
76: where DOCTYPE_ID = p_doc_type_id;
77: if(x_doctype_grp_name = SRC_AUCTION) then
78: x_response_doc_name:= BID;
79: elsif (x_doctype_grp_name = SRC_REQUEST_FOR_QUOTE) then

Line 90: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;

86: END get_response_doc_type;
87:
88:
89: FUNCTION get_negotiation_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2 IS
90: x_doctype_grp_name pon_auc_doctypes.DOCTYPE_GROUP_NAME%type;
91: x_contract_doc_name Varchar2(30);
92: BEGIN
93: select DOCTYPE_GROUP_NAME
94: into x_doctype_grp_name

Line 95: from pon_auc_doctypes

91: x_contract_doc_name Varchar2(30);
92: BEGIN
93: select DOCTYPE_GROUP_NAME
94: into x_doctype_grp_name
95: from pon_auc_doctypes
96: where DOCTYPE_ID = p_doc_type_id;
97: if(x_doctype_grp_name = SRC_AUCTION) then
98: x_contract_doc_name:= AUCTION;
99: elsif (x_doctype_grp_name = SRC_REQUEST_FOR_QUOTE) then