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_USR_HKS

Line 2131: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'B', 'C') THEN

2127: l_soft_closed_perf := 'N';
2128:
2129: -- Preprocessing Call
2130: l_media_rec := p_media_rec;
2131: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'B', 'C') THEN
2132: JTF_IH_PUB_CUHK.create_mediaitem_pre(
2133: p_media_rec=>l_media_rec,
2134: x_data=>l_data,
2135: x_count=>l_count,

Line 2144: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'B', 'V') THEN

2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2141: END IF;
2142: END IF;
2143:
2144: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'B', 'V') THEN
2145: JTF_IH_PUB_VUHK.create_mediaitem_pre(
2146: p_media_rec=>l_media_rec,
2147: x_data=>l_data,
2148: x_count=>l_count,

Line 2353: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'A', 'V') THEN

2349: x_media_id := l_media_rec.media_id;
2350:
2351: -- Post processing Call
2352:
2353: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'A', 'V') THEN
2354: JTF_IH_PUB_VUHK.create_mediaitem_post(
2355: p_media_rec=>l_media_rec,
2356: x_data=>l_data,
2357: x_count=>l_count,

Line 2366: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'A', 'C') THEN

2362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2363: END IF;
2364: END IF;
2365:
2366: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIAITEM', 'A', 'C') THEN
2367: JTF_IH_PUB_CUHK.create_mediaitem_post(
2368: p_media_rec=>l_media_rec,
2369: x_data=>l_data,
2370: x_count=>l_count,

Line 2476: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFEYCYCLE', 'B', 'C') THEN

2472: l_active_perf := 'N';
2473:
2474: -- Preprocessing Call
2475: l_media_lc_rec := p_media_lc_rec;
2476: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFEYCYCLE', 'B', 'C') THEN
2477: JTF_IH_PUB_CUHK.create_medialifecycle_pre(
2478: p_media_lc_rec=>l_media_lc_rec,
2479: x_data=>l_data,
2480: x_count=>l_count,

Line 2489: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFECYCLE', 'B', 'V') THEN

2485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2486: END IF;
2487: END IF;
2488:
2489: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFECYCLE', 'B', 'V') THEN
2490: JTF_IH_PUB_VUHK.create_medialifecycle_pre(
2491: p_media_lc_rec=>l_media_lc_rec,
2492: x_data=>l_data,
2493: x_count=>l_count,

Line 2659: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFECYCLE', 'A', 'V') THEN

2655: -- DBMS_OUTPUT.PUT_LINE('PAST insert data in JTF_IH_PUB.Create_MediaLifecycle');
2656:
2657: -- Post processing Call
2658:
2659: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFECYCLE', 'A', 'V') THEN
2660: JTF_IH_PUB_VUHK.create_medialifecycle_post(
2661: p_media_lc_rec=>l_media_lc_rec,
2662: x_data=>l_data,
2663: x_count=>l_count,

Line 2672: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFECYCLE', 'A', 'C') THEN

2668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2669: END IF;
2670: END IF;
2671:
2672: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_MEDIALIFECYCLE', 'A', 'C') THEN
2673: JTF_IH_PUB_CUHK.create_medialifecycle_post(
2674: p_media_lc_rec=>l_media_lc_rec,
2675: x_data=>l_data,
2676: x_count=>l_count,

Line 2807: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'B', 'C') THEN

2803: FND_MSG_PUB.Add;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END IF;
2806:
2807: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'B', 'C') THEN
2808: JTF_IH_PUB_CUHK.create_interaction_pre(
2809: --p_interaction_rec=>l_interaction_rec,
2810: p_interaction_rec=>l_int_val_rec,
2811: --p_activities=>l_activities_hk,

Line 2823: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'B', 'V') THEN

2819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2820: END IF;
2821: END IF;
2822:
2823: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'B', 'V') THEN
2824: JTF_IH_PUB_VUHK.create_interaction_pre(
2825: --p_interaction_rec=>l_interaction_rec,
2826: p_interaction_rec=>l_int_val_rec,
2827: --p_activities=>l_activities_hk,

Line 3278: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'A', 'V') THEN

3274: --x_interaction_id := l_int_val_rec.interaction_id;
3275:
3276: -- Post processing Call
3277:
3278: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'A', 'V') THEN
3279: JTF_IH_PUB_VUHK.create_interaction_post(
3280: --p_interaction_rec=>l_interaction_rec,
3281: p_interaction_rec=>l_int_val_rec,
3282: --p_activities=>l_activities_hk,

Line 3294: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'A', 'C') THEN

3290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3291: END IF;
3292: END IF;
3293:
3294: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'A', 'C') THEN
3295: JTF_IH_PUB_CUHK.create_interaction_post(
3296: --p_interaction_rec=>l_interaction_rec,
3297: p_interaction_rec=>l_int_val_rec,
3298: --p_activities=>l_activities_hk,

Line 3401: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'C') THEN

