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_ACTIVITIES

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

1450:
1451: Default_activity_table(l_activities);
1452: for idx in 1 .. p_activities.count loop
1453: IF ((p_activities(idx).activity_id IS NULL) OR (p_activities(idx).activity_id = fnd_api.g_miss_num)) THEN
1454: SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;
1455: END IF;
1456: insert into jtf_ih_Activities
1457: (
1458: OBJECT_ID,

Line 1456: insert into jtf_ih_Activities

1452: for idx in 1 .. p_activities.count loop
1453: IF ((p_activities(idx).activity_id IS NULL) OR (p_activities(idx).activity_id = fnd_api.g_miss_num)) THEN
1454: SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;
1455: END IF;
1456: insert into jtf_ih_Activities
1457: (
1458: OBJECT_ID,
1459: OBJECT_TYPE,
1460: SOURCE_CODE_ID,

Line 1639: FROM jtf_ih_Activities

1635: END IF;
1636: END IF;
1637:
1638: SELECT count(*) into actionCount
1639: FROM jtf_ih_Activities
1640: where outcome_id = p_outcome_id
1641: and result_id = p_result_id
1642: and reason_id = p_reason_id
1643: and media_id = p_media_id

Line 2452: SELECT activity_id FROM jtf_ih_activities

2448: l_outcome_id NUMBER := NULL;
2449: l_end_date_time DATE := NULL;
2450: l_action_item_id NUMBER := NULL;
2451: CURSOR l_activity_id_c IS
2452: SELECT activity_id FROM jtf_ih_activities
2453: WHERE interaction_id = p_interaction_rec.interaction_id;
2454: BEGIN
2455: SAVEPOINT close_interaction_pub1;
2456:

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 2536: FROM jtf_ih_activities

2532:
2533: FOR v_activity_id_c IN l_activity_id_c LOOP
2534: l_outcome_id := NULL;
2535: SELECT outcome_id into l_outcome_id
2536: FROM jtf_ih_activities
2537: WHERE activity_id = v_activity_id_c.activity_id;
2538: IF (l_outcome_id IS NULL) THEN
2539: x_return_status := fnd_api.g_ret_sts_error;
2540: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

Line 2547: FROM jtf_ih_activities

2543: END IF;
2544:
2545: l_action_item_id := NULL;
2546: SELECT action_item_id into l_action_item_id
2547: FROM jtf_ih_activities
2548: WHERE activity_id = v_activity_id_c.activity_id;
2549: IF (l_action_item_id IS NULL) THEN
2550: x_return_status := fnd_api.g_ret_sts_error;
2551: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),

Line 2557: FROM jtf_ih_activities

2553: RETURN;
2554: END IF;
2555:
2556: SELECT end_date_time into l_end_date_time
2557: FROM jtf_ih_activities
2558: WHERE activity_id = v_activity_id_c.activity_id;
2559: IF(l_end_date_time IS NULL) THEN
2560: l_end_date_time := SYSDATE;
2561: END IF;

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

2558: WHERE activity_id = v_activity_id_c.activity_id;
2559: IF(l_end_date_time IS NULL) THEN
2560: l_end_date_time := SYSDATE;
2561: END IF;
2562: UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time
2563: WHERE interaction_id = p_interaction_rec.interaction_id;
2564: END LOOP;
2565: --DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB_PS.Close_Interaction');
2566:

Line 2705: SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;

2701: --DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB_PS.Add_Activity');
2702: l_duration := ROUND((p_activity_rec.end_date_time - l_start_date_time)*24*60);
2703: END IF;
2704:
2705: SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;
2706:
2707: INSERT INTO jtf_ih_Activities
2708: (
2709: ACTIVITY_ID,

Line 2707: INSERT INTO jtf_ih_Activities

2703: END IF;
2704:
2705: SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;
2706:
2707: INSERT INTO jtf_ih_Activities
2708: (
2709: ACTIVITY_ID,
2710: OBJECT_ID,
2711: OBJECT_TYPE,

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

2761: Sysdate,
2762: p_login_id,
2763: l_active
2764: );
2765: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_activities in JTF_IH_PUB_PS.Add_Activity');
2766:
2767: --
2768: -- Set OUT value
2769: --

Line 2891: FROM jtf_ih_activities

2887: RAISE fnd_api.g_exc_error;
2888: ELSE
2889: l_count := 0;
2890: SELECT count(*) into l_count
2891: FROM jtf_ih_activities
2892: WHERE activity_id = p_activity_rec.activity_id;
2893: IF (l_count <> 1) THEN
2894: x_return_status := fnd_api.g_ret_sts_error;
2895: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),

Line 2899: SELECT active into l_active FROM jtf_ih_activities

2895: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),
2896: 'activity_id');
2897: RETURN;
2898: ELSE
2899: SELECT active into l_active FROM jtf_ih_activities
2900: WHERE activity_id = p_activity_rec.activity_id;
2901: IF(l_active <> 'N') THEN
2902: SELECT start_date_time into l_start_date_time FROM jtf_ih_activities
2903: WHERE activity_id = p_activity_rec.activity_id;

