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_PREFAB_POLICY_PUB dependencies on JTF_PREFAB_UR_POLICIES

Line 433: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,

429: p_api_version IN NUMBER,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432:
433: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
434: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
435: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
436:
437: p_object_version_number OUT NOCOPY jtf_prefab_ur_policies.object_version_number%TYPE,

Line 434: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,

430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432:
433: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
434: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
435: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
436:
437: p_object_version_number OUT NOCOPY jtf_prefab_ur_policies.object_version_number%TYPE,
438:

Line 435: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,

431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432:
433: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
434: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
435: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
436:
437: p_object_version_number OUT NOCOPY jtf_prefab_ur_policies.object_version_number%TYPE,
438:
439: x_return_status OUT NOCOPY VARCHAR2,

Line 437: p_object_version_number OUT NOCOPY jtf_prefab_ur_policies.object_version_number%TYPE,

433: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
434: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
435: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
436:
437: p_object_version_number OUT NOCOPY jtf_prefab_ur_policies.object_version_number%TYPE,
438:
439: x_return_status OUT NOCOPY VARCHAR2,
440: x_msg_count OUT NOCOPY NUMBER,
441: x_msg_data OUT NOCOPY VARCHAR2

Line 473: INSERT INTO jtf_prefab_ur_policies (ur_policy_id,

469: -- real logic --
470: ----------------
471: p_object_version_number := 1;
472:
473: INSERT INTO jtf_prefab_ur_policies (ur_policy_id,
474: object_version_number,
475: created_by,
476: creation_date,
477: last_updated_by,

Line 484: VALUES (jtf_prefab_ur_policies_s.NEXTVAL,

480: -- security_group_id,
481: policy_id,
482: userresp_id,
483: userresp_type)
484: VALUES (jtf_prefab_ur_policies_s.NEXTVAL,
485: p_object_version_number,
486: G_USER_ID,
487: SYSDATE,
488: G_USER_ID,

Line 545: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,

541: p_api_version IN NUMBER,
542: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
543: p_commit IN VARCHAR2 := FND_API.G_FALSE,
544:
545: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
546: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
547: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
548:
549: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,

Line 546: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,

542: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
543: p_commit IN VARCHAR2 := FND_API.G_FALSE,
544:
545: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
546: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
547: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
548:
549: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
550:

Line 547: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,

543: p_commit IN VARCHAR2 := FND_API.G_FALSE,
544:
545: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
546: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
547: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
548:
549: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
550:
551: x_return_status OUT NOCOPY VARCHAR2,

Line 549: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,

545: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
546: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
547: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
548:
549: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
550:
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2

Line 583: DELETE FROM jtf_prefab_ur_policies

579:
580: -- real logic --
581: ----------------
582:
583: DELETE FROM jtf_prefab_ur_policies
584: WHERE policy_id = p_policy_id
585: AND userresp_id = p_userresp_id
586: AND userresp_type = p_userresp_type;
587:

Line 637: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,

633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636:
637: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
638:
639: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
640:
641: x_return_status OUT NOCOPY VARCHAR2,

Line 639: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,

635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636:
637: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
638:
639: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
640:
641: x_return_status OUT NOCOPY VARCHAR2,
642: x_msg_count OUT NOCOPY NUMBER,
643: x_msg_data OUT NOCOPY VARCHAR2

Line 673: DELETE FROM jtf_prefab_ur_policies

669:
670: -- real logic --
671: ----------------
672:
673: DELETE FROM jtf_prefab_ur_policies
674: WHERE policy_id = p_policy_id;
675:
676: -----------------------
677: -- end of real logic --