APPS.CS_TP_TEMPLATES_PVT dependencies on CS_TP_TEMPLATE_ATTRIBUTE

Line 487: From cs_tp_template_attribute

483: CURSOR Last_Updated_Date_C (v_template_id NUMBER,
484: v_other_id NUMBER,
485: v_jtf_object_code VARCHAR2) IS
486: Select last_update_date
487: From cs_tp_template_attribute
488: where template_id = v_template_id
489: and other_id = v_other_id
490: and object_code = v_jtf_object_code;
491:

Line 517: perform update the record. Otherwise, insert into the cs_tp_template_attribute

513: Check_Attribute_Error (P_Template_Attributes, X_Return_Status);
514:
515: /* Logic:
516: Loop through each attribute. If the attribute id is present,
517: perform update the record. Otherwise, insert into the cs_tp_template_attribute
518: table
519: */
520: FOR i IN P_Template_Attributes.FIRST..P_Template_Attributes.LAST LOOP
521:

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 581: CS_TP_TEMPLATE_ATTRIBUTE_PKG.INSERT_ROW (

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,
584: x_template_id => P_Template_ID,
585: x_other_id => l_One_Template_Attribute.mOther_ID,

Line 596: CS_TP_TEMPLATE_ATTRIBUTE_PKG.UPDATE_ROW (

592: x_last_update_date => l_current_date,
593: x_last_updated_by => l_created_by,
594: x_last_update_login => l_login);
595: Else
596: CS_TP_TEMPLATE_ATTRIBUTE_PKG.UPDATE_ROW (
597: x_template_attribute_id => l_One_Template_Attribute.mAttributeID,
598: x_template_id => P_Template_ID,
599: x_other_id => l_One_Template_Attribute.mOther_ID,
600: x_object_code => l_One_Template_Attribute.mJTF_OBJECT_CODE,

Line 1360: || ', INT.LAST_UPDATE_DATE, INT.ATTRIBUTE1 FROM (SELECT * FROM CS_TP_TEMPLATE_ATTRIBUTE ATTR, '

1356: l_statement := 'SELECT INT.TEMPLATE_ATTRIBUTE_ID, JTFO.'
1357: || l_SELECT_NAME
1358: || ', INT.START_THRESHOLD, INT.END_THRESHOLD, JTFO.'
1359: || l_SELECT_ID
1360: || ', INT.LAST_UPDATE_DATE, INT.ATTRIBUTE1 FROM (SELECT * FROM CS_TP_TEMPLATE_ATTRIBUTE ATTR, '
1361: || l_FROM_TABLE
1362: || ' INNER WHERE '
1363: || l_where_clause
1364: || ' and ATTR.OTHER_ID =INNER.'

Line 1381: || ', INT.LAST_UPDATE_DATE, INT.ATTRIBUTE1 FROM (SELECT ATTR.* FROM CS_TP_TEMPLATE_ATTRIBUTE ATTR, '

1377: l_statement := 'SELECT INT.TEMPLATE_ATTRIBUTE_ID, JTFO.'
1378: || l_SELECT_NAME
1379: || ', INT.START_THRESHOLD, INT.END_THRESHOLD, JTFO.'
1380: || l_SELECT_ID
1381: || ', INT.LAST_UPDATE_DATE, INT.ATTRIBUTE1 FROM (SELECT ATTR.* FROM CS_TP_TEMPLATE_ATTRIBUTE ATTR, '
1382: || l_FROM_TABLE
1383: || ' INNER WHERE '
1384: || l_where_clause
1385: || ' and ATTR.OTHER_ID =INNER.'