Line 2902: SELECT start_date_time into l_start_date_time FROM jtf_ih_activities

2898: ELSE
2899: SELECT active into l_active FROM jtf_ih_activities
2900: WHERE activity_id = p_activity_rec.activity_id;
2901: IF(l_active <> 'N') THEN
2902: SELECT start_date_time into l_start_date_time FROM jtf_ih_activities
2903: WHERE activity_id = p_activity_rec.activity_id;
2904: IF(p_activity_rec.duration IS NOT NULL) THEN
2905: l_duration := p_activity_rec.duration;
2906: ELSIF(p_activity_rec.end_date_time IS NOT NULL) THEN

Line 2923: UPDATE jtf_ih_activities SET DURATION = l_duration

2919: --DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB_PS.Update_Activity');
2920: l_duration := ROUND((p_activity_rec.end_date_time - p_activity_rec.start_date_time)*24*60);
2921: END IF;
2922: IF(l_duration IS NOT NULL) THEN
2923: UPDATE jtf_ih_activities SET DURATION = l_duration
2924: WHERE activity_id = p_activity_rec.activity_id;
2925: END IF;
2926: IF(p_activity_rec.end_date_time <> fnd_api.g_miss_date) THEN
2927: UPDATE jtf_ih_activities SET END_DATE_TIME = p_activity_rec.end_date_time

Line 2927: UPDATE jtf_ih_activities SET END_DATE_TIME = p_activity_rec.end_date_time

2923: UPDATE jtf_ih_activities SET DURATION = l_duration
2924: WHERE activity_id = p_activity_rec.activity_id;
2925: END IF;
2926: IF(p_activity_rec.end_date_time <> fnd_api.g_miss_date) THEN
2927: UPDATE jtf_ih_activities SET END_DATE_TIME = p_activity_rec.end_date_time
2928: WHERE activity_id = p_activity_rec.activity_id;
2929: END IF;
2930: IF(p_activity_rec.cust_account_id <> fnd_api.g_miss_num) THEN
2931: UPDATE jtf_ih_activities SET CUST_ACCOUNT_ID = p_activity_rec.cust_account_id

Line 2931: UPDATE jtf_ih_activities SET CUST_ACCOUNT_ID = p_activity_rec.cust_account_id

2927: UPDATE jtf_ih_activities SET END_DATE_TIME = p_activity_rec.end_date_time
2928: WHERE activity_id = p_activity_rec.activity_id;
2929: END IF;
2930: IF(p_activity_rec.cust_account_id <> fnd_api.g_miss_num) THEN
2931: UPDATE jtf_ih_activities SET CUST_ACCOUNT_ID = p_activity_rec.cust_account_id
2932: WHERE activity_id = p_activity_rec.activity_id;
2933: END IF;
2934: IF(p_activity_rec.cust_org_id <> fnd_api.g_miss_num) THEN
2935: UPDATE jtf_ih_activities SET CUST_ORG_ID = p_activity_rec.cust_org_id

Line 2935: UPDATE jtf_ih_activities SET CUST_ORG_ID = p_activity_rec.cust_org_id

