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 dependencies on JTF_IH_ACTIVITIES

Line 1505: -- Check activity value in the JTF_IH_ACTIVITIES table.

1501: n_Dummy NUMBER;
1502: BEGIN
1503: -- if b_Ignore_Pass is 'Y' then always generate a new ID
1504: IF (n_activity_id IS NOT NULL) AND (n_activity_id <> fnd_api.g_miss_num) THEN
1505: -- Check activity value in the JTF_IH_ACTIVITIES table.
1506: BEGIN
1507: SELECT activity_id INTO n_Return FROM jtf_ih_activities WHERE activity_id = n_activity_id;
1508: -- If value is presend then return an error (invalid activity_id)
1509: IF n_Return IS NOT NULL THEN

Line 1507: SELECT activity_id INTO n_Return FROM jtf_ih_activities WHERE activity_id = n_activity_id;

1503: -- if b_Ignore_Pass is 'Y' then always generate a new ID
1504: IF (n_activity_id IS NOT NULL) AND (n_activity_id <> fnd_api.g_miss_num) THEN
1505: -- Check activity value in the JTF_IH_ACTIVITIES table.
1506: BEGIN
1507: SELECT activity_id INTO n_Return FROM jtf_ih_activities WHERE activity_id = n_activity_id;
1508: -- If value is presend then return an error (invalid activity_id)
1509: IF n_Return IS NOT NULL THEN
1510: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_ACTIV_ID');
1511: fnd_message.set_token('VALUE', n_activity_id);

Line 1522: SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;

1518: RETURN n_activity_id;
1519: END;
1520: ELSIF ((n_activity_id IS NULL) OR (n_activity_id = fnd_api.g_miss_num)) THEN
1521: LOOP
1522: SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;
1523: BEGIN
1524: SELECT activity_id INTO n_Dummy FROM jtf_ih_activities WHERE activity_id = n_Return;
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN

Line 1524: SELECT activity_id INTO n_Dummy FROM jtf_ih_activities WHERE activity_id = n_Return;

1520: ELSIF ((n_activity_id IS NULL) OR (n_activity_id = fnd_api.g_miss_num)) THEN
1521: LOOP
1522: SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;
1523: BEGIN
1524: SELECT activity_id INTO n_Dummy FROM jtf_ih_activities WHERE activity_id = n_Return;
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN
1527: EXIT;
1528: END;

Line 1548: -- Check activity value in the JTF_IH_ACTIVITIES table.

1544: n_Return NUMBER;
1545: n_Dummy NUMBER;
1546: BEGIN
1547: IF (n_interaction_id IS NOT NULL) AND (n_interaction_id <> fnd_api.g_miss_num) THEN
1548: -- Check activity value in the JTF_IH_ACTIVITIES table.
1549: BEGIN
1550: SELECT interaction_id INTO n_Return FROM jtf_ih_interactions WHERE interaction_id = n_interaction_id;
1551: -- If value is presend then return an error (invalid activity_id)
1552: IF n_Return IS NOT NULL THEN

Line 1590: -- Check activity value in the JTF_IH_ACTIVITIES table.

1586: n_Return NUMBER;
1587: n_Dummy NUMBER;
1588: BEGIN
1589: IF (n_media_id IS NOT NULL) AND (n_media_id <> fnd_api.g_miss_num) THEN
1590: -- Check activity value in the JTF_IH_ACTIVITIES table.
1591: BEGIN
1592: SELECT media_id INTO n_Return FROM jtf_ih_media_items WHERE media_id = n_media_id;
1593: -- If value is presend then return an error (invalid activity_id)
1594: IF n_Return IS NOT NULL THEN

Line 1633: -- Check activity value in the JTF_IH_ACTIVITIES table.

1629: n_Return NUMBER;
1630: n_Dummy NUMBER;
1631: BEGIN
1632: IF (n_milcs_id IS NOT NULL) AND (n_milcs_id <> fnd_api.g_miss_num) THEN
1633: -- Check activity value in the JTF_IH_ACTIVITIES table.
1634: BEGIN
1635: SELECT milcs_id INTO n_Return FROM jtf_ih_media_item_lc_segs WHERE milcs_id = n_milcs_id;
1636: -- If value is presend then return an error (invalid activity_id)
1637: IF n_Return IS NOT NULL THEN

