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_RS_GROUP_RELATE_PVT dependencies on JTF_RS_GRP_RELATIONS_S

Line 28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

24: P_COMMIT IN VARCHAR2,
25: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,

Line 71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;

67:
68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;
69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
75:

Line 81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

77:
78: --CHECK THIS CURSOR FOR VALIDITY OF DATES
79:
80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,
81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'
85: FROM jtf_rs_grp_relations rel

Line 82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)

78: --CHECK THIS CURSOR FOR VALIDITY OF DATES
79:
80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,
81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'
85: FROM jtf_rs_grp_relations rel
86: WHERE rel.group_id = l_group_id

Line 107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

103:
104: check_overlap_rec check_overlap_cur%ROWTYPE;
105:
106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'
111: FROM jtf_rs_groups_b grp

Line 108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)

104: check_overlap_rec check_overlap_cur%ROWTYPE;
105:
106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'
111: FROM jtf_rs_groups_b grp
112: WHERE grp.group_id = l_group_id

Line 174: SELECT jtf_rs_grp_relations_s.nextval

170:
171:
172: CURSOR seq_cur
173: IS
174: SELECT jtf_rs_grp_relations_s.nextval
175: FROM dual;
176:
177:
178: CURSOR parent_count_cur(l_group_id number)

Line 809: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

805: (P_API_VERSION IN NUMBER,
806: P_INIT_MSG_LIST IN VARCHAR2,
807: P_COMMIT IN VARCHAR2,
808: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
809: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
810: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
811: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
812: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
813: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

Line 853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;

849:
850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;

Line 915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

911:
912:
913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'

Line 916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

912:
913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'
920: FROM jtf_rs_grp_relations rel

Line 938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

934:
935: check_overlap_rec check_overlap_cur%ROWTYPE;
936:
937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'
942: FROM jtf_rs_groups_b grp

Line 939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)

935: check_overlap_rec check_overlap_cur%ROWTYPE;
936:
937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'
942: FROM jtf_rs_groups_b grp
943: WHERE grp.group_id = l_group_id