2931: UPDATE jtf_ih_activities SET CUST_ACCOUNT_ID = p_activity_rec.cust_account_id
2932: WHERE activity_id = p_activity_rec.activity_id;
2933: END IF;
2934: IF(p_activity_rec.cust_org_id <> fnd_api.g_miss_num) THEN
2935: UPDATE jtf_ih_activities SET CUST_ORG_ID = p_activity_rec.cust_org_id
2936: WHERE activity_id = p_activity_rec.activity_id;
2937: END IF;
2938: IF(p_activity_rec.role <> fnd_api.g_miss_char) THEN
2939: UPDATE jtf_ih_activities SET ROLE = p_activity_rec.role

Line 2939: UPDATE jtf_ih_activities SET ROLE = p_activity_rec.role

2935: UPDATE jtf_ih_activities SET CUST_ORG_ID = p_activity_rec.cust_org_id
2936: WHERE activity_id = p_activity_rec.activity_id;
2937: END IF;
2938: IF(p_activity_rec.role <> fnd_api.g_miss_char) THEN
2939: UPDATE jtf_ih_activities SET ROLE = p_activity_rec.role
2940: WHERE activity_id = p_activity_rec.activity_id;
2941: END IF;
2942: IF(p_activity_rec.outcome_id <> fnd_api.g_miss_num) THEN
2943: UPDATE jtf_ih_activities SET OUTCOME_ID = p_activity_rec.outcome_id

Line 2943: UPDATE jtf_ih_activities SET OUTCOME_ID = p_activity_rec.outcome_id

2939: UPDATE jtf_ih_activities SET ROLE = p_activity_rec.role
2940: WHERE activity_id = p_activity_rec.activity_id;
2941: END IF;
2942: IF(p_activity_rec.outcome_id <> fnd_api.g_miss_num) THEN
2943: UPDATE jtf_ih_activities SET OUTCOME_ID = p_activity_rec.outcome_id
2944: WHERE activity_id = p_activity_rec.activity_id;
2945: END IF;
2946: IF(p_activity_rec.result_id <> fnd_api.g_miss_num) THEN
2947: UPDATE jtf_ih_activities SET RESULT_ID = p_activity_rec.result_id

Line 2947: UPDATE jtf_ih_activities SET RESULT_ID = p_activity_rec.result_id

2943: UPDATE jtf_ih_activities SET OUTCOME_ID = p_activity_rec.outcome_id
2944: WHERE activity_id = p_activity_rec.activity_id;
2945: END IF;
2946: IF(p_activity_rec.result_id <> fnd_api.g_miss_num) THEN
2947: UPDATE jtf_ih_activities SET RESULT_ID = p_activity_rec.result_id
2948: WHERE activity_id = p_activity_rec.activity_id;
2949: END IF;
2950: IF(p_activity_rec.reason_id <> fnd_api.g_miss_num) THEN
2951: UPDATE jtf_ih_activities SET REASON_ID = p_activity_rec.reason_id

Line 2951: UPDATE jtf_ih_activities SET REASON_ID = p_activity_rec.reason_id

2947: UPDATE jtf_ih_activities SET RESULT_ID = p_activity_rec.result_id
2948: WHERE activity_id = p_activity_rec.activity_id;
2949: END IF;
2950: IF(p_activity_rec.reason_id <> fnd_api.g_miss_num) THEN
2951: UPDATE jtf_ih_activities SET REASON_ID = p_activity_rec.reason_id
2952: WHERE activity_id = p_activity_rec.activity_id;
2953: END IF;
2954: IF(p_activity_rec.task_id <> fnd_api.g_miss_num) THEN
2955: UPDATE jtf_ih_activities SET TASK_ID = p_activity_rec.task_id

Line 2955: UPDATE jtf_ih_activities SET TASK_ID = p_activity_rec.task_id

2951: UPDATE jtf_ih_activities SET REASON_ID = p_activity_rec.reason_id
2952: WHERE activity_id = p_activity_rec.activity_id;
2953: END IF;
2954: IF(p_activity_rec.task_id <> fnd_api.g_miss_num) THEN
2955: UPDATE jtf_ih_activities SET TASK_ID = p_activity_rec.task_id
2956: WHERE activity_id = p_activity_rec.activity_id;
2957: END IF;
2958: IF(p_activity_rec.object_id <> fnd_api.g_miss_num) THEN
2959: UPDATE jtf_ih_activities SET OBJECT_ID = p_activity_rec.object_id

