APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_EXPIRE_INSTANCES_TEMP

Line 11147: from CSI_EXPIRE_INSTANCES_TEMP

11143: ) IS
11144: --
11145: CURSOR EXP_CUR IS
11146: select instance_id,rowid
11147: from CSI_EXPIRE_INSTANCES_TEMP
11148: where process_code = p_process_code
11149: and processed_flag in ('E','R');
11150: --
11151: l_vld_org NUMBER;

Line 11190: UPDATE CSI_EXPIRE_INSTANCES_TEMP

11186: ,x_msg_data => x_msg_data
11187: );
11188: --
11189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11190: UPDATE CSI_EXPIRE_INSTANCES_TEMP
11191: set processed_flag = 'E',
11192: error_message = x_msg_data
11193: where rowid = exp.rowid;
11194: ELSE

Line 11195: UPDATE CSI_EXPIRE_INSTANCES_TEMP

11191: set processed_flag = 'E',
11192: error_message = x_msg_data
11193: where rowid = exp.rowid;
11194: ELSE
11195: UPDATE CSI_EXPIRE_INSTANCES_TEMP
11196: set processed_flag = 'P',
11197: error_message = null
11198: where rowid = exp.rowid;
11199: END IF;

Line 11303: DELETE FROM CSI_EXPIRE_INSTANCES_TEMP

11299: --
11300: comp_error EXCEPTION;
11301: Process_next EXCEPTION;
11302: BEGIN
11303: DELETE FROM CSI_EXPIRE_INSTANCES_TEMP
11304: WHERE processed_flag = 'P'
11305: AND process_code = 'EXPNL';
11306: commit;
11307: --

Line 11432: INSERT INTO CSI_EXPIRE_INSTANCES_TEMP

11428: END LOOP;
11429: IF l_inst_tbl.count > 0 THEN
11430: l_ins_flag := 'Y';
11431: FORALL j in l_inst_tbl.FIRST .. l_inst_tbl.LAST
11432: INSERT INTO CSI_EXPIRE_INSTANCES_TEMP
11433: ( INSTANCE_ID,
11434: PROCESSED_FLAG,
11435: PROCESS_CODE
11436: )