Line 2738: -- INSERT ALL VALUES TO JTF_IH_ACTIVITIES

2734: -- Activity by Call Create_Interaction API
2735: -- Igor Aleshin 21-DEC-2001 Fix for bugdb - 2153913 - PREVENT G_MISS_DATE VALUE FROM BEING
2736: -- WRITTEN TO THE END_DATE_TIME VALUE.
2737: -- Igor Aleshin 21-FEB-2002 Fix for bugdb - 2235155 - JTF_IH_PUB.CREATE_INTERACTION DOESN'T
2738: -- INSERT ALL VALUES TO JTF_IH_ACTIVITIES
2739: -- Igor Aleshin 04-MAR-2002 Added Attributes to Activity_Rec.
2740: -- Igor Aleshin 18-APR-2001 Fix for bugdb 2323210 - 1157.6RI:API
2741: -- ERR:JTF_IH_PUB.CLOSE_INTERACTION:WHEN DISAGREE WITH OKC IN IBE
2742: -- Igor Aleshin 10-MAY-2002 ENH# 2079963 - NEED INTERACTION HISTORY RECORD TO SUPPORT MULTIPLE AGENTS

Line 3079: -- SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;

3075:
3076: for idx in 1 .. p_activities.count loop
3077: --Bug# 2817083
3078: --IF ((p_activities(idx).activity_id IS NULL) OR (p_activities(idx).activity_id = fnd_api.g_miss_num)) THEN
3079: -- SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;
3080: --END IF;
3081:
3082: -- Bug# 2323210
3083: if(p_activities(idx).start_date_time <> fnd_api.g_miss_date) AND (p_activities(idx).start_date_time IS NOT NULL) then

Line 3133: insert into jtf_ih_Activities