Line 2959: UPDATE jtf_ih_activities SET OBJECT_ID = p_activity_rec.object_id

2955: UPDATE jtf_ih_activities SET TASK_ID = p_activity_rec.task_id
2956: WHERE activity_id = p_activity_rec.activity_id;
2957: END IF;
2958: IF(p_activity_rec.object_id <> fnd_api.g_miss_num) THEN
2959: UPDATE jtf_ih_activities SET OBJECT_ID = p_activity_rec.object_id
2960: WHERE activity_id = p_activity_rec.activity_id;
2961: END IF;
2962: IF(p_activity_rec.object_type <> fnd_api.g_miss_char) THEN
2963: UPDATE jtf_ih_activities SET OBJECT_TYPE = p_activity_rec.object_type

Line 2963: UPDATE jtf_ih_activities SET OBJECT_TYPE = p_activity_rec.object_type

2959: UPDATE jtf_ih_activities SET OBJECT_ID = p_activity_rec.object_id
2960: WHERE activity_id = p_activity_rec.activity_id;
2961: END IF;
2962: IF(p_activity_rec.object_type <> fnd_api.g_miss_char) THEN
2963: UPDATE jtf_ih_activities SET OBJECT_TYPE = p_activity_rec.object_type
2964: WHERE activity_id = p_activity_rec.activity_id;
2965: END IF;
2966: IF(p_activity_rec.source_code_id <> fnd_api.g_miss_num) THEN
2967: UPDATE jtf_ih_activities SET SOURCE_CODE_ID = p_activity_rec.source_code_id

Line 2967: UPDATE jtf_ih_activities SET SOURCE_CODE_ID = p_activity_rec.source_code_id

2963: UPDATE jtf_ih_activities SET OBJECT_TYPE = p_activity_rec.object_type
2964: WHERE activity_id = p_activity_rec.activity_id;
2965: END IF;
2966: IF(p_activity_rec.source_code_id <> fnd_api.g_miss_num) THEN
2967: UPDATE jtf_ih_activities SET SOURCE_CODE_ID = p_activity_rec.source_code_id
2968: WHERE activity_id = p_activity_rec.activity_id;
2969: END IF;
2970: IF(p_activity_rec.source_code <> fnd_api.g_miss_char) THEN
2971: UPDATE jtf_ih_activities SET SOURCE_CODE = p_activity_rec.source_code

Line 2971: UPDATE jtf_ih_activities SET SOURCE_CODE = p_activity_rec.source_code

2967: UPDATE jtf_ih_activities SET SOURCE_CODE_ID = p_activity_rec.source_code_id
2968: WHERE activity_id = p_activity_rec.activity_id;
2969: END IF;
2970: IF(p_activity_rec.source_code <> fnd_api.g_miss_char) THEN
2971: UPDATE jtf_ih_activities SET SOURCE_CODE = p_activity_rec.source_code
2972: WHERE activity_id = p_activity_rec.activity_id;
2973: END IF;
2974: IF(p_activity_rec.doc_id <> fnd_api.g_miss_num) THEN
2975: UPDATE jtf_ih_activities SET DOC_ID = p_activity_rec.doc_id

Line 2975: UPDATE jtf_ih_activities SET DOC_ID = p_activity_rec.doc_id

2971: UPDATE jtf_ih_activities SET SOURCE_CODE = p_activity_rec.source_code
2972: WHERE activity_id = p_activity_rec.activity_id;
2973: END IF;
2974: IF(p_activity_rec.doc_id <> fnd_api.g_miss_num) THEN
2975: UPDATE jtf_ih_activities SET DOC_ID = p_activity_rec.doc_id
2976: WHERE activity_id = p_activity_rec.activity_id;
2977: END IF;
2978: IF(p_activity_rec.doc_ref <> fnd_api.g_miss_char) THEN
2979: UPDATE jtf_ih_activities SET DOC_REF = p_activity_rec.doc_ref

Line 2979: UPDATE jtf_ih_activities SET DOC_REF = p_activity_rec.doc_ref

