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_DSPMGRVALIDATION_GRP dependencies on FND_API

Line 7: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM

3:
4: -----------------------------------------------------------------
5: -- NOTES
6: -- 1. Returns true if the attachment id exists
7: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM
8: -- 3. Return false, if the attachment id does not exist,
9: -- JTF_DSP_ATH_NOT_EXISTS is pushed on the stack
10: ---------------------------------------------------------------------
11: FUNCTION check_attachment_exists(

Line 13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

9: -- JTF_DSP_ATH_NOT_EXISTS is pushed on the stack
10: ---------------------------------------------------------------------
11: FUNCTION check_attachment_exists(
12: p_attachment_id IN NUMBER,
13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
14: RETURN BOOLEAN
15: IS
16:
17: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_exists';

Line 40: ELSIF p_object_version_number = FND_API.G_MISS_NUM THEN

36:
37: IF (p_attachment_id IS NULL) OR (p_object_version_number IS NULL) THEN
38: RAISE l_ath_not_exists_exception;
39:
40: ELSIF p_object_version_number = FND_API.G_MISS_NUM THEN
41: OPEN attachment_cur(p_attachment_id );
42: FETCH attachment_cur INTO l_exists;
43: IF attachment_cur%NOTFOUND THEN
44: CLOSE attachment_cur;

Line 186: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM

182:
183: -----------------------------------------------------------------
184: -- NOTES
185: -- 1. Returns true if the context id with the context type exists
186: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM
187: -- 3. If the context_id is passed does not exist, an exception is
188: -- raised , and JTF_DSP_CONTEXT_NOT_EXISTS is pushed on the
189: -- message stack
190: ---------------------------------------------------------------------

Line 193: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

189: -- message stack
190: ---------------------------------------------------------------------
191: FUNCTION check_context_exists(p_context_id IN NUMBER,
192: p_context_type IN VARCHAR2,
193: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
194: RETURN boolean
195: IS
196: l_api_name CONSTANT VARCHAR2(40) := 'check_context_exists';
197:

Line 217: if p_object_version_number = FND_API.G_MISS_NUM then

213: BEGIN
214:
215: l_context_type := trim(p_context_type);
216:
217: if p_object_version_number = FND_API.G_MISS_NUM then
218: OPEN context_cur(p_context_id ,l_context_type);
219: FETCH context_cur INTO l_exists;
220: IF context_cur%NOTFOUND
221: THEN

Line 377: p_context_id IN NUMBER := FND_API.G_MISS_NUM)

373: -- message stack
374: ---------------------------------------------------------------------
375: FUNCTION check_context_accessname(p_context_accessname IN VARCHAR2,
376: p_context_type IN VARCHAR2,
377: p_context_id IN NUMBER := FND_API.G_MISS_NUM)
378: RETURN boolean
379: IS
380: l_api_name CONSTANT VARCHAR2(40) := 'check_context_accessname';
381: l_context_accessname VARCHAR2(40);

Line 406: if p_context_id = FND_API.G_MISS_NUM or p_context_id is null then

402:
403: l_context_accessname := trim(p_context_accessname);
404: l_context_type := trim(p_context_type);
405:
406: if p_context_id = FND_API.G_MISS_NUM or p_context_id is null then
407: OPEN context_accessname_cur(l_context_accessname ,l_context_type);
408: FETCH context_accessname_cur INTO l_exists;
409: IF context_accessname_cur%FOUND
410: THEN

Line 722: p_applicable_to IN VARCHAR2 := FND_API.g_miss_char)

718: ---------------------------------------------------------------------
719: FUNCTION check_deliverable_type_exists(
720: p_deliverable_id IN NUMBER,
721: p_item_type IN VARCHAR2,
722: p_applicable_to IN VARCHAR2 := FND_API.g_miss_char)
723: RETURN BOOLEAN
724: IS
725: l_api_name CONSTANT VARCHAR2(40) := 'check_deliverable_type_exists';
726: l_exists NUMBER;

Line 749: if p_applicable_to is null or p_applicable_to = FND_API.g_miss_char then

745: BEGIN
746:
747: l_item_type := trim(p_item_type);
748:
749: if p_applicable_to is null or p_applicable_to = FND_API.g_miss_char then
750: OPEN deliverable_type_cur(p_deliverable_id,l_item_type);
751: FETCH deliverable_type_cur INTO l_exists;
752: IF deliverable_type_cur%FOUND THEN
753: l_return_status := true;

Line 797: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

793: ---------------------------------------------------------------------
794:
795: FUNCTION check_deliverable_exists(
796: p_deliverable_id IN NUMBER,
797: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
798: RETURN boolean
799: IS
800: l_api_name CONSTANT VARCHAR2(40) := 'check_deliverable_exists';
801:

Line 823: ELSIF p_object_version_number = FND_API.G_MISS_NUM then

819:
820: IF (p_deliverable_id IS NULL) OR (p_object_version_number IS NULL) THEN
821: RAISE l_dlv_not_exists_exception;
822:
823: ELSIF p_object_version_number = FND_API.G_MISS_NUM then
824: OPEN deliverable_cur(p_deliverable_id );
825: FETCH deliverable_cur INTO l_exists;
826: IF deliverable_cur%NOTFOUND THEN
827: CLOSE deliverable_cur;

Line 877: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

873: -- message JTF_DSP_LGL_CTNT_ID_NOT_EXISTS is pushed on the stack
874: ---------------------------------------------------------------------
875:
876: FUNCTION check_lgl_ctnt_id_exists(p_lgl_ctnt_id IN NUMBER,
877: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
878: RETURN boolean
879: IS
880: l_api_name CONSTANT VARCHAR2(40) := 'check_lgl_ctnt_id_exists';
881:

Line 898: if p_object_version_number = FND_API.G_MISS_NUM then

894: l_exists NUMBER;
895: l_return_status boolean := false;
896:
897: BEGIN
898: if p_object_version_number = FND_API.G_MISS_NUM then
899: OPEN lgl_ctnt_cur(p_lgl_ctnt_id );
900: FETCH lgl_ctnt_cur INTO l_exists;
901: IF lgl_ctnt_cur%NOTFOUND
902: THEN

Line 1028: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

1024: ---------------------------------------------------------------------
1025:
1026: FUNCTION check_msite_exists(
1027: p_msite_id IN NUMBER,
1028: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
1029: RETURN boolean
1030: IS
1031: l_api_name CONSTANT VARCHAR2(40) := 'check_msite_exists';
1032: l_return_status boolean := false;

Line 1060: elsif p_object_version_number = FND_API.G_MISS_NUM then

1056:
1057: if (p_msite_id IS NULL) OR (p_object_version_number IS NULL) THEN
1058: RAISE l_msite_not_exists_exception;
1059:
1060: elsif p_object_version_number = FND_API.G_MISS_NUM then
1061: OPEN msite_cur(p_msite_id );
1062: FETCH msite_cur INTO l_exists;
1063: IF msite_cur%NOTFOUND THEN
1064: CLOSE msite_cur;

Line 1556: AND (p_attachment_id <> FND_API.G_MISS_NUM)

1552:
1553: BEGIN
1554:
1555: IF (p_attachment_id IS NOT NULL)
1556: AND (p_attachment_id <> FND_API.G_MISS_NUM)
1557: AND (p_deliverable_id IS NOT NULL)
1558: AND (p_deliverable_id <> FND_API.G_MISS_NUM) THEN
1559: OPEN attachment_cur(p_attachment_id, p_deliverable_id);
1560:

Line 1558: AND (p_deliverable_id <> FND_API.G_MISS_NUM) THEN

1554:
1555: IF (p_attachment_id IS NOT NULL)
1556: AND (p_attachment_id <> FND_API.G_MISS_NUM)
1557: AND (p_deliverable_id IS NOT NULL)
1558: AND (p_deliverable_id <> FND_API.G_MISS_NUM) THEN
1559: OPEN attachment_cur(p_attachment_id, p_deliverable_id);
1560:
1561: FETCH attachment_cur INTO l_exists;
1562: IF attachment_cur%FOUND THEN