APPS.BIX_CCI_COLLECT dependencies on BIX_INTERACTIONS

Line 64: DELETE from BIX_INTERACTIONS;

60: AND int.end_date_time > seg.end_date_time;
61:
62: BEGIN
63:
64: DELETE from BIX_INTERACTIONS;
65: --WHERE start_ts between p_start_date and p_end_date;
66:
67:
68: FOR act IN all_calls LOOP

Line 72: INSERT INTO BIX_INTERACTIONS

68: FOR act IN all_calls LOOP
69:
70: l_queue_segment := NULL;
71:
72: INSERT INTO BIX_INTERACTIONS
73: (
74: INTERACTIONS_ID,
75: START_TS,
76: COMPLETED_TS,

Line 104: UPDATE BIX_INTERACTIONS

100: FOR milcs IN c_milcs( act.MEDIA_ID ) LOOP
101:
102: IF (milcs.MILCS_CODE = 'IVR') THEN
103:
104: UPDATE BIX_INTERACTIONS
105: SET IVR_TIME = milcs.DURATION
106: WHERE INTERACTIONS_ID = act.media_id
107: AND resource_id = -1;
108:

Line 111: UPDATE BIX_INTERACTIONS

107: AND resource_id = -1;
108:
109: ELSIF (UPPER(milcs.MILCS_CODE) = 'ROUTING') THEN
110:
111: UPDATE BIX_INTERACTIONS
112: SET ROUTE_TIME = milcs.DURATION
113: WHERE INTERACTIONS_ID = act.media_id
114: AND resource_id = -1;
115:

Line 120: UPDATE BIX_INTERACTIONS

116: ELSIF (milcs.MILCS_CODE = 'IN_QUEUE') THEN
117:
118: l_queue_segment := 'T';
119:
120: UPDATE BIX_INTERACTIONS
121: SET PARTY_WAIT_TIME = milcs.DURATION,USER_ATTRIBUTE1 = 'T'
122: WHERE INTERACTIONS_ID = act.media_id
123: AND resource_id = -1;
124:

Line 144: INSERT INTO BIX_INTERACTIONS

140:
141: -- multiple agents can be involved in same call. Insert separate row for each agent in the interface
142: -- table
143:
144: INSERT INTO BIX_INTERACTIONS
145: (
146: INTERACTIONS_ID,
147: START_TS,
148: COMPLETED_TS,