APPS.CS_TP_TEMPLATES_PVT dependencies on DUAL

Line 234: select cs_tp_templates_s.nextval into l_template_id from dual;

230: raise fnd_api.g_exc_error;
231: end if;
232:
233: --Get the template id from the next available sequence number
234: select cs_tp_templates_s.nextval into l_template_id from dual;
235:
236: l_current_date := sysdate;
237: l_created_by := fnd_global.user_id;
238: l_login := fnd_global.login_id;

Line 579: Select CS_TP_TEMPLATE_ATTRIBUTE_S.NextVal Into l_attribute_id From dual;

575:
576: If (l_One_Template_Attribute.mAttributeID is NULL
577: OR l_One_Template_Attribute.mAttributeID = FND_API.G_MISS_NUM) Then
578: -- need to insert into the Attribute Table
579: Select CS_TP_TEMPLATE_ATTRIBUTE_S.NextVal Into l_attribute_id From dual;
580:
581: CS_TP_TEMPLATE_ATTRIBUTE_PKG.INSERT_ROW (
582: x_rowid => l_Row_ID ,
583: x_template_attribute_id => l_attribute_id,

Line 702: Select CS_TP_TEMPLATE_LINKS_S.nextval Into l_New_Link_id From dual;

698: If (l_One_Template_Link.mLinkID Is Null
699: Or l_One_Template_Link.mLinkID = FND_API.G_MISS_NUM) Then
700:
701: --Get the template id from the next available sequence number
702: Select CS_TP_TEMPLATE_LINKS_S.nextval Into l_New_Link_id From dual;
703: CS_TP_TEMPLATE_LINKS_PKG.INSERT_ROW (
704: x_rowid => l_Row_ID ,
705: x_link_id => l_New_Link_id,
706: x_template_id => P_Template_ID,

Line 3241: Select CS_TP_TEMPLATE_LINKS_S.nextval Into l_New_Link_id From dual;

3237: If (l_One_Template_Link.mLinkID Is Null
3238: Or l_One_Template_Link.mLinkID = FND_API.G_MISS_NUM) Then
3239:
3240: --Get the template id from the next available sequence number
3241: Select CS_TP_TEMPLATE_LINKS_S.nextval Into l_New_Link_id From dual;
3242: CS_TP_TEMPLATE_LINKS_PKG.INSERT_ROW (
3243: x_rowid => l_Row_ID ,
3244: x_link_id => l_New_Link_id,
3245: x_template_id => P_Template_ID,