APPS.CS_TP_TEMPLATES_PVT dependencies on CS_TP_TEMPLATE_LINKS_PKG

Line 703: CS_TP_TEMPLATE_LINKS_PKG.INSERT_ROW (

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,
707: x_other_id => l_One_Template_Link.mOther_ID,

Line 717: CS_TP_TEMPLATE_LINKS_PKG.UPDATE_ROW (

713: x_last_update_date => l_current_date,
714: x_last_updated_by => l_created_by,
715: x_last_update_login => l_login);
716: Else
717: CS_TP_TEMPLATE_LINKS_PKG.UPDATE_ROW (
718: x_link_id => l_One_Template_Link.mLinkID,
719: x_template_id => P_Template_ID,
720: x_other_id => l_One_Template_Link.mOther_ID,
721: x_lookup_code => l_One_Template_Link.lookup_Code,

Line 745: CS_TP_TEMPLATE_LINKS_PKG.DELETE_ROW

741: Close Need_To_Be_Delete_Cursor;
742:
743: If (l_Need_To_Be_Delete_List.COUNT > 0) Then
744: For i In l_Need_To_Be_Delete_List.FIRST..l_Need_To_Be_Delete_List.LAST Loop
745: CS_TP_TEMPLATE_LINKS_PKG.DELETE_ROW
746: ( X_LINK_ID =>l_Need_To_Be_Delete_List(i));
747: End Loop;
748: End If;
749:

Line 3160: CS_TP_TEMPLATE_LINKS_PKG.DELETE_ROW

3156:
3157: If (P_Template_Links.COUNT >0) Then
3158: For i In P_Template_Links.FIRST..P_Template_Links.LAST Loop
3159: l_One_Template_Link := P_Template_Links (i);
3160: CS_TP_TEMPLATE_LINKS_PKG.DELETE_ROW
3161: ( X_LINK_ID =>l_One_Template_Link.mLinkID);
3162: End Loop;
3163: End If;
3164:

Line 3242: CS_TP_TEMPLATE_LINKS_PKG.INSERT_ROW (

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,
3246: x_other_id => l_One_Template_Link.mOther_ID,

Line 3256: CS_TP_TEMPLATE_LINKS_PKG.UPDATE_ROW (

3252: x_last_update_date => l_current_date,
3253: x_last_updated_by => l_created_by,
3254: x_last_update_login => l_login);
3255: Else
3256: CS_TP_TEMPLATE_LINKS_PKG.UPDATE_ROW (
3257: x_link_id => l_One_Template_Link.mLinkID,
3258: x_template_id => P_Template_ID,
3259: x_other_id => l_One_Template_Link.mOther_ID,
3260: x_lookup_code => l_One_Template_Link.lookup_Code,