2975: UPDATE jtf_ih_activities SET DOC_ID = p_activity_rec.doc_id
2976: WHERE activity_id = p_activity_rec.activity_id;
2977: END IF;
2978: IF(p_activity_rec.doc_ref <> fnd_api.g_miss_char) THEN
2979: UPDATE jtf_ih_activities SET DOC_REF = p_activity_rec.doc_ref
2980: WHERE activity_id = p_activity_rec.activity_id;
2981: END IF;
2982: IF(p_activity_rec.media_id <> fnd_api.g_miss_num) THEN
2983: UPDATE jtf_ih_activities SET MEDIA_ID = p_activity_rec.media_id

Line 2983: UPDATE jtf_ih_activities SET MEDIA_ID = p_activity_rec.media_id

2979: UPDATE jtf_ih_activities SET DOC_REF = p_activity_rec.doc_ref
2980: WHERE activity_id = p_activity_rec.activity_id;
2981: END IF;
2982: IF(p_activity_rec.media_id <> fnd_api.g_miss_num) THEN
2983: UPDATE jtf_ih_activities SET MEDIA_ID = p_activity_rec.media_id
2984: WHERE activity_id = p_activity_rec.activity_id;
2985: END IF;
2986: IF(p_activity_rec.action_item_id <> fnd_api.g_miss_num) THEN
2987: UPDATE jtf_ih_activities SET ACTION_ITEM_ID = p_activity_rec.action_item_id

Line 2987: UPDATE jtf_ih_activities SET ACTION_ITEM_ID = p_activity_rec.action_item_id

2983: UPDATE jtf_ih_activities SET MEDIA_ID = p_activity_rec.media_id
2984: WHERE activity_id = p_activity_rec.activity_id;
2985: END IF;
2986: IF(p_activity_rec.action_item_id <> fnd_api.g_miss_num) THEN
2987: UPDATE jtf_ih_activities SET ACTION_ITEM_ID = p_activity_rec.action_item_id
2988: WHERE activity_id = p_activity_rec.activity_id;
2989: END IF;
2990: IF(p_activity_rec.interaction_id <> fnd_api.g_miss_num) THEN
2991: UPDATE jtf_ih_activities SET INTERACTION_ID = p_activity_rec.interaction_id

Line 2991: UPDATE jtf_ih_activities SET INTERACTION_ID = p_activity_rec.interaction_id

2987: UPDATE jtf_ih_activities SET ACTION_ITEM_ID = p_activity_rec.action_item_id
2988: WHERE activity_id = p_activity_rec.activity_id;
2989: END IF;
2990: IF(p_activity_rec.interaction_id <> fnd_api.g_miss_num) THEN
2991: UPDATE jtf_ih_activities SET INTERACTION_ID = p_activity_rec.interaction_id
2992: WHERE activity_id = p_activity_rec.activity_id;
2993: END IF;
2994: IF(p_activity_rec.description <> fnd_api.g_miss_char) THEN
2995: UPDATE jtf_ih_activities SET DESCRIPTION = p_activity_rec.description

Line 2995: UPDATE jtf_ih_activities SET DESCRIPTION = p_activity_rec.description

2991: UPDATE jtf_ih_activities SET INTERACTION_ID = p_activity_rec.interaction_id
2992: WHERE activity_id = p_activity_rec.activity_id;
2993: END IF;
2994: IF(p_activity_rec.description <> fnd_api.g_miss_char) THEN
2995: UPDATE jtf_ih_activities SET DESCRIPTION = p_activity_rec.description
2996: WHERE activity_id = p_activity_rec.activity_id;
2997: END IF;
2998: IF(p_activity_rec.action_id <> fnd_api.g_miss_num) THEN
2999: UPDATE jtf_ih_activities SET ACTION_ID = p_activity_rec.action_id

Line 2999: UPDATE jtf_ih_activities SET ACTION_ID = p_activity_rec.action_id

2995: UPDATE jtf_ih_activities SET DESCRIPTION = p_activity_rec.description
2996: WHERE activity_id = p_activity_rec.activity_id;
2997: END IF;
2998: IF(p_activity_rec.action_id <> fnd_api.g_miss_num) THEN
2999: UPDATE jtf_ih_activities SET ACTION_ID = p_activity_rec.action_id
3000: WHERE activity_id = p_activity_rec.activity_id;
3001: END IF;
3002: IF(p_activity_rec.interaction_action_type <> fnd_api.g_miss_char) THEN
3003: UPDATE jtf_ih_activities SET INTERACTION_ACTION_TYPE = p_activity_rec.interaction_action_type

