eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TP_TEMPLATES_PVT dependencies on CS_TP_TEMPLATE_LINKS

Line 664: From CS_TP_TEMPLATE_LINKS

660: From CS_TP_TEMPLATES_B
661: Where template_id = P_Template_ID;
662: CURSOR Need_To_Be_Delete_Cursor (v_current_date DATE) IS
663: Select link_id
664: From CS_TP_TEMPLATE_LINKS
665: Where template_id = P_Template_ID
666: and OBJECT_CODE = P_JTF_OBJECT_CODE
667: and last_update_date < v_current_date ;
668: BEGIN

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 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 1137: l_sel_template_from := 'CS_TP_TEMPLATE_LINKS A' || i;

1133: If ( profileOn ) Then
1134: needBind ( i ) := 1;
1135: If ( l_sel_template_where Is Null ) Then
1136: firstOne := i;
1137: l_sel_template_from := 'CS_TP_TEMPLATE_LINKS A' || i;
1138: If (P_Object_Other_list(i).mOBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1139: l_sel_template_where := 'A' || i || '.OBJECT_CODE = :v_Object_Code'
1140: || i || ' and ' ||'A' || i
1141: || '.OTHER_ID = :v_Other_ID' || i ;

Line 1148: l_sel_template_from := l_sel_template_from ||', CS_TP_TEMPLATE_LINKS A' || i;

1144: || i || ' and ' || 'A' || i
1145: || '.LOOKUP_CODE = :v_Other_Code' || i ;
1146: End If;
1147: Else
1148: l_sel_template_from := l_sel_template_from ||', CS_TP_TEMPLATE_LINKS A' || i;
1149:
1150: If(P_Object_Other_list(i).mOBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1151: l_sel_template_where := l_sel_template_where || ' and ' ||'A' || i
1152: || '.OBJECT_CODE = :v_Object_Code' || i

Line 1529: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

1525: || ', '
1526: || l_SELECT_DETAIL
1527: || ','
1528: || l_SELECT_ID
1529: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
1530: || l_FROM_TABLE
1531: || ' WHERE '
1532: || l_WHERE_CLAUSE
1533: || ' AND LINK.OTHER_ID = '

Line 1547: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

1543: || ', '
1544: || l_SELECT_DETAIL
1545: || ', '
1546: || l_SELECT_ID
1547: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
1548: || l_FROM_TABLE
1549: || ' WHERE '
1550: || l_WHERE_CLAUSE
1551: || ' AND LINK.OTHER_ID = '

Line 1570: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

1566: || ', '
1567: || l_SELECT_DETAIL
1568: || ','
1569: || l_SELECT_ID
1570: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
1571: || l_FROM_TABLE
1572: || ' WHERE '
1573: || l_WHERE_CLAUSE
1574: || ' AND LINK.LOOKUP_CODE = '

Line 1588: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

1584: || ', '
1585: || l_SELECT_DETAIL
1586: || ', '
1587: || l_SELECT_ID
1588: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
1589: || l_FROM_TABLE
1590: || ' WHERE '
1591: || l_WHERE_CLAUSE
1592: || ' AND LINK.LOOKUP_CODE = '

Line 1745: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

1741: || l_WHERE_CLAUSE
1742: || ' AND '
1743: || ' NOT EXISTS (SELECT '
1744: || '''x'''
1745: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
1746: || ' :P_Template_ID '
1747: || ' AND LINK.OBJECT_CODE ='''
1748: || P_JTF_OBJECT_CODE
1749: || ''' AND LINK.OTHER_ID = '

Line 1766: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

1762: || l_WHERE_CLAUSE
1763: || ' AND '
1764: || ' NOT EXISTS (SELECT '
1765: || '''x'''
1766: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
1767: || ' :P_Template_ID '
1768: || ' AND LINK.OBJECT_CODE ='''
1769: || P_JTF_OBJECT_CODE
1770: || ''' AND LINK.OTHER_ID = '

Line 1791: || ' NOT IN (SELECT LOOUP_CODE FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

1787: || ' WHERE '
1788: || l_WHERE_CLAUSE
1789: || ' AND '
1790: || l_SELECT_ID
1791: || ' NOT IN (SELECT LOOUP_CODE FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
1792: || ' :P_Template_ID '
1793: || ' AND LINK.OBJECT_CODE ='''
1794: || P_JTF_OBJECT_CODE
1795: || ''' ) ';

Line 1809: || ' NOT IN (SELECT LOOKUP_CODE FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

1805: || ' WHERE '
1806: || l_WHERE_CLAUSE
1807: || ' AND '
1808: || l_SELECT_ID
1809: || ' NOT IN (SELECT LOOKUP_CODE FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
1810: || ' :P_Template_ID '
1811: || ' AND LINK.OBJECT_CODE ='''
1812: || P_JTF_OBJECT_CODE
1813: || ''' ) ORDER BY '

Line 2561: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

2557: || ', '
2558: || l_SELECT_DETAIL
2559: || ','
2560: || l_SELECT_ID
2561: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
2562: || l_FROM_TABLE
2563: || ' WHERE '
2564: || l_WHERE_CLAUSE
2565: || ' AND LINK.OTHER_ID = '

Line 2579: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

2575: || ', '
2576: || l_SELECT_DETAIL
2577: || ', '
2578: || l_SELECT_ID
2579: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
2580: || l_FROM_TABLE
2581: || ' WHERE '
2582: || l_WHERE_CLAUSE
2583: || ' AND LINK.OTHER_ID = '

Line 2602: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

2598: || ', '
2599: || l_SELECT_DETAIL
2600: || ','
2601: || l_SELECT_ID
2602: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
2603: || l_FROM_TABLE
2604: || ' WHERE '
2605: || l_WHERE_CLAUSE
2606: || ' AND LINK.LOOKUP_CODE = '

Line 2620: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '

2616: || ', '
2617: || l_SELECT_DETAIL
2618: || ', '
2619: || l_SELECT_ID
2620: || ', LINK.LAST_UPDATE_DATE FROM CS_TP_TEMPLATE_LINKS LINK, '
2621: || l_FROM_TABLE
2622: || ' WHERE '
2623: || l_WHERE_CLAUSE
2624: || ' AND LINK.LOOKUP_CODE = '

Line 2905: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

2901: || l_WHERE_CLAUSE
2902: || ' AND '
2903: || ' NOT EXISTS (SELECT '
2904: || '''x'''
2905: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
2906: || ':P_Template_ID'
2907: || ' AND LINK.OBJECT_CODE ='''
2908: || P_JTF_OBJECT_CODE
2909: || ''' AND LINK.OTHER_ID = '

Line 2927: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

2923: || l_WHERE_CLAUSE
2924: || ' AND '
2925: || ' NOT EXISTS (SELECT '
2926: || '''x'''
2927: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
2928: || ':P_Template_ID'
2929: || ' AND LINK.OBJECT_CODE ='''
2930: || P_JTF_OBJECT_CODE
2931: || ''' AND LINK.OTHER_ID = '

Line 2954: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

2950: || l_WHERE_CLAUSE
2951: || ' AND '
2952: || ' NOT EXISTS (SELECT '
2953: || '''x'''
2954: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
2955: || ':P_Template_ID'
2956: || ' AND LINK.OBJECT_CODE ='''
2957: || P_JTF_OBJECT_CODE
2958: || ''' AND LINK.LOOKUP_CODE = '

Line 2975: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '

2971: || l_WHERE_CLAUSE
2972: || ' AND '
2973: || ' NOT EXISTS (SELECT '
2974: || '''x'''
2975: || ' FROM CS_TP_TEMPLATE_LINKS LINK WHERE LINK.TEMPLATE_ID = '
2976: || ':P_Template_ID'
2977: || ' AND LINK.OBJECT_CODE ='''
2978: || P_JTF_OBJECT_CODE
2979: || ''' AND LINK.LOOKUP_CODE = '

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 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,

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,