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.AMS_SYNC_CALENDAR_PVT dependencies on FND_API

Line 9: x_remove_only IN VARCHAR2 := FND_API.G_False,

5: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
6:
7: PROCEDURE Sync_Cal_Items
8: (
9: x_remove_only IN VARCHAR2 := FND_API.G_False,
10: x_api_version IN NUMBER := 1.0,
11: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
12: x_commit IN VARCHAR2 := FND_API.G_False,
13: x_return_status OUT NOCOPY VARCHAR2,

Line 11: x_init_msg_list IN VARCHAR2 := FND_API.G_False,

7: PROCEDURE Sync_Cal_Items
8: (
9: x_remove_only IN VARCHAR2 := FND_API.G_False,
10: x_api_version IN NUMBER := 1.0,
11: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
12: x_commit IN VARCHAR2 := FND_API.G_False,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,

Line 12: x_commit IN VARCHAR2 := FND_API.G_False,

8: (
9: x_remove_only IN VARCHAR2 := FND_API.G_False,
10: x_api_version IN NUMBER := 1.0,
11: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
12: x_commit IN VARCHAR2 := FND_API.G_False,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,
16: x_criteria_rec IN cal_criteria_rec

Line 95: IF (x_remove_only = FND_API.G_True) THEN

91: );
92: l_get_delete_offr_id_rec c_get_delete_offr_ids%ROWTYPE;
93:
94: BEGIN
95: IF (x_remove_only = FND_API.G_True) THEN
96: Delete_Cal_Items(x_return_status => x_return_status,
97: x_msg_count => x_msg_count,
98: x_msg_data => x_msg_data,
99: x_criteria_rec => x_criteria_rec

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: OPEN c_get_delete_csch_ids(x_criteria_rec);
104: LOOP
105: FETCH c_get_delete_csch_ids INTO l_get_delete_csch_id_rec;
106: IF (c_get_delete_csch_ids%NOTFOUND) THEN
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: CLOSE c_get_delete_csch_ids;
109: l_get_delete_csch_id_rec := NULL;
110: EXIT;
111: ELSE

Line 126: x_return_status := FND_API.G_RET_STS_SUCCESS;

122: OPEN c_get_delete_eveo_ids(x_criteria_rec);
123: LOOP
124: FETCH c_get_delete_eveo_ids INTO l_get_delete_eveo_id_rec;
125: IF (c_get_delete_eveo_ids%NOTFOUND) THEN
126: x_return_status := FND_API.G_RET_STS_SUCCESS;
127: CLOSE c_get_delete_eveo_ids;
128: l_get_delete_eveo_id_rec := NULL;
129: EXIT;
130: ELSE

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141: OPEN c_get_delete_offr_ids(x_criteria_rec);
142: LOOP
143: FETCH c_get_delete_offr_ids INTO l_get_delete_offr_id_rec;
144: IF (c_get_delete_offr_ids%NOTFOUND) THEN
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146: CLOSE c_get_delete_offr_ids;
147: l_get_delete_offr_id_rec := NULL;
148: EXIT;
149: ELSE

Line 182: x_init_msg_list IN VARCHAR2 := FND_API.G_False,

178: PROCEDURE Create_Cal_Items
179: (
180: x_full_mode IN VARCHAR2 := 'N',
181: x_api_version IN NUMBER := 1.0,
182: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
183: x_commit IN VARCHAR2 := FND_API.G_False,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,

Line 183: x_commit IN VARCHAR2 := FND_API.G_False,

179: (
180: x_full_mode IN VARCHAR2 := 'N',
181: x_api_version IN NUMBER := 1.0,
182: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
183: x_commit IN VARCHAR2 := FND_API.G_False,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: x_criteria_rec IN cal_criteria_rec

Line 331: x_return_status := FND_API.G_RET_STS_SUCCESS;

327: OPEN c_get_cre_csch_items(x_criteria_rec);
328: LOOP
329: FETCH c_get_cre_csch_items INTO l_get_cre_csch_items_rec;
330: IF (c_get_cre_csch_items%NOTFOUND) THEN
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332: CLOSE c_get_cre_csch_items;
333: l_get_cre_csch_items_rec := NULL;
334: EXIT;
335: ELSE

Line 379: x_return_status := FND_API.G_RET_STS_SUCCESS;

375: OPEN c_get_cre_eveo_items(x_criteria_rec);
376: LOOP
377: FETCH c_get_cre_eveo_items INTO l_get_cre_eveo_items_rec;
378: IF (c_get_cre_eveo_items%NOTFOUND) THEN
379: x_return_status := FND_API.G_RET_STS_SUCCESS;
380: CLOSE c_get_cre_eveo_items;
381: l_get_cre_eveo_items_rec := NULL;
382: EXIT;
383: ELSE

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423: OPEN c_get_cre_offr_items(x_criteria_rec);
424: LOOP
425: FETCH c_get_cre_offr_items INTO l_get_cre_offr_items_rec;
426: IF (c_get_cre_offr_items%NOTFOUND) THEN
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428: CLOSE c_get_cre_offr_items;
429: l_get_cre_offr_items_rec := NULL;
430: EXIT;
431: ELSE

Line 485: x_init_msg_list IN VARCHAR2 := FND_API.G_False,

481: PROCEDURE Update_Cal_Items
482: (
483: x_full_mode IN VARCHAR2 := 'N',
484: x_api_version IN NUMBER := 1.0,
485: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
486: x_commit IN VARCHAR2 := FND_API.G_False,
487: x_return_status OUT NOCOPY VARCHAR2,
488: x_msg_count OUT NOCOPY NUMBER,
489: x_msg_data OUT NOCOPY VARCHAR2,

Line 486: x_commit IN VARCHAR2 := FND_API.G_False,

482: (
483: x_full_mode IN VARCHAR2 := 'N',
484: x_api_version IN NUMBER := 1.0,
485: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
486: x_commit IN VARCHAR2 := FND_API.G_False,
487: x_return_status OUT NOCOPY VARCHAR2,
488: x_msg_count OUT NOCOPY NUMBER,
489: x_msg_data OUT NOCOPY VARCHAR2,
490: x_criteria_rec IN cal_criteria_rec

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: OPEN c_get_upd_csch_items(x_criteria_rec);
654: LOOP
655: FETCH c_get_upd_csch_items INTO l_get_upd_csch_items_rec;
656: IF (c_get_upd_csch_items%NOTFOUND) THEN
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: CLOSE c_get_upd_csch_items;
659: l_get_upd_csch_items_rec := NULL;
660: EXIT;
661: ELSE

Line 694: x_return_status := FND_API.G_RET_STS_SUCCESS;

690: OPEN c_get_cal_item_id(l_jtf_upd_itm_rec.SOURCE_ID,l_jtf_upd_itm_rec.CAL_RESOURCE_ID);
691: LOOP
692: FETCH c_get_cal_item_id INTO l_get_cal_item_rec;
693: IF (c_get_cal_item_id%NOTFOUND) THEN
694: x_return_status := FND_API.G_RET_STS_SUCCESS;
695: CLOSE c_get_cal_item_id;
696: l_get_cal_item_rec := NULL;
697: EXIT;
698: ELSE

Line 723: x_return_status := FND_API.G_RET_STS_SUCCESS;

719: OPEN c_get_upd_eveo_items(x_criteria_rec);
720: LOOP
721: FETCH c_get_upd_eveo_items INTO l_get_upd_eveo_items_rec;
722: IF (c_get_upd_eveo_items%NOTFOUND) THEN
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724: CLOSE c_get_upd_eveo_items;
725: l_get_upd_eveo_items_rec := NULL;
726: EXIT;
727: ELSE

Line 755: x_return_status := FND_API.G_RET_STS_SUCCESS;

751: OPEN c_get_e_cal_item_id(l_jtf_upd_itm_rec.SOURCE_ID,l_jtf_upd_itm_rec.CAL_RESOURCE_ID);
752: LOOP
753: FETCH c_get_e_cal_item_id INTO l_get_e_cal_item_rec;
754: IF (c_get_e_cal_item_id%NOTFOUND) THEN
755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756: CLOSE c_get_e_cal_item_id;
757: l_get_e_cal_item_rec := NULL;
758: EXIT;
759: ELSE

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: OPEN c_get_upd_offr_items(x_criteria_rec);
781: LOOP
782: FETCH c_get_upd_offr_items INTO l_get_upd_offr_items_rec;
783: IF (c_get_upd_offr_items%NOTFOUND) THEN
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: CLOSE c_get_upd_offr_items;
786: l_get_upd_offr_items_rec := NULL;
787: EXIT;
788: ELSE

Line 826: x_return_status := FND_API.G_RET_STS_SUCCESS;

822: OPEN c_get_o_cal_item_id(l_jtf_upd_itm_rec.SOURCE_ID,l_jtf_upd_itm_rec.CAL_RESOURCE_ID);
823: LOOP
824: FETCH c_get_o_cal_item_id INTO l_get_o_cal_item_rec;
825: IF (c_get_o_cal_item_id%NOTFOUND) THEN
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827: CLOSE c_get_o_cal_item_id;
828: l_get_o_cal_item_rec := NULL;
829: EXIT;
830: ELSE

Line 856: x_init_msg_list IN VARCHAR2 := FND_API.G_False,

852:
853: PROCEDURE Delete_Cal_Items
854: ( x_full_mode IN VARCHAR2 := 'N',
855: x_api_version IN NUMBER := 1.0,
856: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
857: x_commit IN VARCHAR2 := FND_API.G_False,
858: x_return_status OUT NOCOPY VARCHAR2,
859: x_msg_count OUT NOCOPY NUMBER,
860: x_msg_data OUT NOCOPY VARCHAR2,

Line 857: x_commit IN VARCHAR2 := FND_API.G_False,

853: PROCEDURE Delete_Cal_Items
854: ( x_full_mode IN VARCHAR2 := 'N',
855: x_api_version IN NUMBER := 1.0,
856: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
857: x_commit IN VARCHAR2 := FND_API.G_False,
858: x_return_status OUT NOCOPY VARCHAR2,
859: x_msg_count OUT NOCOPY NUMBER,
860: x_msg_data OUT NOCOPY VARCHAR2,
861: x_criteria_rec IN cal_criteria_rec,

Line 944: x_return_status := FND_API.G_RET_STS_SUCCESS;

940: IF (x_obj_id > 0) THEN
941: OPEN C_GET_DEL_ITEM(x_obj_id);
942: FETCH C_GET_DEL_ITEM INTO l_get_del_item_rec;
943: IF (C_GET_DEL_ITEM%NOTFOUND) THEN
944: x_return_status := FND_API.G_RET_STS_SUCCESS;
945: CLOSE C_GET_DEL_ITEM;
946: l_get_del_item_rec := NULL;
947: ELSE
948: JTF_CAL_ITEMS_PUB.DELETEITEM( p_api_version => x_api_version

Line 964: x_return_status := FND_API.G_RET_STS_SUCCESS;

960: OPEN c_get_del_csch_items(x_criteria_rec);
961: LOOP
962: FETCH c_get_del_csch_items INTO L_GET_DEL_CSCH_ITEMS_REC;
963: IF (c_get_del_csch_items%NOTFOUND) THEN
964: x_return_status := FND_API.G_RET_STS_SUCCESS;
965: CLOSE c_get_del_csch_items;
966: L_GET_DEL_CSCH_ITEMS_REC := NULL;
967: EXIT;
968: ELSE

Line 987: x_return_status := FND_API.G_RET_STS_SUCCESS;

983: OPEN c_get_del_eveo_items(x_criteria_rec);
984: LOOP
985: FETCH c_get_del_eveo_items INTO l_get_del_eveo_items_rec;
986: IF (c_get_del_eveo_items%NOTFOUND) THEN
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988: CLOSE c_get_del_eveo_items;
989: l_get_del_eveo_items_rec := NULL;
990: EXIT;
991: ELSE

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: OPEN c_get_del_offr_items(x_criteria_rec);
1006: LOOP
1007: FETCH c_get_del_offr_items INTO l_get_del_offr_items_rec;
1008: IF (c_get_del_offr_items%NOTFOUND) THEN
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: CLOSE c_get_del_offr_items;
1011: l_get_del_offr_items_rec := NULL;
1012: EXIT;
1013: ELSE