The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT resource_id
FROM jtf_task_assignments jta
, csf_debrief_headers dbh
WHERE jta.task_assignment_id = dbh.task_assignment_id
AND dbh.debrief_header_id = b_debrief_header_id;
SELECT *
FROM CSF_DEBRIEF_HEADERS
WHERE debrief_header_id = b_debrief_header_id;
PROCEDURE Insert_ACC_Record
( p_debrief_header_id IN NUMBER
,p_resource_id IN NUMBER
)
IS
BEGIN
IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
jtm_message_log_pkg.Log_Msg
( p_debrief_header_id
, g_table_name
, 'Entering Insert_ACC_Record'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
, 'Inserting ACC record for resource_id = ' || p_resource_id
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
/*** Insert debrief header ACC record ***/
JTM_HOOK_UTIL_PKG.Insert_Acc
( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
,P_ACC_TABLE_NAME => g_acc_table_name
,P_PK1_NAME => g_pk1_name
,P_PK1_NUM_VALUE => p_debrief_header_id
,P_RESOURCE_ID => p_resource_id
);
, 'Leaving Insert_ACC_Record'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
END Insert_ACC_Record;
PROCEDURE Update_ACC_Record
( p_debrief_header_id IN NUMBER
,p_resource_id IN NUMBER
,p_acc_id IN NUMBER
)
IS
BEGIN
IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
jtm_message_log_pkg.Log_Msg
( p_debrief_header_id
, g_table_name
, 'Entering Update_ACC_Record'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
/*** Update debrief header ACC record ***/
JTM_HOOK_UTIL_PKG.Update_Acc
( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
,P_ACC_TABLE_NAME => g_acc_table_name
,P_RESOURCE_ID => p_resource_id
,P_ACCESS_ID => p_acc_id
);
, 'Leaving Update_ACC_Record'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
END Update_ACC_Record;
/*** Private procedure that deletes debrief line for resource from acc
table ***/
PROCEDURE Delete_ACC_Record
( p_debrief_header_id IN NUMBER
,p_resource_id IN NUMBER
)
IS
BEGIN
IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
jtm_message_log_pkg.Log_Msg
( p_debrief_header_id
, g_table_name
, 'Entering Delete_ACC_Record'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
/*** Delete debrief header ACC record ***/
JTM_HOOK_UTIL_PKG.Delete_Acc
( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
,P_ACC_TABLE_NAME => g_acc_table_name
,P_PK1_NAME => g_pk1_name
,P_PK1_NUM_VALUE => p_debrief_header_id
,P_RESOURCE_ID => p_resource_id
);
, 'Leaving Delete_ACC_Record'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
END Delete_ACC_Record;
inserted into ACC table. ***/
PROCEDURE Insert_Debrief_Header
( p_debrief_header_id IN NUMBER
,p_resource_id IN NUMBER
)
IS
l_acc_id NUMBER;
, 'Entering Insert_Debrief_Header procedure'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
/*** yes -> insert debrief header acc record ***/
Insert_ACC_Record
( p_debrief_header_id
,p_resource_id
);
, 'Leaving Insert_Debrief_Header procedure'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
END Insert_Debrief_Header;
be updated into ACC table. ***/
PROCEDURE Update_Debrief_Header
( p_debrief_header_id IN NUMBER
,p_resource_id IN NUMBER
)
IS
l_acc_id NUMBER;
, 'Entering Update_Debrief_Header procedure'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
/*** yes -> update debrief header acc record ***/
Update_ACC_Record
( p_debrief_header_id
,p_resource_id
,l_acc_id
);
, 'Leaving Update_Debrief_Header procedure'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
END Update_Debrief_Header;
be deleted from ACC table. ***/
PROCEDURE Delete_Debrief_Header
( p_debrief_header_id IN NUMBER
,p_resource_id IN NUMBER
)
IS
l_acc_id NUMBER;
, 'Entering Delete_Debrief_Header'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
/*** yes -> delete debrief header acc record ***/
Delete_ACC_Record
( p_debrief_header_id
,p_resource_id
);
, 'Leaving Delete_Debrief_Header'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
END Delete_Debrief_Header;
/* Called before debrief_header Insert */
PROCEDURE PRE_INSERT_DEBRIEF_HEADER
( x_return_status out NOCOPY varchar2
)
IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
END PRE_INSERT_DEBRIEF_HEADER;
/* Called after debrief_header Insert */
PROCEDURE POST_INSERT_DEBRIEF_HEADER
( x_return_status out NOCOPY varchar2
)
IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
END POST_INSERT_DEBRIEF_HEADER;
/* Called before debrief_header Update */
PROCEDURE PRE_UPDATE_DEBRIEF_HEADER
( x_return_status out NOCOPY varchar2
)
IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
END PRE_UPDATE_DEBRIEF_HEADER;
/* Called after debrief_header Update */
PROCEDURE POST_UPDATE_DEBRIEF_HEADER (
x_return_status out NOCOPY varchar2
) IS
l_enabled_flag VARCHAR2(30);
, 'Entering POST_UPDATE hook'
, JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
/*** Check if debrief_line after update matches criteria ***/
IF JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
Update_Debrief_Header(l_debrief_header_id, l_resource_id);
END POST_UPDATE_DEBRIEF_HEADER;
/* Called before debrief_header delete */
PROCEDURE PRE_DELETE_DEBRIEF_HEADER
( x_return_status out NOCOPY varchar2
)
IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
END PRE_DELETE_DEBRIEF_HEADER;