eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_IH_PUB_PS dependencies on JTF_IH_INTERACTIONS

Line 206: FROM jtf_ih_interactions

202: l_count := 0;
203: IF ((p_int_val_rec.parent_id IS NOT NULL) AND (p_int_val_rec.parent_id <> fnd_api.g_miss_num)) THEN
204: BEGIN
205: SELECT count(*) into l_count
206: FROM jtf_ih_interactions
207: WHERE interaction_id = p_int_val_rec.parent_id;
208: IF (l_count <= 0) THEN
209: x_return_status := fnd_api.g_ret_sts_error;
210: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.parent_id),

Line 389: FROM jtf_ih_interactions

385:
386: IF ((p_act_val_rec.interaction_id IS NOT NULL) AND (p_act_val_rec.interaction_id <> fnd_api.g_miss_num)) THEN
387: BEGIN
388: SELECT count(*) into l_count
389: FROM jtf_ih_interactions
390: WHERE interaction_id = p_act_val_rec.interaction_id;
391: IF (l_count <= 0) THEN
392: x_return_status := fnd_api.g_ret_sts_error;
393: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),

Line 1339: SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;

1335: END IF;
1336: --DBMS_OUTPUT.PUT_LINE('PAST Validate_Interaction_Record in JTF_IH_PUB_PS.Create_Interaction');
1337: Default_Interaction_Record(l_int_val_rec);
1338: IF ((p_interaction_rec.interaction_id IS NULL) OR (p_interaction_rec.interaction_id = fnd_api.g_miss_num)) THEN
1339: SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;
1340:
1341: END IF;
1342:
1343: INSERT INTO jtf_ih_Interactions

Line 1343: INSERT INTO jtf_ih_Interactions

1339: SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;
1340:
1341: END IF;
1342:
1343: INSERT INTO jtf_ih_Interactions
1344: (
1345: CREATED_BY,
1346: REFERENCE_FORM,
1347: CREATION_DATE,

Line 1437: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB_PS.Create_Interaction');

1433: l_int_val_rec.attribute15,
1434: l_int_val_rec.attribute_category,
1435: 'Y'
1436: );
1437: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB_PS.Create_Interaction');
1438:
1439: Validate_Activity_table
1440: (
1441: p_api_name => l_api_name_full,

Line 1747: FROM jtf_ih_Interactions

1743: END IF;
1744: END IF;
1745:
1746: SELECT count(*) into interactionCount
1747: FROM jtf_ih_Interactions
1748: where outcome_id = p_outcome_id
1749: and result_id = p_result_id
1750: and reason_id = p_reason_id
1751: and ((attribute1 = p_attribute1) or (p_attribute1 is NULL and attribute1 is NULL))

Line 1920: SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;

1916: l_productive_time_amount := l_duration;
1917: END IF;
1918: END IF;
1919:
1920: SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;
1921:
1922: INSERT INTO jtf_ih_interactions
1923: (
1924: CREATED_BY,

Line 1922: INSERT INTO jtf_ih_interactions

1918: END IF;
1919:
1920: SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;
1921:
1922: INSERT INTO jtf_ih_interactions
1923: (
1924: CREATED_BY,
1925: REFERENCE_FORM,
1926: CREATION_DATE,

Line 2016: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB_PS.Open_Interaction');

2012: p_interaction_rec.attribute15,
2013: p_interaction_rec.attribute_category,
2014: l_active
2015: );
2016: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB_PS.Open_Interaction');
2017:
2018:
2019: IF ((p_interaction_rec.parent_id IS NOT NULL) AND (p_interaction_rec.parent_id <> fnd_api.g_miss_num)) THEN
2020: INSERT INTO jtf_ih_interaction_inters

Line 2161: -- Update table JTF_IH_INTERACTIONS

2157: --DBMS_OUTPUT.PUT_LINE('PAST Validate_Interaction_Record in JTF_IH_PUB_PS.Update_Interaction');
2158:
2159:
2160: --
2161: -- Update table JTF_IH_INTERACTIONS
2162: --
2163: IF (p_interaction_rec.interaction_id IS NULL) THEN
2164: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'interaction_id');
2165: RAISE fnd_api.g_exc_error;

Line 2169: FROM jtf_ih_interactions

2165: RAISE fnd_api.g_exc_error;
2166: ELSE
2167: l_count := 0;
2168: SELECT count(*) into l_count
2169: FROM jtf_ih_interactions
2170: WHERE interaction_id = p_interaction_rec.interaction_id;
2171: IF(l_count <> 1) THEN
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.interaction_id),

Line 2178: FROM jtf_ih_interactions

2174: 'interaction_id');
2175: RETURN;
2176: ELSE
2177: SELECT active into l_active
2178: FROM jtf_ih_interactions
2179: WHERE interaction_id = p_interaction_rec.interaction_id;
2180: IF(l_active <> 'N') THEN
2181: SELECT start_date_time into l_start_date_time FROM jtf_ih_interactions
2182: WHERE interaction_id = p_interaction_rec.interaction_id;

