[Home] [Help]
6: ------------------------------------------------------------------------------
7: -- Procedure : Create_Interaction
8: -- Type : Private API
9: -- Usage : Creates a customer interaction record in the table
10: -- CS_INTERACTIONS
11: -- Pre-reqs : None
12: ------------------------------------------------------------------------------
13:
14: PROCEDURE Create_Interaction
363: p_attribute13 || p_attribute14 || p_attribute15 ||
364: p_attribute_category) IS NOT NULL) THEN
365: cs_core_util.validate_desc_flex
366: ( p_api_name => l_api_name_full,
367: p_desc_flex_name => 'CS_INTERACTIONS',
368: p_column_name1 => 'ATTRIBUTE1',
369: p_column_name2 => 'ATTRIBUTE2',
370: p_column_name3 => 'ATTRIBUTE3',
371: p_column_name4 => 'ATTRIBUTE4',
463:
464: -------------------------------------------------------------------------
465: -- Perform the database operation. Generate the interaction ID from the
466: -- sequence, then insert the sequence number and passed in attributes
467: -- into the CS_INTERACTIONS table.
468: -------------------------------------------------------------------------
469: SELECT cs_interactions_s.NEXTVAL INTO l_interaction_id FROM dual;
470:
471: --
465: -- Perform the database operation. Generate the interaction ID from the
466: -- sequence, then insert the sequence number and passed in attributes
467: -- into the CS_INTERACTIONS table.
468: -------------------------------------------------------------------------
469: SELECT cs_interactions_s.NEXTVAL INTO l_interaction_id FROM dual;
470:
471: --
472: -- Default parent interaction ID if missing
473: --
474: IF (p_parent_interaction_id IS NULL) THEN
475: l_parent_id := l_interaction_id;
476: END IF;
477:
478: INSERT INTO cs_interactions
479: ( interaction_id,
480: created_by,
481: creation_date,
482: last_updated_by,