3397: l_result_id := p_result_id;
3398: l_reason_id := p_reason_id;
3399: l_script_id := p_script_id;
3400: l_media_id := p_media_id;
3401: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'C') THEN
3402: JTF_IH_PUB_CUHK.get_interactionactcnt_pre(
3403: p_outcome_id=>l_outcome_id,
3404: p_result_id=>l_result_id,
3405: p_reason_id=>l_reason_id,

Line 3418: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'V') THEN

3414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3415: END IF;
3416: END IF;
3417:
3418: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'V') THEN
3419: JTF_IH_PUB_VUHK.get_interactionactcnt_pre(
3420: p_outcome_id=>l_outcome_id,
3421: p_result_id=>l_result_id,
3422: p_reason_id=>l_reason_id,

Line 3661: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'V') THEN

3657: END IF;
3658:
3659:
3660: -- Post processing Call
3661: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'V') THEN
3662: JTF_IH_PUB_VUHK.get_interactionactcnt_post(
3663: p_outcome_id=>l_outcome_id,
3664: p_result_id=>l_result_id,
3665: p_reason_id=>l_reason_id,

Line 3678: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'C') THEN

3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: END IF;
3676: END IF;
3677:
3678: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONACTIVITYCOUNT', 'B', 'C') THEN
3679: JTF_IH_PUB_CUHK.get_interactionactcnt_post(
3680: p_outcome_id=>l_outcome_id,
3681: p_result_id=>l_result_id,
3682: p_reason_id=>l_reason_id,

Line 3781: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'C') THEN

3777: -- Preprocessing Call
3778: l_outcome_id := p_outcome_id;
3779: l_result_id := p_result_id;
3780: l_reason_id := p_reason_id;
3781: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'C') THEN
3782: JTF_IH_PUB_CUHK.get_interactioncount_pre(
3783: p_outcome_id=>l_outcome_id,
3784: p_result_id=>l_result_id,
3785: p_reason_id=>l_reason_id,

Line 3796: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'V') THEN

3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: END IF;
3794: END IF;
3795:
3796: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'V') THEN
3797: JTF_IH_PUB_VUHK.get_interactioncount_pre(
3798: p_outcome_id=>l_outcome_id,
3799: p_result_id=>l_result_id,
3800: p_reason_id=>l_reason_id,

Line 3869: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'V') THEN

3865: -- and (p_attribute_category = p_attribute_category) -- or (p_attribute_category is NULL and p_attribute_category is NULL))
3866: ;
3867: x_interaction_count := interactionCount;
3868: -- Post processing Call
3869: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'V') THEN
3870: JTF_IH_PUB_VUHK.get_interactioncount_post(
3871: p_outcome_id=>l_outcome_id,
3872: p_result_id=>l_result_id,
3873: p_reason_id=>l_reason_id,

Line 3884: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'C') THEN

