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.OKL_PA_DATA_INTEGRITY dependencies on OKL_VP_ASSOCIATIONS

Line 78: CURSOR get_assoc_rec(cp_id okl_vp_associations.id%TYPE)

74: RETURN VARCHAR2 IS
75:
76: -- Cursor to fetch the effective dates of all the associated objects of same type
77: -- keeping one object as the reference.
78: CURSOR get_assoc_rec(cp_id okl_vp_associations.id%TYPE)
79: IS
80: SELECT start_date,
81: end_date
82: ,chr_id

Line 87: FROM OKL_VP_ASSOCIATIONS

83: ,crs_id
84: ,assoc_object_id
85: ,assoc_object_version
86: ,assoc_object_type_code
87: FROM OKL_VP_ASSOCIATIONS
88: WHERE id = cp_id;
89: cv_get_assoc_rec get_assoc_rec%ROWTYPE;
90:
91: -- find out all objects with similar id (and optional version) which on the same association and with overlap dates

Line 93: CURSOR c_get_dup_obj_assoc (cp_object_id okl_vp_associations.assoc_object_id%TYPE

89: cv_get_assoc_rec get_assoc_rec%ROWTYPE;
90:
91: -- find out all objects with similar id (and optional version) which on the same association and with overlap dates
92: -- assoc_object_type would not make a difference here
93: CURSOR c_get_dup_obj_assoc (cp_object_id okl_vp_associations.assoc_object_id%TYPE
94: ,cp_crs_id okl_vp_change_requests.id%TYPE
95: ,cp_start_date okl_vp_associations.start_date%TYPE
96: ,cp_end_date okl_vp_associations.end_date%TYPE
97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE

Line 95: ,cp_start_date okl_vp_associations.start_date%TYPE

91: -- find out all objects with similar id (and optional version) which on the same association and with overlap dates
92: -- assoc_object_type would not make a difference here
93: CURSOR c_get_dup_obj_assoc (cp_object_id okl_vp_associations.assoc_object_id%TYPE
94: ,cp_crs_id okl_vp_change_requests.id%TYPE
95: ,cp_start_date okl_vp_associations.start_date%TYPE
96: ,cp_end_date okl_vp_associations.end_date%TYPE
97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
98: ,cp_id okl_vp_associations.id%TYPE
99: )IS

Line 96: ,cp_end_date okl_vp_associations.end_date%TYPE

92: -- assoc_object_type would not make a difference here
93: CURSOR c_get_dup_obj_assoc (cp_object_id okl_vp_associations.assoc_object_id%TYPE
94: ,cp_crs_id okl_vp_change_requests.id%TYPE
95: ,cp_start_date okl_vp_associations.start_date%TYPE
96: ,cp_end_date okl_vp_associations.end_date%TYPE
97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
98: ,cp_id okl_vp_associations.id%TYPE
99: )IS
100: SELECT 'X'

Line 97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE

93: CURSOR c_get_dup_obj_assoc (cp_object_id okl_vp_associations.assoc_object_id%TYPE
94: ,cp_crs_id okl_vp_change_requests.id%TYPE
95: ,cp_start_date okl_vp_associations.start_date%TYPE
96: ,cp_end_date okl_vp_associations.end_date%TYPE
97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
98: ,cp_id okl_vp_associations.id%TYPE
99: )IS
100: SELECT 'X'
101: FROM okl_vp_associations

Line 98: ,cp_id okl_vp_associations.id%TYPE

94: ,cp_crs_id okl_vp_change_requests.id%TYPE
95: ,cp_start_date okl_vp_associations.start_date%TYPE
96: ,cp_end_date okl_vp_associations.end_date%TYPE
97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
98: ,cp_id okl_vp_associations.id%TYPE
99: )IS
100: SELECT 'X'
101: FROM okl_vp_associations
102: WHERE crs_id = cp_crs_id

Line 101: FROM okl_vp_associations

97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
98: ,cp_id okl_vp_associations.id%TYPE
99: )IS
100: SELECT 'X'
101: FROM okl_vp_associations
102: WHERE crs_id = cp_crs_id
103: AND chr_id IS NULL
104: AND id <> cp_id
105: AND assoc_object_id = cp_object_id

Line 112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE

108: (trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(nvl(cp_end_date,okl_accounting_util.g_final_date))) OR
109: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
110: );
111:
112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE
113: ,cp_chr_id okc_k_headers_b.id%TYPE
114: ,cp_start_date okl_vp_associations.start_date%TYPE
115: ,cp_end_date okl_vp_associations.end_date%TYPE
116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE

Line 114: ,cp_start_date okl_vp_associations.start_date%TYPE

110: );
111:
112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE
113: ,cp_chr_id okc_k_headers_b.id%TYPE
114: ,cp_start_date okl_vp_associations.start_date%TYPE
115: ,cp_end_date okl_vp_associations.end_date%TYPE
116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
117: ,cp_id okl_vp_associations.id%TYPE
118: )IS

Line 115: ,cp_end_date okl_vp_associations.end_date%TYPE

111:
112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE
113: ,cp_chr_id okc_k_headers_b.id%TYPE
114: ,cp_start_date okl_vp_associations.start_date%TYPE
115: ,cp_end_date okl_vp_associations.end_date%TYPE
116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
117: ,cp_id okl_vp_associations.id%TYPE
118: )IS
119: SELECT 'X'

Line 116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE

112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE
113: ,cp_chr_id okc_k_headers_b.id%TYPE
114: ,cp_start_date okl_vp_associations.start_date%TYPE
115: ,cp_end_date okl_vp_associations.end_date%TYPE
116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
117: ,cp_id okl_vp_associations.id%TYPE
118: )IS
119: SELECT 'X'
120: FROM okl_vp_associations

Line 117: ,cp_id okl_vp_associations.id%TYPE

113: ,cp_chr_id okc_k_headers_b.id%TYPE
114: ,cp_start_date okl_vp_associations.start_date%TYPE
115: ,cp_end_date okl_vp_associations.end_date%TYPE
116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
117: ,cp_id okl_vp_associations.id%TYPE
118: )IS
119: SELECT 'X'
120: FROM okl_vp_associations
121: WHERE chr_id = cp_chr_id

Line 120: FROM okl_vp_associations

116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
117: ,cp_id okl_vp_associations.id%TYPE
118: )IS
119: SELECT 'X'
120: FROM okl_vp_associations
121: WHERE chr_id = cp_chr_id
122: AND crs_id IS NULL
123: AND id <> cp_id
124: AND assoc_object_id = cp_object_id

Line 427: FROM okl_vp_associations vp_assoc

423: vp_assoc.end_date,
424: vp_assoc.assoc_object_type_code,
425: vp_assoc.assoc_object_id,
426: vp_assoc.assoc_object_version
427: FROM okl_vp_associations vp_assoc
428: ,okc_k_headers_b chr
429: ,okc_statuses_b sts
430: WHERE vp_assoc.chr_id = cp_chr_id
431: AND vp_assoc.chr_id = chr.id

Line 442: FROM okl_vp_associations vpa,

438: vpa.end_date,
439: vpa.assoc_object_type_code,
440: vpa.assoc_object_id,
441: vpa.assoc_object_version
442: FROM okl_vp_associations vpa,
443: okl_vp_change_requests creq
444: WHERE creq.chr_id = cp_chr_id
445: AND vpa.crs_id = creq.id
446: AND creq.status_code in ('PASSED','NEW','INCOMPLETE');

Line 457: FROM okl_vp_associations vpa,

453: vpa.end_date,
454: vpa.assoc_object_type_code,
455: vpa.assoc_object_id,
456: vpa.assoc_object_version
457: FROM okl_vp_associations vpa,
458: okl_vp_change_requests creq
459: WHERE vpa.crs_id = (select crs_id from okl_k_headers where id = cp_chr_id)
460: AND vpa.crs_id = creq.id
461: AND creq.status_code in ('PASSED','NEW','INCOMPLETE')

Line 529: okl_vp_associations_v vpa,

525: cp_start_date IN DATE,
526: cp_end_date IN DATE)IS
527: SELECT lat.name
528: FROM OKL_LEASEAPP_TMPLS lat,
529: okl_vp_associations_v vpa,
530: okc_k_headers_b chr,
531: okc_statuses_b sts
532: WHERE lat.id = vpa.assoc_object_id
533: AND chr.id = vpa.chr_id

Line 551: okl_vp_associations_v vpa,

547: )
548: UNION
549: SELECT lat.name
550: FROM OKL_LEASEAPP_TMPLS lat,
551: okl_vp_associations_v vpa,
552: okl_vp_change_requests chreq
553: WHERE lat.id = vpa.assoc_object_id
554: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
555: AND chreq.chr_id = cp_chr_id

Line 571: okl_vp_associations_v vpa,

567: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE')
568: UNION
569: SELECT lat.name
570: FROM OKL_LEASEAPP_TMPLS lat,
571: okl_vp_associations_v vpa,
572: okl_vp_change_requests chreq,
573: okl_k_headers okl
574: WHERE lat.id = vpa.assoc_object_id
575: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'