Line 2181: SELECT start_date_time into l_start_date_time FROM jtf_ih_interactions

2177: SELECT active into l_active
2178: FROM jtf_ih_interactions
2179: WHERE interaction_id = p_interaction_rec.interaction_id;
2180: IF(l_active <> 'N') THEN
2181: SELECT start_date_time into l_start_date_time FROM jtf_ih_interactions
2182: WHERE interaction_id = p_interaction_rec.interaction_id;
2183:
2184: -- assign the duration
2185: IF(p_interaction_rec.duration IS NOT NULL) THEN

Line 2222: UPDATE jtf_ih_interactions SET REFERENCE_FORM = p_interaction_rec.reference_form

2218: END IF;
2219: END IF;
2220:
2221: IF(p_interaction_rec.reference_form <> fnd_api.g_miss_char) THEN
2222: UPDATE jtf_ih_interactions SET REFERENCE_FORM = p_interaction_rec.reference_form
2223: WHERE interaction_id = p_interaction_rec.interaction_id;
2224: END IF;
2225: IF(p_interaction_rec.follow_up_action <> fnd_api.g_miss_char) THEN
2226: UPDATE jtf_ih_interactions SET FOLLOW_UP_ACTION = p_interaction_rec.follow_up_action

Line 2226: UPDATE jtf_ih_interactions SET FOLLOW_UP_ACTION = p_interaction_rec.follow_up_action

2222: UPDATE jtf_ih_interactions SET REFERENCE_FORM = p_interaction_rec.reference_form
2223: WHERE interaction_id = p_interaction_rec.interaction_id;
2224: END IF;
2225: IF(p_interaction_rec.follow_up_action <> fnd_api.g_miss_char) THEN
2226: UPDATE jtf_ih_interactions SET FOLLOW_UP_ACTION = p_interaction_rec.follow_up_action
2227: WHERE interaction_id = p_interaction_rec.interaction_id;
2228: END IF;
2229: IF(l_duration IS NOT NULL) THEN
2230: UPDATE jtf_ih_interactions SET DURATION = l_duration

Line 2230: UPDATE jtf_ih_interactions SET DURATION = l_duration

2226: UPDATE jtf_ih_interactions SET FOLLOW_UP_ACTION = p_interaction_rec.follow_up_action
2227: WHERE interaction_id = p_interaction_rec.interaction_id;
2228: END IF;
2229: IF(l_duration IS NOT NULL) THEN
2230: UPDATE jtf_ih_interactions SET DURATION = l_duration
2231: WHERE interaction_id = p_interaction_rec.interaction_id;
2232: END IF;
2233: IF(p_interaction_rec.end_date_time <> fnd_api.g_miss_date) THEN
2234: UPDATE jtf_ih_interactions SET END_DATE_TIME = p_interaction_rec.end_date_time

Line 2234: UPDATE jtf_ih_interactions SET END_DATE_TIME = p_interaction_rec.end_date_time

2230: UPDATE jtf_ih_interactions SET DURATION = l_duration
2231: WHERE interaction_id = p_interaction_rec.interaction_id;
2232: END IF;
2233: IF(p_interaction_rec.end_date_time <> fnd_api.g_miss_date) THEN
2234: UPDATE jtf_ih_interactions SET END_DATE_TIME = p_interaction_rec.end_date_time
2235: WHERE interaction_id = p_interaction_rec.interaction_id;
2236: END IF;
2237: IF(p_interaction_rec.inter_interaction_duration <> fnd_api.g_miss_num) THEN
2238: UPDATE jtf_ih_interactions SET INTER_INTERACTION_DURATION = p_interaction_rec.inter_interaction_duration

Line 2238: UPDATE jtf_ih_interactions SET INTER_INTERACTION_DURATION = p_interaction_rec.inter_interaction_duration

2234: UPDATE jtf_ih_interactions SET END_DATE_TIME = p_interaction_rec.end_date_time
2235: WHERE interaction_id = p_interaction_rec.interaction_id;
2236: END IF;
2237: IF(p_interaction_rec.inter_interaction_duration <> fnd_api.g_miss_num) THEN
2238: UPDATE jtf_ih_interactions SET INTER_INTERACTION_DURATION = p_interaction_rec.inter_interaction_duration
2239: WHERE interaction_id = p_interaction_rec.interaction_id;
2240: END IF;
2241: IF(p_interaction_rec.non_productive_time_amount <> fnd_api.g_miss_num) THEN
2242: UPDATE jtf_ih_interactions SET NON_PRODUCTIVE_TIME_AMOUNT = p_interaction_rec.non_productive_time_amount

Line 2242: UPDATE jtf_ih_interactions SET NON_PRODUCTIVE_TIME_AMOUNT = p_interaction_rec.non_productive_time_amount

