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.CAC_TASK_PURGE_PVT dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 856: Select temp.object_id From JTF_OBJECT_PURGE_PARAM_TMP temp, fnd_attached_documents fad

852: l_entity_name VARCHAR2(40):='JTF_TASKS_B';
853:
854: Cursor C_Task_Id Is
855:
856: Select temp.object_id From JTF_OBJECT_PURGE_PARAM_TMP temp, fnd_attached_documents fad
857: Where temp.object_type = 'TASK'
858: And temp.processing_set_id = p_processing_set_id
859: And NVL(temp.purge_status,'Y') <> 'E'
860: and fad.entity_name='JTF_TASKS_B'

Line 902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');

898: -- Statement level Logging
899: ----------------------------
900: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
901: THEN
902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');
903: END IF;
904:
905:
906: Open C_Task_Id;

Line 958: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)

954: );
955: IF l_tab_task_id.COUNT > 0
956: THEN
957: FORALL j IN l_tab_task_id.FIRST..l_tab_task_id.LAST
958: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)
959: Where object_type = 'TASK'
960: And processing_set_id = p_processing_set_id
961: And object_id = l_tab_task_id(j);
962: END IF;

Line 989: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)

985:
986: IF l_tab_task_id.COUNT > 0
987: THEN
988: FORALL j IN l_tab_task_id.FIRST..l_tab_task_id.LAST
989: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)
990: Where object_type = 'TASK'
991: And processing_set_id = p_processing_set_id
992: And object_id = l_tab_task_id(j);
993: END IF;

Line 1109: Update JTF_OBJECT_PURGE_PARAM_TMP

1105: p_count => x_msg_count,
1106: p_data => x_msg_data
1107: );
1108:
1109: Update JTF_OBJECT_PURGE_PARAM_TMP
1110: Set purge_status='E',
1111: purge_error_message=SUBSTRB(x_msg_data,1,4000)
1112: Where object_type = 'TASK'
1113: And processing_set_id = p_processing_set_id;

Line 1137: Update JTF_OBJECT_PURGE_PARAM_TMP

1133: p_count => x_msg_count,
1134: p_data => x_msg_data
1135: );
1136:
1137: Update JTF_OBJECT_PURGE_PARAM_TMP
1138: Set purge_status='E',
1139: purge_error_message=SUBSTRB(x_msg_data,1,4000)
1140: Where object_type = 'TASK'
1141: And processing_set_id = p_processing_set_id;

Line 1181: From JTF_OBJECT_PURGE_PARAM_TMP

1177: And NVL(purge_status,'Y') <> 'E';
1178:
1179: Cursor C_Error_Tmp Is
1180: Select object_type, object_id, purge_status, purge_error_message
1181: From JTF_OBJECT_PURGE_PARAM_TMP
1182: Where object_type = 'TASK'
1183: And processing_set_id = l_processing_set_id
1184: And purge_status IS NOT NULL;
1185:

Line 1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Inserting data into temp table - JTF_OBJECT_PURGE_PARAM_TMP');

1264: -- Statement level Logging
1265: ----------------------------
1266: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1267: THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Inserting data into temp table - JTF_OBJECT_PURGE_PARAM_TMP');
1269: END IF;
1270:
1271:
1272: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST

Line 1273: Insert Into JTF_OBJECT_PURGE_PARAM_TMP (object_type,

1269: END IF;
1270:
1271:
1272: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST
1273: Insert Into JTF_OBJECT_PURGE_PARAM_TMP (object_type,
1274: object_id,
1275: processing_set_id,
1276: purge_status,
1277: purge_error_message)

Line 1643: Select object_id From JTF_OBJECT_PURGE_PARAM_TMP

1639: l_api_version CONSTANT NUMBER := 1.0;
1640: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_TASK_ENTITIES';
1641:
1642: Cursor C_Task_Id Is
1643: Select object_id From JTF_OBJECT_PURGE_PARAM_TMP
1644: Where object_type = p_object_type
1645: And processing_set_id = p_processing_set_id
1646: And NVL(purge_status,'Y') <> 'E';
1647:

Line 1693: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');

1689: -- Statement level Logging
1690: ----------------------------
1691: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1692: THEN
1693: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');
1694: END IF;
1695:
1696:
1697: Open C_Task_Id;

Line 1974: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)

1970: );
1971: IF l_tab_task_id.COUNT > 0
1972: THEN
1973: FORALL j IN l_tab_task_id.FIRST..l_tab_task_id.LAST
1974: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)
1975: Where object_type = p_object_type
1976: And processing_set_id = p_processing_set_id
1977: And object_id = l_tab_task_id(j);
1978: END IF;

Line 2005: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)

2001:
2002: IF l_tab_task_id.COUNT > 0
2003: THEN
2004: FORALL j IN l_tab_task_id.FIRST..l_tab_task_id.LAST
2005: Update JTF_OBJECT_PURGE_PARAM_TMP Set purge_status='E', purge_error_message=SUBSTRB(x_msg_data,1,4000)
2006: Where object_type = p_object_type
2007: And processing_set_id = p_processing_set_id
2008: And object_id = l_tab_task_id(j);
2009: END IF;