3129: RAISE fnd_api.g_exc_error;
3130: END IF;
3131:
3132: -- DBMS_OUTPUT.PUT_LINE('PAST activity id validation');
3133: insert into jtf_ih_Activities
3134: (
3135: OBJECT_ID,
3136: OBJECT_TYPE,
3137: SOURCE_CODE_ID,

Line 3479: FROM jtf_ih_Activities

3475: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3476: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3477:
3478: SELECT count(activity_id) into actionCount
3479: FROM jtf_ih_Activities
3480: where outcome_id = p_outcome_id
3481: and result_id = p_result_id
3482: and reason_id = p_reason_id
3483: and media_id = p_media_id

Line 3492: FROM jtf_ih_Activities

3488: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3489: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3490:
3491: SELECT count(activity_id) into actionCount
3492: FROM jtf_ih_Activities
3493: where outcome_id = p_outcome_id
3494: and result_id = p_result_id
3495: and reason_id = p_reason_id
3496: ;

Line 3504: FROM jtf_ih_Activities

3500: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3501: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3502:
3503: SELECT count(activity_id) into actionCount
3504: FROM jtf_ih_Activities
3505: where outcome_id = p_outcome_id
3506: and result_id = p_result_id
3507: and media_id = p_media_id
3508: ;

Line 3516: FROM jtf_ih_Activities

3512: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3513: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3514:
3515: SELECT count(*) into actionCount
3516: FROM jtf_ih_Activities
3517: where outcome_id = p_outcome_id
3518: and result_id = p_result_id
3519: ;
3520: x_activity_count := actionCount;

Line 3527: FROM jtf_ih_Activities

3523: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3524: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3525:
3526: SELECT count(*) into actionCount
3527: FROM jtf_ih_Activities
3528: where outcome_id = p_outcome_id
3529: and reason_id = p_reason_id
3530: and media_id = p_media_id
3531: ;

Line 3539: FROM jtf_ih_Activities

3535: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3536: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3537:
3538: SELECT count(*) into actionCount
3539: FROM jtf_ih_Activities
3540: where outcome_id = p_outcome_id
3541: and reason_id = p_reason_id
3542: ;
3543: x_activity_count := actionCount;

Line 3550: FROM jtf_ih_Activities

3546: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3547: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3548:
3549: SELECT count(*) into actionCount
3550: FROM jtf_ih_Activities
3551: where outcome_id = p_outcome_id
3552: and media_id = p_media_id
3553: ;
3554: x_activity_count := actionCount;

Line 3561: FROM jtf_ih_Activities

3557: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3558: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3559:
3560: SELECT count(*) into actionCount
3561: FROM jtf_ih_Activities
3562: where outcome_id = p_outcome_id
3563: ;
3564: x_activity_count := actionCount;
3565: ELSIF (((p_outcome_id IS NULL) OR (p_outcome_id = fnd_api.g_miss_num)) AND

Line 3571: FROM jtf_ih_Activities

3567: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3568: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3569:
3570: SELECT count(*) into actionCount
3571: FROM jtf_ih_Activities
3572: where outcome_id = p_outcome_id
3573: and result_id = p_result_id
3574: and reason_id = p_reason_id
3575: and media_id = p_media_id

Line 3584: FROM jtf_ih_Activities

3580: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3581: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3582:
3583: SELECT count(*) into actionCount
3584: FROM jtf_ih_Activities
3585: where outcome_id = p_outcome_id
3586: and result_id = p_result_id
3587: and reason_id = p_reason_id
3588: ;

Line 3596: FROM jtf_ih_Activities

3592: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3593: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3594:
3595: SELECT count(*) into actionCount
3596: FROM jtf_ih_Activities
3597: where outcome_id = p_outcome_id
3598: and result_id = p_result_id
3599: and media_id = p_media_id
3600: ;

Line 3608: FROM jtf_ih_Activities

3604: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3605: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3606:
3607: SELECT count(*) into actionCount
3608: FROM jtf_ih_Activities
3609: where outcome_id = p_outcome_id
3610: and result_id = p_result_id
3611: ;
3612: x_activity_count := actionCount;

Line 3619: FROM jtf_ih_Activities

3615: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3616: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3617:
3618: SELECT count(*) into actionCount
3619: FROM jtf_ih_Activities
3620: where outcome_id = p_outcome_id
3621: and reason_id = p_reason_id
3622: and media_id = p_media_id
3623: ;

Line 3631: FROM jtf_ih_Activities

3627: ((p_reason_id IS NOT NULL) OR (p_reason_id <> fnd_api.g_miss_num)) AND
3628: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3629:
3630: SELECT count(*) into actionCount
3631: FROM jtf_ih_Activities
3632: where outcome_id = p_outcome_id
3633: and reason_id = p_reason_id
3634: ;
3635: x_activity_count := actionCount;

Line 3642: FROM jtf_ih_Activities

3638: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3639: ((p_media_id IS NOT NULL) OR (p_media_id <> fnd_api.g_miss_num))) THEN
3640:
3641: SELECT count(*) into actionCount
3642: FROM jtf_ih_Activities
3643: where outcome_id = p_outcome_id
3644: and media_id = p_media_id
3645: ;
3646: x_activity_count := actionCount;

Line 3653: FROM jtf_ih_Activities

3649: ((p_reason_id IS NULL) OR (p_reason_id = fnd_api.g_miss_num)) AND
3650: ((p_media_id IS NULL) OR (p_media_id = fnd_api.g_miss_num))) THEN
3651:
3652: SELECT count(*) into actionCount
3653: FROM jtf_ih_Activities
3654: where outcome_id = p_outcome_id
3655: ;
3656: x_activity_count := actionCount;
3657: END IF;

Line 3937: -- Igor Aleshin 12-MAY-2001 Added request for the column Script_Trans_ID in the JTF_IH_ACTIVITIES.