3880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3881: END IF;
3882: END IF;
3883:
3884: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'GET_INTERACTIONCOUNT', 'B', 'C') THEN
3885: JTF_IH_PUB_CUHK.get_interactioncount_post(
3886: p_outcome_id=>l_outcome_id,
3887: p_result_id=>l_result_id,
3888: p_reason_id=>l_reason_id,

Line 3988: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'B', 'C') THEN

3984: SAVEPOINT open_interaction_pub;
3985:
3986: -- Preprocessing Call
3987: l_interaction_rec := p_interaction_rec;
3988: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'B', 'C') THEN
3989: JTF_IH_PUB_CUHK.open_interaction_pre(p_interaction_rec=>l_interaction_rec,
3990: x_data=>l_data,
3991: x_count=>l_count,
3992: x_return_code=>l_return_code);

Line 4000: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'B', 'V') THEN

3996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3997: END IF;
3998: END IF;
3999:
4000: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'B', 'V') THEN
4001: JTF_IH_PUB_VUHK.open_interaction_pre(p_interaction_rec=>l_interaction_rec,
4002: x_data=>l_data,
4003: x_count=>l_count,
4004: x_return_code=>l_return_code);

Line 4306: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'A', 'V') THEN

4302: x_interaction_id := l_interaction_rec.interaction_id;
4303:
4304: -- Post processing Call
4305:
4306: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'A', 'V') THEN
4307: JTF_IH_PUB_VUHK.open_interaction_post(p_interaction_rec=>l_interaction_rec,
4308: x_data=>l_data,
4309: x_count=>l_count,
4310: x_return_code=>l_return_code);

Line 4318: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'A', 'C') THEN

4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4315: END IF;
4316: END IF;
4317:
4318: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_INTERACTION', 'A', 'C') THEN
4319: JTF_IH_PUB_CUHK.open_interaction_post(p_interaction_rec=>l_interaction_rec,
4320: x_data=>l_data,
4321: x_count=>l_count,
4322: x_return_code=>l_return_code);

Line 4471: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'B', 'C') THEN

4467: SAVEPOINT update_interaction_pub;
4468:
4469: -- Preprocessing Call
4470: --l_interaction_rec_hk := p_interaction_rec;
4471: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'B', 'C') THEN
4472: JTF_IH_PUB_CUHK.update_interaction_pre(
4473: --p_interaction_rec=>l_interaction_rec_hk,
4474: p_interaction_rec=>l_int_rec,
4475: x_data=>l_data,

Line 4485: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'B', 'V') THEN

4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: END IF;
4483: END IF;
4484:
4485: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'B', 'V') THEN
4486: JTF_IH_PUB_VUHK.update_interaction_pre(
4487: --p_interaction_rec=>l_interaction_rec_hk,
4488: p_interaction_rec=>l_int_rec,
4489: x_data=>l_data,

Line 5220: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'A', 'V') THEN

5216: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB.Update_Interaction');
5217:
5218: -- Post processing Call
5219:
5220: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'A', 'V') THEN
5221: JTF_IH_PUB_VUHK.update_interaction_post(
5222: --p_interaction_rec=>l_interaction_rec_hk,
5223: p_interaction_rec=>l_int_rec,
5224: x_data=>l_data,

Line 5234: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'A', 'C') THEN

5230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5231: END IF;
5232: END IF;
5233:
5234: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'A', 'C') THEN
5235: JTF_IH_PUB_CUHK.update_interaction_post(
5236: --p_interaction_rec=>l_interaction_rec_hk,
5237: p_interaction_rec=>l_int_rec,
5238: x_data=>l_data,

Line 5362: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'C') THEN

5358:
5359: -- Preprocessing Call
5360: l_interaction_rec := p_interaction_rec;
5361:
5362: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'C') THEN
5363: JTF_IH_PUB_CUHK.close_interaction_pre(p_interaction_rec=>l_interaction_rec,
5364: x_data=>l_data,
5365: x_count=>l_count_hk,
5366: x_return_code=>l_return_code);