2238: UPDATE jtf_ih_interactions SET INTER_INTERACTION_DURATION = p_interaction_rec.inter_interaction_duration
2239: WHERE interaction_id = p_interaction_rec.interaction_id;
2240: END IF;
2241: IF(p_interaction_rec.non_productive_time_amount <> fnd_api.g_miss_num) THEN
2242: UPDATE jtf_ih_interactions SET NON_PRODUCTIVE_TIME_AMOUNT = p_interaction_rec.non_productive_time_amount
2243: WHERE interaction_id = p_interaction_rec.interaction_id;
2244: END IF;
2245: IF(p_interaction_rec.preview_time_amount <> fnd_api.g_miss_num) THEN
2246: UPDATE jtf_ih_interactions SET PREVIEW_TIME_AMOUNT = p_interaction_rec.preview_time_amount

Line 2246: UPDATE jtf_ih_interactions SET PREVIEW_TIME_AMOUNT = p_interaction_rec.preview_time_amount

2242: UPDATE jtf_ih_interactions SET NON_PRODUCTIVE_TIME_AMOUNT = p_interaction_rec.non_productive_time_amount
2243: WHERE interaction_id = p_interaction_rec.interaction_id;
2244: END IF;
2245: IF(p_interaction_rec.preview_time_amount <> fnd_api.g_miss_num) THEN
2246: UPDATE jtf_ih_interactions SET PREVIEW_TIME_AMOUNT = p_interaction_rec.preview_time_amount
2247: WHERE interaction_id = p_interaction_rec.interaction_id;
2248: END IF;
2249: IF(l_productive_time_amount IS NOT NULL) THEN
2250: UPDATE jtf_ih_interactions SET PRODUCTIVE_TIME_AMOUNT = l_productive_time_amount

Line 2250: UPDATE jtf_ih_interactions SET PRODUCTIVE_TIME_AMOUNT = l_productive_time_amount

2246: UPDATE jtf_ih_interactions SET PREVIEW_TIME_AMOUNT = p_interaction_rec.preview_time_amount
2247: WHERE interaction_id = p_interaction_rec.interaction_id;
2248: END IF;
2249: IF(l_productive_time_amount IS NOT NULL) THEN
2250: UPDATE jtf_ih_interactions SET PRODUCTIVE_TIME_AMOUNT = l_productive_time_amount
2251: WHERE interaction_id = p_interaction_rec.interaction_id;
2252: END IF;
2253: IF(p_interaction_rec.wrapUp_time_amount <> fnd_api.g_miss_num) THEN
2254: UPDATE jtf_ih_interactions SET WRAP_UP_TIME_AMOUNT = p_interaction_rec.wrapUp_time_amount

Line 2254: UPDATE jtf_ih_interactions SET WRAP_UP_TIME_AMOUNT = p_interaction_rec.wrapUp_time_amount

2250: UPDATE jtf_ih_interactions SET PRODUCTIVE_TIME_AMOUNT = l_productive_time_amount
2251: WHERE interaction_id = p_interaction_rec.interaction_id;
2252: END IF;
2253: IF(p_interaction_rec.wrapUp_time_amount <> fnd_api.g_miss_num) THEN
2254: UPDATE jtf_ih_interactions SET WRAP_UP_TIME_AMOUNT = p_interaction_rec.wrapUp_time_amount
2255: WHERE interaction_id = p_interaction_rec.interaction_id;
2256: END IF;
2257: IF(p_interaction_rec.handler_id <> fnd_api.g_miss_num) THEN
2258: UPDATE jtf_ih_interactions SET HANDLER_ID = p_interaction_rec.handler_id

Line 2258: UPDATE jtf_ih_interactions SET HANDLER_ID = p_interaction_rec.handler_id

2254: UPDATE jtf_ih_interactions SET WRAP_UP_TIME_AMOUNT = p_interaction_rec.wrapUp_time_amount
2255: WHERE interaction_id = p_interaction_rec.interaction_id;
2256: END IF;
2257: IF(p_interaction_rec.handler_id <> fnd_api.g_miss_num) THEN
2258: UPDATE jtf_ih_interactions SET HANDLER_ID = p_interaction_rec.handler_id
2259: WHERE interaction_id = p_interaction_rec.interaction_id;
2260: END IF;
2261: IF(p_interaction_rec.script_id <> fnd_api.g_miss_num) THEN
2262: UPDATE jtf_ih_interactions SET SCRIPT_ID = p_interaction_rec.script_id

Line 2262: UPDATE jtf_ih_interactions SET SCRIPT_ID = p_interaction_rec.script_id

2258: UPDATE jtf_ih_interactions SET HANDLER_ID = p_interaction_rec.handler_id
2259: WHERE interaction_id = p_interaction_rec.interaction_id;
2260: END IF;
2261: IF(p_interaction_rec.script_id <> fnd_api.g_miss_num) THEN
2262: UPDATE jtf_ih_interactions SET SCRIPT_ID = p_interaction_rec.script_id
2263: WHERE interaction_id = p_interaction_rec.interaction_id;
2264: END IF;
2265: IF(p_interaction_rec.outcome_id <> fnd_api.g_miss_num) THEN
2266: UPDATE jtf_ih_interactions SET OUTCOME_ID = p_interaction_rec.outcome_id