3933: -- James Baldo Jr. 25-APR-2000 User Hooks Customer and Vertical Industry
3934: -- James Baldo Jr. 02-MAY-2000 Fix for Start_Date_Time and End_Date_Time bugdb # 1286036
3935: -- James Baldo Jr. 27-JUL-2000 Fix for Start_Date_Time initialization when G_MISS_DATE
3936: -- for bugdb # 1339916.
3937: -- Igor Aleshin 12-MAY-2001 Added request for the column Script_Trans_ID in the JTF_IH_ACTIVITIES.
3938: -- Igor Aleshin 21-DEC-2001 Fix for bugdb - 2153913 - PREVENT G_MISS_DATE VALUE FROM BEING
3939: -- WRITTEN TO THE END_DATE_TIME VALUE.
3940: -- Igor Aleshin 18-APR-2001 Fix for bugdb 2323210 - 1157.6RI:API
3941: -- ERR:JTF_IH_PUB.CLOSE_INTERACTION:WHEN DISAGREE WITH OKC IN IBE

Line 5351: SELECT activity_id FROM jtf_ih_activities

5347: -- Perf fix for literal Usage
5348: l_active_perf VARCHAR2(1);
5349:
5350: CURSOR l_activity_id_c IS
5351: SELECT activity_id FROM jtf_ih_activities
5352: WHERE interaction_id = p_interaction_rec.interaction_id;
5353: BEGIN
5354: SAVEPOINT close_interaction_pub1;
5355:

Line 5423: FROM jtf_ih_activities

5419: END IF;
5420: END IF;
5421: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Close_Interaction');
5422: SELECT count(*) into l_count
5423: FROM jtf_ih_activities
5424: WHERE interaction_id = p_interaction_rec.interaction_id;
5425: -- DBMS_OUTPUT.PUT_LINE('lcount = ' || l_count);
5426: IF (l_count <= 0) THEN
5427: x_return_status := fnd_api.g_ret_sts_error;

Line 5545: FROM jtf_ih_activities

5541: -- Added by IAleshin 21-MAY-2002
5542: --
5543: SELECT outcome_id, action_item_id, start_date_time, end_date_time, duration
5544: INTO la_outcome_id, l_action_item_id, la_start_date_time, la_end_date_time, la_duration
5545: FROM jtf_ih_activities
5546: WHERE activity_id = v_activity_id_c.activity_id;
5547:
5548:
5549: IF (la_outcome_id IS NULL) OR (la_outcome_id = fnd_api.g_miss_num) THEN

Line 5607: UPDATE jtf_ih_activities SET ACTIVE = l_active_perf,

5603: IF (la_duration IS NULL) OR (la_duration = 0) THEN
5604: la_duration := ROUND((la_end_date_time - la_start_date_time)*24*60*60);
5605: END IF;
5606: -- Perf fix for literal Usage
5607: UPDATE jtf_ih_activities SET ACTIVE = l_active_perf,
5608: END_DATE_TIME = la_end_date_time, DURATION = la_duration
5609: WHERE ACTIVITY_ID = v_activity_id_c.activity_id;
5610:
5611: /* --Commented by IAleshin 21-MAY-2002

Line 5616: FROM jtf_ih_activities

5612: ----
5613: l_outcome_id := NULL;
5614: SELECT outcome_id
5615: into l_outcome_id
5616: FROM jtf_ih_activities
5617: WHERE activity_id = v_activity_id_c.activity_id;
5618: IF (l_outcome_id IS NULL) THEN
5619: x_return_status := fnd_api.g_ret_sts_error;
5620: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

Line 5645: FROM jtf_ih_activities

5641: END IF;
5642:
5643: SELECT end_date_time, outcome_id
5644: into l_end_date_time, l_outcome_id
5645: FROM jtf_ih_activities
5646: WHERE activity_id = v_activity_id_c.activity_id;
5647: IF (l_outcome_id IS NULL) or (l_outcome_id = fnd_api.g_miss_num) THEN
5648: x_return_status := fnd_api.g_ret_sts_error;
5649: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),

Line 5663: UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time

5659:
5660: IF(l_end_date_time IS NULL) or (l_end_date_time = fnd_api.g_miss_date) THEN
5661: l_end_date_time := SYSDATE;
5662: END IF;
5663: UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time
5664: WHERE activity_id = v_activity_id_c.activity_id;*/
5665: END LOOP;
5666: -- DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB.Close_Interaction');
5667:

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

