[Home] [Help]
11127: | insert_conc_request
11128: |
11129: | PURPOSE:
11130: | Inserts a given concurrent request id into the
11131: | IBY_PROCESS_CONC_REQUESTS table for audit purposes.
11132: |
11133: | PARAMETERS:
11134: | IN
11135: | p_object_id The id of the payment entity. This can be
11173: print_debuginfo(l_module_name, 'ENTER');
11174:
11175: print_debuginfo(l_module_name, 'Inserting conc request id '
11176: || p_conc_request_id
11177: || ' into IBY_PROCESS_CONC_REQUESTS for object id '
11178: || p_object_id
11179: || ' with object type '
11180: || p_object_type
11181: );
11187: END IF;
11188:
11189: SELECT COUNT(*) dup_count
11190: INTO l_dup_count
11191: FROM IBY_PROCESS_CONC_REQUESTS
11192: WHERE OBJECT_ID = p_object_id
11193: AND OBJECT_TYPE = p_object_type
11194: AND REQUEST_ID = p_conc_request_id
11195: ;
11211: print_debuginfo(l_module_name, 'Inserting conc request');
11212: END IF;
11213:
11214:
11215: INSERT INTO IBY_PROCESS_CONC_REQUESTS
11216: (
11217: OBJECT_ID, /* 1 */
11218: OBJECT_TYPE,
11219: REQUEST_ID,
11252: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11253: print_debuginfo(l_module_name, 'Exception occured when '
11254: || 'inserting conc request id '
11255: || p_conc_request_id
11256: || ' into IBY_PROCESS_CONC_REQUESTS for object id '
11257: || p_object_id
11258: || ' with object type '
11259: || p_object_type
11260: || '.'
11288: | data integrity of payment entities which are in transient
11289: | statuses.
11290: |
11291: | This method also inserts the provided concurrent request into
11292: | IBY_PROCESS_CONC_REQUESTS table for audit purposes.
11293: |
11294: | PARAMETERS:
11295: | IN
11296: | p_object_id The id of the payment entity. This can be