Line 2266: UPDATE jtf_ih_interactions SET OUTCOME_ID = p_interaction_rec.outcome_id

2262: UPDATE jtf_ih_interactions SET SCRIPT_ID = p_interaction_rec.script_id
2263: WHERE interaction_id = p_interaction_rec.interaction_id;
2264: END IF;
2265: IF(p_interaction_rec.outcome_id <> fnd_api.g_miss_num) THEN
2266: UPDATE jtf_ih_interactions SET OUTCOME_ID = p_interaction_rec.outcome_id
2267: WHERE interaction_id = p_interaction_rec.interaction_id;
2268: END IF;
2269: IF(p_interaction_rec.result_id <> fnd_api.g_miss_num) THEN
2270: UPDATE jtf_ih_interactions SET RESULT_ID = p_interaction_rec.result_id

Line 2270: UPDATE jtf_ih_interactions SET RESULT_ID = p_interaction_rec.result_id

2266: UPDATE jtf_ih_interactions SET OUTCOME_ID = p_interaction_rec.outcome_id
2267: WHERE interaction_id = p_interaction_rec.interaction_id;
2268: END IF;
2269: IF(p_interaction_rec.result_id <> fnd_api.g_miss_num) THEN
2270: UPDATE jtf_ih_interactions SET RESULT_ID = p_interaction_rec.result_id
2271: WHERE interaction_id = p_interaction_rec.interaction_id;
2272: END IF;
2273: IF(p_interaction_rec.reason_id <> fnd_api.g_miss_num) THEN
2274: UPDATE jtf_ih_interactions SET REASON_ID = p_interaction_rec.reason_id

Line 2274: UPDATE jtf_ih_interactions SET REASON_ID = p_interaction_rec.reason_id

2270: UPDATE jtf_ih_interactions SET RESULT_ID = p_interaction_rec.result_id
2271: WHERE interaction_id = p_interaction_rec.interaction_id;
2272: END IF;
2273: IF(p_interaction_rec.reason_id <> fnd_api.g_miss_num) THEN
2274: UPDATE jtf_ih_interactions SET REASON_ID = p_interaction_rec.reason_id
2275: WHERE interaction_id = p_interaction_rec.interaction_id;
2276: END IF;
2277: IF(p_interaction_rec.resource_id <> fnd_api.g_miss_num) THEN
2278: UPDATE jtf_ih_interactions SET RESOURCE_ID = p_interaction_rec.resource_id

Line 2278: UPDATE jtf_ih_interactions SET RESOURCE_ID = p_interaction_rec.resource_id

2274: UPDATE jtf_ih_interactions SET REASON_ID = p_interaction_rec.reason_id
2275: WHERE interaction_id = p_interaction_rec.interaction_id;
2276: END IF;
2277: IF(p_interaction_rec.resource_id <> fnd_api.g_miss_num) THEN
2278: UPDATE jtf_ih_interactions SET RESOURCE_ID = p_interaction_rec.resource_id
2279: WHERE interaction_id = p_interaction_rec.interaction_id;
2280: END IF;
2281: IF(p_interaction_rec.object_id <> fnd_api.g_miss_num) THEN
2282: UPDATE jtf_ih_interactions SET OBJECT_ID = p_interaction_rec.object_id

Line 2282: UPDATE jtf_ih_interactions SET OBJECT_ID = p_interaction_rec.object_id

2278: UPDATE jtf_ih_interactions SET RESOURCE_ID = p_interaction_rec.resource_id
2279: WHERE interaction_id = p_interaction_rec.interaction_id;
2280: END IF;
2281: IF(p_interaction_rec.object_id <> fnd_api.g_miss_num) THEN
2282: UPDATE jtf_ih_interactions SET OBJECT_ID = p_interaction_rec.object_id
2283: WHERE interaction_id = p_interaction_rec.interaction_id;
2284: END IF;
2285: IF(p_interaction_rec.object_type <> fnd_api.g_miss_char) THEN
2286: UPDATE jtf_ih_interactions SET OBJECT_TYPE = p_interaction_rec.object_type

Line 2286: UPDATE jtf_ih_interactions SET OBJECT_TYPE = p_interaction_rec.object_type

2282: UPDATE jtf_ih_interactions SET OBJECT_ID = p_interaction_rec.object_id
2283: WHERE interaction_id = p_interaction_rec.interaction_id;
2284: END IF;
2285: IF(p_interaction_rec.object_type <> fnd_api.g_miss_char) THEN
2286: UPDATE jtf_ih_interactions SET OBJECT_TYPE = p_interaction_rec.object_type
2287: WHERE interaction_id = p_interaction_rec.interaction_id;
2288: END IF;
2289: IF(p_interaction_rec.source_code_id <> fnd_api.g_miss_num) THEN
2290: UPDATE jtf_ih_interactions SET SOURCE_CODE_ID = p_interaction_rec.source_code_id