Line 5374: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'V') THEN

5370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5371: END IF;
5372: END IF;
5373:
5374: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'V') THEN
5375: JTF_IH_PUB_VUHK.close_interaction_pre(p_interaction_rec=>l_interaction_rec,
5376: x_data=>l_data,
5377: x_count=>l_count_hk,
5378: x_return_code=>l_return_code);

Line 5686: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'V') THEN

5682: WHERE interaction_id = p_interaction_rec.interaction_id;
5683:
5684: -- Post processing Call
5685:
5686: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'V') THEN
5687: JTF_IH_PUB_VUHK.close_interaction_post(p_interaction_rec=>l_interaction_rec,
5688: x_data=>l_data,
5689: x_count=>l_count_hk,
5690: x_return_code=>l_return_code);

Line 5698: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'C') THEN

5694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5695: END IF;
5696: END IF;
5697:
5698: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'C') THEN
5699: JTF_IH_PUB_CUHK.close_interaction_post(p_interaction_rec=>l_interaction_rec,
5700: x_data=>l_data,
5701: x_count=>l_count_hk,
5702: x_return_code=>l_return_code);

Line 5807: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'B', 'C') THEN

5803: -- Standard start of API savepoint
5804: SAVEPOINT add_activity_pub;
5805: -- Preprocessing Call
5806: l_activity_rec := p_activity_rec;
5807: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'B', 'C') THEN
5808: JTF_IH_PUB_CUHK.add_activity_pre(p_activity_rec=>l_activity_rec,
5809: x_data=>l_data,
5810: x_count=>l_count,
5811: x_return_code=>l_return_code);

Line 5819: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'B', 'V') THEN

5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5816: END IF;
5817: END IF;
5818:
5819: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'B', 'V') THEN
5820: JTF_IH_PUB_VUHK.add_activity_pre(p_activity_rec=>l_activity_rec,
5821: x_data=>l_data,
5822: x_count=>l_count,
5823: x_return_code=>l_return_code);

Line 6083: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'A', 'V') THEN

6079: x_activity_id := l_activity_rec.activity_id;
6080:
6081: -- Post processing Call
6082:
6083: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'A', 'V') THEN
6084: JTF_IH_PUB_VUHK.add_activity_post(p_activity_rec=>l_activity_rec,
6085: x_data=>l_data,
6086: x_count=>l_count,
6087: x_return_code=>l_return_code);

Line 6095: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'A', 'C') THEN

6091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6092: END IF;
6093: END IF;
6094:
6095: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'A', 'C') THEN
6096: JTF_IH_PUB_CUHK.add_activity_post(p_activity_rec=>l_activity_rec,
6097: x_data=>l_data,
6098: x_count=>l_count,
6099: x_return_code=>l_return_code);

Line 6256: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'B', 'C') THEN

6252: SAVEPOINT update_activity_pub;
6253:
6254: -- Preprocessing Call
6255: l_activity_rec := p_activity_rec;
6256: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'B', 'C') THEN
6257: JTF_IH_PUB_CUHK.update_activity_pre(p_activity_rec=>l_activity_rec,
6258: x_data=>l_data,
6259: x_count=>l_count_hk,
6260: x_return_code=>l_return_code);

Line 6268: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'B', 'V') THEN

6264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6265: END IF;
6266: END IF;
6267:
6268: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'B', 'V') THEN
6269: JTF_IH_PUB_VUHK.update_activity_pre(p_activity_rec=>l_activity_rec,
6270: x_data=>l_data,
6271: x_count=>l_count,
6272: x_return_code=>l_return_code);

Line 6832: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'A', 'V') THEN

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
6833: JTF_IH_PUB_VUHK.update_activity_post(p_activity_rec=>l_activity_rec,
6834: x_data=>l_data,
6835: x_count=>l_count_hk,
6836: x_return_code=>l_return_code);

Line 6844: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'A', 'C') THEN