5666: -- DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB.Close_Interaction');
5667:
5668: -- Changed location by IAleshin
5669: -- Bug# 2418028
5670: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
5671: --
5672: -- Check if end_date_time is currently 'null' or 'fnd_api.g_miss_date'
5673: -- If either of the above is true, then set end_date_time to sysdate
5674: --

Line 5962: --SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;

5958:
5959: -- Bug 2817083
5960: --l_activity_id := Get_Activity_ID(NULL);
5961: l_activity_rec.activity_id := Get_Activity_ID(NULL);
5962: --SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;
5963:
5964: validate_source_code(l_api_name_full, l_activity_rec.source_code_id, l_activity_rec.source_code, x_return_status);
5965: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
5966: RAISE fnd_api.g_exc_error;

Line 5969: INSERT INTO jtf_ih_Activities

5965: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
5966: RAISE fnd_api.g_exc_error;
5967: END IF;
5968:
5969: INSERT INTO jtf_ih_Activities
5970: (
5971: ACTIVITY_ID,
5972: OBJECT_ID,
5973: OBJECT_TYPE,

Line 6073: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_activities in JTF_IH_PUB.Add_Activity');

6069: decode( p_activity_rec.script_trans_id, fnd_api.g_miss_num, null, p_activity_rec.script_trans_id),
6070: decode( p_activity_rec.role, fnd_api.g_miss_char, null, p_activity_rec.role)
6071: -- ,l_activity_rec.resource_id
6072: );
6073: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_activities in JTF_IH_PUB.Add_Activity');
6074:
6075: --
6076: -- Set OUT value
6077: --

Line 6246: CURSOR c_Activity_crs IS SELECT * FROM JTF_IH_ACTIVITIES

6242: l_recalc_duration BOOLEAN;
6243:
6244: l_profile_id VARCHAR2(20); --profile option id check to update closed interaction
6245:
6246: CURSOR c_Activity_crs IS SELECT * FROM JTF_IH_ACTIVITIES
6247: WHERE Activity_ID = p_activity_rec.activity_id;
6248: rc_Activity c_Activity_crs%ROWTYPE;
6249:
6250: BEGIN

Line 6341: FROM jtf_ih_activities

6337: RAISE fnd_api.g_exc_error;
6338: ELSE
6339: l_count := 0;
6340: SELECT count(*) into l_count
6341: FROM jtf_ih_activities
6342: WHERE activity_id = p_activity_rec.activity_id;
6343: IF (l_count <> 1) THEN
6344: x_return_status := fnd_api.g_ret_sts_error;
6345: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),

Line 6769: UPDATE jtf_ih_activities SET

6765: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
6766: RAISE fnd_api.g_exc_error;
6767: END IF;
6768:
6769: UPDATE jtf_ih_activities SET
6770: cust_account_id = l_activity_rec.cust_account_id,
6771: cust_org_id = l_activity_rec.cust_org_id,
6772: role = l_activity_rec.role,
6773: LAST_UPDATED_BY = p_user_id,

Line 6828: -- DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_activities in JTF_IH_PUB.Update_Activity');

6824: RAISE fnd_api.g_exc_error ;
6825: END IF;
6826: END IF;
6827: END IF;
6828: -- DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_activities in JTF_IH_PUB.Update_Activity');
6829:
6830: -- Post processing Call
6831:
6832: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'A', 'V') THEN

Line 6951: SELECT activity_id FROM jtf_ih_activities

6947: l_duration_perf NUMBER;
6948: l_active_perf VARCHAR2(1);
6949:
6950: CURSOR l_activity_id_c IS
6951: SELECT activity_id FROM jtf_ih_activities
6952: WHERE interaction_id = p_interaction_id;
6953: BEGIN
6954: SAVEPOINT close_interaction_pub2;
6955:

Line 7061: FROM jtf_ih_activities

7057: -- Added by IAleshin 21-MAY-2002
7058: --
7059: SELECT outcome_id, action_item_id, start_date_time, end_date_time, duration
7060: INTO la_outcome_id, l_action_item_id, la_start_date_time, la_end_date_time, la_duration
7061: FROM jtf_ih_activities
7062: WHERE activity_id = v_activity_id_c.activity_id;
7063:
7064:
7065: IF (l_outcome_id IS NULL) OR (l_outcome_id = fnd_api.g_miss_num) THEN