Line 2290: UPDATE jtf_ih_interactions SET SOURCE_CODE_ID = p_interaction_rec.source_code_id

2286: UPDATE jtf_ih_interactions SET OBJECT_TYPE = p_interaction_rec.object_type
2287: WHERE interaction_id = p_interaction_rec.interaction_id;
2288: END IF;
2289: IF(p_interaction_rec.source_code_id <> fnd_api.g_miss_num) THEN
2290: UPDATE jtf_ih_interactions SET SOURCE_CODE_ID = p_interaction_rec.source_code_id
2291: WHERE interaction_id = p_interaction_rec.interaction_id;
2292: END IF;
2293: IF(p_interaction_rec.source_code <> fnd_api.g_miss_char) THEN
2294: UPDATE jtf_ih_interactions SET SOURCE_CODE = p_interaction_rec.source_code

Line 2294: UPDATE jtf_ih_interactions SET SOURCE_CODE = p_interaction_rec.source_code

2290: UPDATE jtf_ih_interactions SET SOURCE_CODE_ID = p_interaction_rec.source_code_id
2291: WHERE interaction_id = p_interaction_rec.interaction_id;
2292: END IF;
2293: IF(p_interaction_rec.source_code <> fnd_api.g_miss_char) THEN
2294: UPDATE jtf_ih_interactions SET SOURCE_CODE = p_interaction_rec.source_code
2295: WHERE interaction_id = p_interaction_rec.interaction_id;
2296: END IF;
2297: IF(p_interaction_rec.attribute1 <> fnd_api.g_miss_char) THEN
2298: UPDATE jtf_ih_interactions SET ATTRIBUTE1 = p_interaction_rec.attribute1

Line 2298: UPDATE jtf_ih_interactions SET ATTRIBUTE1 = p_interaction_rec.attribute1

2294: UPDATE jtf_ih_interactions SET SOURCE_CODE = p_interaction_rec.source_code
2295: WHERE interaction_id = p_interaction_rec.interaction_id;
2296: END IF;
2297: IF(p_interaction_rec.attribute1 <> fnd_api.g_miss_char) THEN
2298: UPDATE jtf_ih_interactions SET ATTRIBUTE1 = p_interaction_rec.attribute1
2299: WHERE interaction_id = p_interaction_rec.interaction_id;
2300: END IF;
2301: IF(p_interaction_rec.attribute2 <> fnd_api.g_miss_char) THEN
2302: UPDATE jtf_ih_interactions SET ATTRIBUTE2 = p_interaction_rec.attribute2

Line 2302: UPDATE jtf_ih_interactions SET ATTRIBUTE2 = p_interaction_rec.attribute2

2298: UPDATE jtf_ih_interactions SET ATTRIBUTE1 = p_interaction_rec.attribute1
2299: WHERE interaction_id = p_interaction_rec.interaction_id;
2300: END IF;
2301: IF(p_interaction_rec.attribute2 <> fnd_api.g_miss_char) THEN
2302: UPDATE jtf_ih_interactions SET ATTRIBUTE2 = p_interaction_rec.attribute2
2303: WHERE interaction_id = p_interaction_rec.interaction_id;
2304: END IF;
2305: IF(p_interaction_rec.attribute3 <> fnd_api.g_miss_char) THEN
2306: UPDATE jtf_ih_interactions SET ATTRIBUTE3 = p_interaction_rec.attribute3

Line 2306: UPDATE jtf_ih_interactions SET ATTRIBUTE3 = p_interaction_rec.attribute3

2302: UPDATE jtf_ih_interactions SET ATTRIBUTE2 = p_interaction_rec.attribute2
2303: WHERE interaction_id = p_interaction_rec.interaction_id;
2304: END IF;
2305: IF(p_interaction_rec.attribute3 <> fnd_api.g_miss_char) THEN
2306: UPDATE jtf_ih_interactions SET ATTRIBUTE3 = p_interaction_rec.attribute3
2307: WHERE interaction_id = p_interaction_rec.interaction_id;
2308: END IF;
2309: IF(p_interaction_rec.attribute4 <> fnd_api.g_miss_char) THEN
2310: UPDATE jtf_ih_interactions SET ATTRIBUTE4 = p_interaction_rec.attribute4

Line 2310: UPDATE jtf_ih_interactions SET ATTRIBUTE4 = p_interaction_rec.attribute4

