838: T.LAST_UPDATE_DATE,
839: T.ATTRIBUTE1,
840: T.UNI_QUESTION_NOTE_FLAG,
841: T.UNI_QUESTION_NOTE_TYPE ' ||
842: ' FROM CS_TP_TEMPLATES_VL T ';
843: If (p_template_name Is Not Null
844: and p_template_name <> FND_API.G_MISS_CHAR
845: and length(P_Template_Name) > 0) Then
846: l_statement := l_statement ||
971: T.LAST_UPDATE_DATE,
972: T.ATTRIBUTE1,
973: T.UNI_QUESTION_NOTE_FLAG,
974: T.UNI_QUESTION_NOTE_TYPE
975: From CS_TP_TEMPLATES_VL T
976: Where T.TEMPLATE_ID = tempId ;
977:
978: l_tp_template_rec l_tp_templates_csr%ROWTYPE;
979:
2006: T.LAST_UPDATE_DATE,
2007: T.ATTRIBUTE1,
2008: T.UNI_QUESTION_NOTE_FLAG,
2009: T.UNI_QUESTION_NOTE_TYPE
2010: From CS_TP_TEMPLATES_VL T
2011: Where T.DEFAULT_FLAG = dFlag;
2012: l_tp_template_rec l_tp_template_csr%ROWTYPE;
2013: BEGIN
2014: -- Initialize message list if p_init_msg_list is set to TRUE.