Line 3003: UPDATE jtf_ih_activities SET INTERACTION_ACTION_TYPE = p_activity_rec.interaction_action_type

2999: UPDATE jtf_ih_activities SET ACTION_ID = p_activity_rec.action_id
3000: WHERE activity_id = p_activity_rec.activity_id;
3001: END IF;
3002: IF(p_activity_rec.interaction_action_type <> fnd_api.g_miss_char) THEN
3003: UPDATE jtf_ih_activities SET INTERACTION_ACTION_TYPE = p_activity_rec.interaction_action_type
3004: WHERE activity_id = p_activity_rec.activity_id;
3005: END IF;
3006: END IF;
3007: END IF;

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

3005: END IF;
3006: END IF;
3007: END IF;
3008: END IF;
3009: --DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_activities in JTF_IH_PUB_PS.Update_Activity');
3010:
3011: -- Standard check of p_commit
3012: IF fnd_api.to_boolean(p_commit) THEN
3013: COMMIT WORK;

Line 3065: SELECT activity_id FROM jtf_ih_activities

3061: l_outcome_id NUMBER := NULL;
3062: l_end_date_time DATE := NULL;
3063: l_action_item_id NUMBER := NULL;
3064: CURSOR l_activity_id_c IS
3065: SELECT activity_id FROM jtf_ih_activities
3066: WHERE interaction_id = p_interaction_id;
3067: BEGIN
3068: SAVEPOINT close_interaction_pub2;
3069:

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 3132: FROM jtf_ih_activities

3128:
3129: FOR v_activity_id_c IN l_activity_id_c LOOP
3130: l_outcome_id := NULL;
3131: SELECT outcome_id into l_outcome_id
3132: FROM jtf_ih_activities
3133: WHERE activity_id = v_activity_id_c.activity_id;
3134: IF (l_outcome_id IS NULL) THEN
3135: x_return_status := fnd_api.g_ret_sts_error;
3136: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

Line 3143: FROM jtf_ih_activities

3139: END IF;
3140:
3141: l_action_item_id := NULL;
3142: SELECT action_item_id into l_action_item_id
3143: FROM jtf_ih_activities
3144: WHERE activity_id = v_activity_id_c.activity_id;
3145: IF (l_action_item_id IS NULL) THEN
3146: x_return_status := fnd_api.g_ret_sts_error;
3147: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),

Line 3153: FROM jtf_ih_activities

3149: RETURN;
3150: END IF;
3151:
3152: SELECT end_date_time into l_end_date_time
3153: FROM jtf_ih_activities
3154: WHERE activity_id = v_activity_id_c.activity_id;
3155: IF(l_end_date_time IS NULL) THEN
3156: l_end_date_time := SYSDATE;
3157: END IF;

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

3154: WHERE activity_id = v_activity_id_c.activity_id;
3155: IF(l_end_date_time IS NULL) THEN
3156: l_end_date_time := SYSDATE;
3157: END IF;
3158: UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time
3159: WHERE interaction_id = p_interaction_id;
3160: END LOOP;
3161: --DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB_PS.Close_Interaction_2');
3162:

Line 3270: FROM jtf_ih_activities

3266: RAISE fnd_api.g_exc_error;
3267: ELSIF(p_end_date_time IS NULL) THEN RETURN;
3268: ELSE
3269: SELECT start_date_time into l_start_date_time
3270: FROM jtf_ih_activities
3271: WHERE activity_id = p_activity_id;
3272: --
3273: -- Validate start_date_time and end_date_time by calling the utility procedure.
3274: --

Line 3286: UPDATE jtf_ih_activities SET END_DATE_TIME = p_end_date_time,

3282: RAISE fnd_api.g_exc_error;
3283: END IF;
3284: --DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB_PS.Update_ActivityDuration');
3285:
3286: UPDATE jtf_ih_activities SET END_DATE_TIME = p_end_date_time,
3287: DURATION = p_duration WHERE activity_id = p_activity_id;
3288:
3289: --DBMS_OUTPUT.PUT_LINE('PAST update end_date_time and duration in JTF_IH_PUB_PS.Update_ActivityDuration');
3290: END IF;