2306: UPDATE jtf_ih_interactions SET ATTRIBUTE3 = p_interaction_rec.attribute3
2307: WHERE interaction_id = p_interaction_rec.interaction_id;
2308: END IF;
2309: IF(p_interaction_rec.attribute4 <> fnd_api.g_miss_char) THEN
2310: UPDATE jtf_ih_interactions SET ATTRIBUTE4 = p_interaction_rec.attribute4
2311: WHERE interaction_id = p_interaction_rec.interaction_id;
2312: END IF;
2313: IF(p_interaction_rec.attribute5 <> fnd_api.g_miss_char) THEN
2314: UPDATE jtf_ih_interactions SET ATTRIBUTE5 = p_interaction_rec.attribute5

Line 2314: UPDATE jtf_ih_interactions SET ATTRIBUTE5 = p_interaction_rec.attribute5

2310: UPDATE jtf_ih_interactions SET ATTRIBUTE4 = p_interaction_rec.attribute4
2311: WHERE interaction_id = p_interaction_rec.interaction_id;
2312: END IF;
2313: IF(p_interaction_rec.attribute5 <> fnd_api.g_miss_char) THEN
2314: UPDATE jtf_ih_interactions SET ATTRIBUTE5 = p_interaction_rec.attribute5
2315: WHERE interaction_id = p_interaction_rec.interaction_id;
2316: END IF;
2317: IF(p_interaction_rec.attribute6 <> fnd_api.g_miss_char) THEN
2318: UPDATE jtf_ih_interactions SET ATTRIBUTE6 = p_interaction_rec.attribute6

Line 2318: UPDATE jtf_ih_interactions SET ATTRIBUTE6 = p_interaction_rec.attribute6

2314: UPDATE jtf_ih_interactions SET ATTRIBUTE5 = p_interaction_rec.attribute5
2315: WHERE interaction_id = p_interaction_rec.interaction_id;
2316: END IF;
2317: IF(p_interaction_rec.attribute6 <> fnd_api.g_miss_char) THEN
2318: UPDATE jtf_ih_interactions SET ATTRIBUTE6 = p_interaction_rec.attribute6
2319: WHERE interaction_id = p_interaction_rec.interaction_id;
2320: END IF;
2321: IF(p_interaction_rec.attribute7 <> fnd_api.g_miss_char) THEN
2322: UPDATE jtf_ih_interactions SET ATTRIBUTE7 = p_interaction_rec.attribute7

Line 2322: UPDATE jtf_ih_interactions SET ATTRIBUTE7 = p_interaction_rec.attribute7

2318: UPDATE jtf_ih_interactions SET ATTRIBUTE6 = p_interaction_rec.attribute6
2319: WHERE interaction_id = p_interaction_rec.interaction_id;
2320: END IF;
2321: IF(p_interaction_rec.attribute7 <> fnd_api.g_miss_char) THEN
2322: UPDATE jtf_ih_interactions SET ATTRIBUTE7 = p_interaction_rec.attribute7
2323: WHERE interaction_id = p_interaction_rec.interaction_id;
2324: END IF;
2325: IF(p_interaction_rec.attribute8 <> fnd_api.g_miss_char) THEN
2326: UPDATE jtf_ih_interactions SET ATTRIBUTE8 = p_interaction_rec.attribute8

Line 2326: UPDATE jtf_ih_interactions SET ATTRIBUTE8 = p_interaction_rec.attribute8

2322: UPDATE jtf_ih_interactions SET ATTRIBUTE7 = p_interaction_rec.attribute7
2323: WHERE interaction_id = p_interaction_rec.interaction_id;
2324: END IF;
2325: IF(p_interaction_rec.attribute8 <> fnd_api.g_miss_char) THEN
2326: UPDATE jtf_ih_interactions SET ATTRIBUTE8 = p_interaction_rec.attribute8
2327: WHERE interaction_id = p_interaction_rec.interaction_id;
2328: END IF;
2329: IF(p_interaction_rec.attribute9 <> fnd_api.g_miss_char) THEN
2330: UPDATE jtf_ih_interactions SET ATTRIBUTE9 = p_interaction_rec.attribute9

Line 2330: UPDATE jtf_ih_interactions SET ATTRIBUTE9 = p_interaction_rec.attribute9

2326: UPDATE jtf_ih_interactions SET ATTRIBUTE8 = p_interaction_rec.attribute8
2327: WHERE interaction_id = p_interaction_rec.interaction_id;
2328: END IF;
2329: IF(p_interaction_rec.attribute9 <> fnd_api.g_miss_char) THEN
2330: UPDATE jtf_ih_interactions SET ATTRIBUTE9 = p_interaction_rec.attribute9
2331: WHERE interaction_id = p_interaction_rec.interaction_id;
2332: END IF;
2333: IF(p_interaction_rec.attribute10 <> fnd_api.g_miss_char) THEN
2334: UPDATE jtf_ih_interactions SET ATTRIBUTE10 = p_interaction_rec.attribute10

Line 2334: UPDATE jtf_ih_interactions SET ATTRIBUTE10 = p_interaction_rec.attribute10