Line 7120: UPDATE jtf_ih_activities SET ACTIVE = l_active_perf,END_DATE_TIME = la_end_date_time, DURATION = la_duration

7116: END IF;
7117: IF (la_duration = 0) OR (la_duration IS NULL) THEN
7118: la_duration := ROUND((la_end_date_time - la_start_date_time)*24*60*60);
7119: END IF;
7120: UPDATE jtf_ih_activities SET ACTIVE = l_active_perf,END_DATE_TIME = la_end_date_time, DURATION = la_duration
7121: WHERE ACTIVITY_ID = v_activity_id_c.activity_id;
7122: /*l_outcome_id := NULL;
7123: SELECT outcome_id into l_outcome_id
7124: FROM jtf_ih_activities

Line 7124: FROM jtf_ih_activities

7120: UPDATE jtf_ih_activities SET ACTIVE = l_active_perf,END_DATE_TIME = la_end_date_time, DURATION = la_duration
7121: WHERE ACTIVITY_ID = v_activity_id_c.activity_id;
7122: /*l_outcome_id := NULL;
7123: SELECT outcome_id into l_outcome_id
7124: FROM jtf_ih_activities
7125: WHERE activity_id = v_activity_id_c.activity_id;
7126: IF (l_outcome_id IS NULL) THEN
7127: x_return_status := fnd_api.g_ret_sts_error;
7128: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

Line 7135: FROM jtf_ih_activities

7131: END IF;
7132:
7133: l_action_item_id := NULL;
7134: SELECT action_item_id into l_action_item_id
7135: FROM jtf_ih_activities
7136: WHERE activity_id = v_activity_id_c.activity_id;
7137: IF (l_action_item_id IS NULL) THEN
7138: x_return_status := fnd_api.g_ret_sts_error;
7139: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),

Line 7146: FROM jtf_ih_activities

7142: END IF;
7143:
7144: l_duration := NULL;
7145: SELECT end_date_time, start_date_time into l_end_date_time, l_start_date_time
7146: FROM jtf_ih_activities
7147: WHERE activity_id = v_activity_id_c.activity_id;
7148: IF ((l_end_date_time IS NULL) OR (l_end_date_time = FND_API.G_MISS_DATE)) THEN
7149: l_end_date_time := SYSDATE;
7150: END IF;

Line 7158: UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time, duration = l_duration

7154: IF l_duration = FND_API.G_MISS_NUM
7155: THEN l_duration:= NULL;
7156: END IF;
7157:
7158: UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time, duration = l_duration
7159: WHERE interaction_id = p_interaction_id;*/
7160: END LOOP;
7161: -- DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB.Close_Interaction_2');
7162:

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

7161: -- DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB.Close_Interaction_2');
7162:
7163: -- Bug# 2418345
7164: --
7165: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
7166: --
7167: -- Perf fix for literal Usage
7168: UPDATE jtf_ih_interactions SET ACTIVE = l_active_perf,end_date_time =l_end_date_time,
7169: duration = decode(l_duration, fnd_api.g_miss_num, l_duration_perf, l_duration)

Line 7383: FROM jtf_ih_activities

7379: --
7380:
7381: SELECT start_date_time, end_date_time, duration, active into
7382: l_start_date_time, l_end_date_time, l_duration, l_active
7383: FROM jtf_ih_activities
7384: WHERE activity_id = p_activity_id;
7385: --
7386: -- If the activity is not active, then refuse the update.
7387: --

Line 7429: UPDATE jtf_ih_activities SET END_DATE_TIME = l_end_date_time,

7425: l_duration := p_duration;
7426: END IF;
7427:
7428: -- Update the activity
7429: UPDATE jtf_ih_activities SET END_DATE_TIME = l_end_date_time,
7430: DURATION = l_duration,
7431: OBJECT_VERSION_NUMBER = p_object_version
7432: WHERE activity_id = p_activity_id;
7433: -- DBMS_OUTPUT.PUT_LINE('PAST update end_date_time and duration in JTF_IH_PUB.Update_ActivityDuration');