6840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6841: END IF;
6842: END IF;
6843:
6844: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'A', 'C') THEN
6845: JTF_IH_PUB_CUHK.update_activity_post(p_activity_rec=>l_activity_rec,
6846: x_data=>l_data,
6847: x_count=>l_count_hk,
6848: x_return_code=>l_return_code);

Line 6962: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'C') THEN

6958: l_active_perf := 'N';
6959:
6960: -- Preprocessing Call
6961: l_interaction_id := p_interaction_id;
6962: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'C') THEN
6963: JTF_IH_PUB_CUHK.close_interaction_pre(p_interaction_id=>l_interaction_id,
6964: x_data=>l_data,
6965: x_count=>l_count_hk,
6966: x_return_code=>l_return_code);

Line 6974: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'V') THEN

6970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6971: END IF;
6972: END IF;
6973:
6974: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'B', 'V') THEN
6975: JTF_IH_PUB_VUHK.close_interaction_pre(p_interaction_id=>l_interaction_id,
6976: x_data=>l_data,
6977: x_count=>l_count_hk,
6978: x_return_code=>l_return_code);

Line 7174: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'V') THEN

7170: WHERE interaction_id = p_interaction_id;
7171:
7172: -- Post processing Call
7173:
7174: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'V') THEN
7175: JTF_IH_PUB_VUHK.close_interaction_post(p_interaction_id=>l_interaction_id,
7176: x_data=>l_data,
7177: x_count=>l_count_hk,
7178: x_return_code=>l_return_code);

Line 7186: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'C') THEN

7182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7183: END IF;
7184: END IF;
7185:
7186: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_INTERACTION', 'A', 'C') THEN
7187: JTF_IH_PUB_CUHK.close_interaction_post(p_interaction_id=>l_interaction_id,
7188: x_data=>l_data,
7189: x_count=>l_count_hk,
7190: x_return_code=>l_return_code);

Line 7309: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'B', 'C') THEN

7305: l_duration := p_duration;
7306:
7307:
7308: -- Preprocessing Call
7309: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'B', 'C') THEN
7310: JTF_IH_PUB_CUHK.update_actduration_pre(
7311: p_activity_id=>l_activity_id,
7312: p_end_date_time=>l_end_date_time,
7313: p_duration=>l_duration,

Line 7324: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'B', 'V') THEN

7320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7321: END IF;
7322: END IF;
7323:
7324: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'B', 'V') THEN
7325: JTF_IH_PUB_VUHK.update_actduration_pre(
7326: p_activity_id=>l_activity_id,
7327: p_end_date_time=>l_end_date_time,
7328: p_duration=>l_duration,

Line 7437: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'A', 'V') THEN

7433: -- DBMS_OUTPUT.PUT_LINE('PAST update end_date_time and duration in JTF_IH_PUB.Update_ActivityDuration');
7434:
7435: -- Post processing Call
7436:
7437: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'A', 'V') THEN
7438: JTF_IH_PUB_VUHK.update_actduration_post(
7439: p_activity_id=>l_activity_id,
7440: p_end_date_time=>l_end_date_time,
7441: p_duration=>l_duration,

Line 7452: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'A', 'C') THEN

7448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7449: END IF;
7450: END IF;
7451:
7452: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'A', 'C') THEN
7453: JTF_IH_PUB_CUHK.update_actduration_post(
7454: p_activity_id=>l_activity_id,
7455: p_end_date_time=>l_end_date_time,
7456: p_duration=>l_duration,

Line 7571: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'B', 'C') THEN

7567: SAVEPOINT open_mediaitem_pub;
7568:
7569: -- Preprocessing Call
7570: l_media_rec := p_media_rec;
7571: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'B', 'C') THEN
7572: JTF_IH_PUB_CUHK.open_mediaitem_pre(p_media_rec=>l_media_rec,
7573: x_data=>l_data,
7574: x_count=>l_count,
7575: x_return_code=>l_return_code);