2330: UPDATE jtf_ih_interactions SET ATTRIBUTE9 = p_interaction_rec.attribute9
2331: WHERE interaction_id = p_interaction_rec.interaction_id;
2332: END IF;
2333: IF(p_interaction_rec.attribute10 <> fnd_api.g_miss_char) THEN
2334: UPDATE jtf_ih_interactions SET ATTRIBUTE10 = p_interaction_rec.attribute10
2335: WHERE interaction_id = p_interaction_rec.interaction_id;
2336: END IF;
2337: IF(p_interaction_rec.attribute11 <> fnd_api.g_miss_char) THEN
2338: UPDATE jtf_ih_interactions SET ATTRIBUTE11 = p_interaction_rec.attribute11

Line 2338: UPDATE jtf_ih_interactions SET ATTRIBUTE11 = p_interaction_rec.attribute11

2334: UPDATE jtf_ih_interactions SET ATTRIBUTE10 = p_interaction_rec.attribute10
2335: WHERE interaction_id = p_interaction_rec.interaction_id;
2336: END IF;
2337: IF(p_interaction_rec.attribute11 <> fnd_api.g_miss_char) THEN
2338: UPDATE jtf_ih_interactions SET ATTRIBUTE11 = p_interaction_rec.attribute11
2339: WHERE interaction_id = p_interaction_rec.interaction_id;
2340: END IF;
2341: IF(p_interaction_rec.attribute12 <> fnd_api.g_miss_char) THEN
2342: UPDATE jtf_ih_interactions SET ATTRIBUTE12 = p_interaction_rec.attribute12

Line 2342: UPDATE jtf_ih_interactions SET ATTRIBUTE12 = p_interaction_rec.attribute12

2338: UPDATE jtf_ih_interactions SET ATTRIBUTE11 = p_interaction_rec.attribute11
2339: WHERE interaction_id = p_interaction_rec.interaction_id;
2340: END IF;
2341: IF(p_interaction_rec.attribute12 <> fnd_api.g_miss_char) THEN
2342: UPDATE jtf_ih_interactions SET ATTRIBUTE12 = p_interaction_rec.attribute12
2343: WHERE interaction_id = p_interaction_rec.interaction_id;
2344: END IF;
2345: IF(p_interaction_rec.attribute13 <> fnd_api.g_miss_char) THEN
2346: UPDATE jtf_ih_interactions SET ATTRIBUTE13 = p_interaction_rec.attribute13

Line 2346: UPDATE jtf_ih_interactions SET ATTRIBUTE13 = p_interaction_rec.attribute13

2342: UPDATE jtf_ih_interactions SET ATTRIBUTE12 = p_interaction_rec.attribute12
2343: WHERE interaction_id = p_interaction_rec.interaction_id;
2344: END IF;
2345: IF(p_interaction_rec.attribute13 <> fnd_api.g_miss_char) THEN
2346: UPDATE jtf_ih_interactions SET ATTRIBUTE13 = p_interaction_rec.attribute13
2347: WHERE interaction_id = p_interaction_rec.interaction_id;
2348: END IF;
2349: IF(p_interaction_rec.attribute14 <> fnd_api.g_miss_char) THEN
2350: UPDATE jtf_ih_interactions SET ATTRIBUTE14 = p_interaction_rec.attribute14

Line 2350: UPDATE jtf_ih_interactions SET ATTRIBUTE14 = p_interaction_rec.attribute14

2346: UPDATE jtf_ih_interactions SET ATTRIBUTE13 = p_interaction_rec.attribute13
2347: WHERE interaction_id = p_interaction_rec.interaction_id;
2348: END IF;
2349: IF(p_interaction_rec.attribute14 <> fnd_api.g_miss_char) THEN
2350: UPDATE jtf_ih_interactions SET ATTRIBUTE14 = p_interaction_rec.attribute14
2351: WHERE interaction_id = p_interaction_rec.interaction_id;
2352: END IF;
2353: IF(p_interaction_rec.attribute15 <> fnd_api.g_miss_char) THEN
2354: UPDATE jtf_ih_interactions SET ATTRIBUTE15 = p_interaction_rec.attribute15

Line 2354: UPDATE jtf_ih_interactions SET ATTRIBUTE15 = p_interaction_rec.attribute15

2350: UPDATE jtf_ih_interactions SET ATTRIBUTE14 = p_interaction_rec.attribute14
2351: WHERE interaction_id = p_interaction_rec.interaction_id;
2352: END IF;
2353: IF(p_interaction_rec.attribute15 <> fnd_api.g_miss_char) THEN
2354: UPDATE jtf_ih_interactions SET ATTRIBUTE15 = p_interaction_rec.attribute15
2355: WHERE interaction_id = p_interaction_rec.interaction_id;
2356: END IF;
2357: IF(p_interaction_rec.attribute_category <> fnd_api.g_miss_char) THEN
2358: UPDATE jtf_ih_interactions SET ATTRIBUTE_CATEGORY = p_interaction_rec.attribute_category

Line 2358: UPDATE jtf_ih_interactions SET ATTRIBUTE_CATEGORY = p_interaction_rec.attribute_category

2354: UPDATE jtf_ih_interactions SET ATTRIBUTE15 = p_interaction_rec.attribute15
2355: WHERE interaction_id = p_interaction_rec.interaction_id;
2356: END IF;
2357: IF(p_interaction_rec.attribute_category <> fnd_api.g_miss_char) THEN
2358: UPDATE jtf_ih_interactions SET ATTRIBUTE_CATEGORY = p_interaction_rec.attribute_category
2359: WHERE interaction_id = p_interaction_rec.interaction_id;
2360: END IF;
2361: END IF;
2362: END IF;

Line 2364: --DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_interactions in JTF_IH_PUB_PS.Update_Interaction');

2360: END IF;
2361: END IF;
2362: END IF;
2363: END IF;
2364: --DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_interactions in JTF_IH_PUB_PS.Update_Interaction');
2365:
2366: IF ((p_interaction_rec.parent_id IS NOT NULL) AND (p_interaction_rec.parent_id <> fnd_api.g_miss_num)) THEN
2367: l_count := 0;
2368: SELECT count(*) into l_count

Line 2512: FROM jtf_ih_interactions

2508: p_interaction_rec);
2509: --DBMS_OUTPUT.PUT_LINE('PAST Update_Interaction in JTF_IH_PUB_PS.Close_Interaction');
2510:
2511: SELECT outcome_id into l_outcome_id
2512: FROM jtf_ih_interactions
2513: WHERE interaction_id = p_interaction_rec.interaction_id;
2514: IF (l_outcome_id IS NULL) THEN
2515: x_return_status := fnd_api.g_ret_sts_error;
2516: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),

Line 2522: FROM jtf_ih_interactions

2518: RETURN;
2519: END IF;
2520:
2521: SELECT end_date_time into l_end_date_time
2522: FROM jtf_ih_interactions
2523: WHERE interaction_id = p_interaction_rec.interaction_id;
2524: IF(l_end_date_time IS NULL) THEN
2525: l_end_date_time := SYSDATE;
2526: END IF;

Line 2528: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities

2524: IF(l_end_date_time IS NULL) THEN
2525: l_end_date_time := SYSDATE;
2526: END IF;
2527: --
2528: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
2529: --
2530: UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time
2531: WHERE interaction_id = p_interaction_rec.interaction_id;
2532:

Line 2530: UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time

2526: END IF;
2527: --
2528: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
2529: --
2530: UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time
2531: WHERE interaction_id = p_interaction_rec.interaction_id;
2532:
2533: FOR v_activity_id_c IN l_activity_id_c LOOP
2534: l_outcome_id := NULL;

Line 2883: -- Update table JTF_IH_INTERACTIONS

2879: END IF;
2880: --DBMS_OUTPUT.PUT_LINE('PAST Validate_Activity_Record in JTF_IH_PUB_PS.Update_Activity');
2881:
2882: --
2883: -- Update table JTF_IH_INTERACTIONS
2884: --
2885: IF (p_activity_rec.activity_id IS NULL) THEN
2886: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');
2887: RAISE fnd_api.g_exc_error;

Line 3108: FROM jtf_ih_interactions

3104: END IF;
3105: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Close_Interaction_2');
3106:
3107: SELECT outcome_id into l_outcome_id
3108: FROM jtf_ih_interactions
3109: WHERE interaction_id = p_interaction_id;
3110: IF (l_outcome_id IS NULL) THEN
3111: x_return_status := fnd_api.g_ret_sts_error;
3112: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

Line 3118: FROM jtf_ih_interactions

3114: RETURN;
3115: END IF;
3116:
3117: SELECT end_date_time into l_end_date_time
3118: FROM jtf_ih_interactions
3119: WHERE interaction_id = p_interaction_id;
3120: IF(l_end_date_time IS NULL) THEN
3121: l_end_date_time := SYSDATE;
3122: END IF;

Line 3124: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities

3120: IF(l_end_date_time IS NULL) THEN
3121: l_end_date_time := SYSDATE;
3122: END IF;
3123: --
3124: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
3125: --
3126: UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time
3127: WHERE interaction_id = p_interaction_id;
3128:

Line 3126: UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time

3122: END IF;
3123: --
3124: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
3125: --
3126: UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time
3127: WHERE interaction_id = p_interaction_id;
3128:
3129: FOR v_activity_id_c IN l_activity_id_c LOOP
3130: l_outcome_id := NULL;

Line 3262: -- Update table JTF_IH_INTERACTIONS

3258: END IF;
3259: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_ActivityDuration');
3260:
3261: --
3262: -- Update table JTF_IH_INTERACTIONS
3263: --
3264: IF (p_activity_id IS NULL) THEN
3265: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');
3266: RAISE fnd_api.g_exc_error;