Line 7583: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'B', 'V') THEN

7579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7580: END IF;
7581: END IF;
7582:
7583: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'B', 'V') THEN
7584: JTF_IH_PUB_VUHK.open_mediaitem_pre(p_media_rec=>l_media_rec,
7585: x_data=>l_data,
7586: x_count=>l_count,
7587: x_return_code=>l_return_code);

Line 7790: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'A', 'V') THEN

7786: x_media_id := l_media_rec.media_id;
7787:
7788: -- Post processing Call
7789:
7790: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'A', 'V') THEN
7791: JTF_IH_PUB_VUHK.open_mediaitem_post(p_media_rec=>l_media_rec,
7792: x_data=>l_data,
7793: x_count=>l_count,
7794: x_return_code=>l_return_code);

Line 7802: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'A', 'C') THEN

7798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7799: END IF;
7800: END IF;
7801:
7802: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'OPEN_MEDIAITEM', 'A', 'C') THEN
7803: JTF_IH_PUB_CUHK.open_mediaitem_post(p_media_rec=>l_media_rec,
7804: x_data=>l_data,
7805: x_count=>l_count,
7806: x_return_code=>l_return_code);

Line 7931: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'B', 'C') THEN

7927: SAVEPOINT update_mediaitem_pub;
7928:
7929: -- Preprocessing Call
7930: --l_media_rec_hk := p_media_rec;
7931: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'B', 'C') THEN
7932: JTF_IH_PUB_CUHK.update_mediaitem_pre(
7933: --p_media_rec=>l_media_rec_hk,
7934: p_media_rec=>l_media_rec,
7935: x_data=>l_data,

Line 7945: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'B', 'V') THEN

7941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7942: END IF;
7943: END IF;
7944:
7945: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'B', 'V') THEN
7946: JTF_IH_PUB_VUHK.update_mediaitem_pre(
7947: --p_media_rec=>l_media_rec_hk,
7948: p_media_rec=>l_media_rec,
7949: x_data=>l_data,

Line 8302: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'A', 'V') THEN

8298: --
8299:
8300: -- Post processing Call
8301:
8302: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'A', 'V') THEN
8303: JTF_IH_PUB_VUHK.update_mediaitem_post(
8304: --p_media_rec=>l_media_rec_hk,
8305: p_media_rec=>l_media_rec,
8306: x_data=>l_data,

Line 8316: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'A', 'C') THEN

8312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8313: END IF;
8314: END IF;
8315:
8316: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'A', 'C') THEN
8317: JTF_IH_PUB_CUHK.update_mediaitem_post(
8318: --p_media_rec=>l_media_rec_hk,
8319: p_media_rec=>l_media_rec,
8320: x_data=>l_data,

Line 8447: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'B', 'C') THEN

8443: l_soft_closed_perf := 'Y';
8444:
8445: -- Preprocessing Call
8446: l_media_rec := p_media_rec;
8447: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'B', 'C') THEN
8448: JTF_IH_PUB_CUHK.close_mediaitem_pre(
8449: p_media_rec=>l_media_rec,
8450: x_data=>l_data,
8451: x_count=>l_count_hk,

Line 8460: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'B', 'V') THEN

8456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8457: END IF;
8458: END IF;
8459:
8460: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'B', 'V') THEN
8461: JTF_IH_PUB_VUHK.close_mediaitem_pre(
8462: p_media_rec=>l_media_rec,
8463: x_data=>l_data,
8464: x_count=>l_count_hk,

Line 8602: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'A', 'V') THEN

8598: WHERE milcs_id = cur_Milcs.milcs_id;
8599: END LOOP;
8600: -- Post processing Call
8601:
8602: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'A', 'V') THEN
8603: JTF_IH_PUB_VUHK.close_mediaitem_post(p_media_rec=>l_media_rec,
8604: x_data=>l_data,
8605: x_count=>l_count_hk,
8606: x_return_code=>l_return_code);

Line 8614: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'A', 'C') THEN

8610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8611: END IF;
8612: END IF;
8613:
8614: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CLOSE_MEDIAITEM', 'A', 'C') THEN
8615: JTF_IH_PUB_CUHK.close_mediaitem_post(p_media_rec=>l_media_rec,
8616: x_data=>l_data,
8617: x_count=>l_count_hk,
8618: x_return_code=>l_return_code);

Line 8727: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'B', 'C') THEN

8723: SAVEPOINT open_medialifecycle_pub;
8724:
8725: -- Preprocessing Call
8726: --l_media_lc_rec_hk := p_media_lc_rec;
8727: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'B', 'C') THEN
8728: JTF_IH_PUB_CUHK.add_medialifecycle_pre(
8729: --p_media_lc_rec=>l_media_lc_rec_hk,
8730: p_media_lc_rec=>l_media_lc_rec,
8731: x_data=>l_data,

Line 8741: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'B', 'V') THEN

8737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8738: END IF;
8739: END IF;
8740:
8741: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'B', 'V') THEN
8742: JTF_IH_PUB_VUHK.add_medialifecycle_pre(
8743: --p_media_lc_rec=>l_media_lc_rec_hk,
8744: p_media_lc_rec=>l_media_lc_rec,
8745: x_data=>l_data,

Line 8929: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'A', 'V') THEN

8925: x_milcs_id := l_media_lc_rec.milcs_id;
8926:
8927: -- Post processing Call
8928:
8929: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'A', 'V') THEN
8930: JTF_IH_PUB_VUHK.add_medialifecycle_post(
8931: --p_media_lc_rec=>l_media_lc_rec_hk,
8932: p_media_lc_rec=>l_media_lc_rec,
8933: x_data=>l_data,

Line 8943: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'A', 'C') THEN

8939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8940: END IF;
8941: END IF;
8942:
8943: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_MEDIALIFECYCLE', 'A', 'C') THEN
8944: JTF_IH_PUB_CUHK.add_medialifecycle_post(
8945: --p_media_lc_rec=>l_media_lc_rec_hk,
8946: p_media_lc_rec=>l_media_lc_rec,
8947: x_data=>l_data,

Line 9073: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'B', 'C') THEN

9069: SAVEPOINT update_medialifecycle_pub;
9070:
9071: -- Preprocessing Call
9072: --l_media_lc_rec_hk := p_media_lc_rec;
9073: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'B', 'C') THEN
9074: JTF_IH_PUB_CUHK.update_medialifecycle_pre(
9075: --p_media_lc_rec=>l_media_lc_rec_hk,
9076: p_media_lc_rec=>l_media_lc_rec,
9077: x_data=>l_data,

Line 9087: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'B', 'V') THEN

9083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9084: END IF;
9085: END IF;
9086:
9087: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'B', 'V') THEN
9088: JTF_IH_PUB_VUHK.update_medialifecycle_pre(
9089: --p_media_lc_rec=>l_media_lc_rec_hk,
9090: p_media_lc_rec=>l_media_lc_rec,
9091: x_data=>l_data,

Line 9357: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'A', 'V') THEN

9353: END IF;
9354:
9355: -- Post processing Call
9356:
9357: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'A', 'V') THEN
9358: JTF_IH_PUB_VUHK.update_medialifecycle_post(
9359: --p_media_lc_rec=>l_media_lc_rec_hk,
9360: p_media_lc_rec=>l_media_lc_rec,
9361: x_data=>l_data,

Line 9371: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'A', 'C') THEN

9367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9368: END IF;
9369: END IF;
9370:
9371: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'A', 'C') THEN
9372: JTF_IH_PUB_CUHK.update_medialifecycle_post(
9373: --p_media_lc_rec=>l_media_lc_rec_hk,
9374: p_media_lc_rec=>l_media_lc_rec,
9375: x_data=>l_data,