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.OKE_VERSION_COMPARISON_PKG dependencies on OKE_VERSION_COMPARE_RESULTS

Line 12: l_object_type OKE_VERSION_COMPARE_RESULTS.OBJECT_TYPE%TYPE;

8: l_amt_mask_1 VARCHAR2(80);
9: l_prc_mask_1 VARCHAR2(80);
10: l_amt_mask_2 VARCHAR2(80);
11: l_prc_mask_2 VARCHAR2(80);
12: l_object_type OKE_VERSION_COMPARE_RESULTS.OBJECT_TYPE%TYPE;
13: l_object_name OKE_VERSION_COMPARE_RESULTS.OBJECT_NAME%TYPE;
14: l_prompt OKE_VERSION_COMPARE_RESULTS.PROMPT%TYPE;
15: l_data1 OKE_VERSION_COMPARE_RESULTS.V1DATA%TYPE;
16: l_data2 OKE_VERSION_COMPARE_RESULTS.V2DATA%TYPE;

Line 13: l_object_name OKE_VERSION_COMPARE_RESULTS.OBJECT_NAME%TYPE;

9: l_prc_mask_1 VARCHAR2(80);
10: l_amt_mask_2 VARCHAR2(80);
11: l_prc_mask_2 VARCHAR2(80);
12: l_object_type OKE_VERSION_COMPARE_RESULTS.OBJECT_TYPE%TYPE;
13: l_object_name OKE_VERSION_COMPARE_RESULTS.OBJECT_NAME%TYPE;
14: l_prompt OKE_VERSION_COMPARE_RESULTS.PROMPT%TYPE;
15: l_data1 OKE_VERSION_COMPARE_RESULTS.V1DATA%TYPE;
16: l_data2 OKE_VERSION_COMPARE_RESULTS.V2DATA%TYPE;
17: l_current_flag OKE_VERSION_COMPARE_RESULTS.CURRENT_FLAG%TYPE default 'N';

Line 14: l_prompt OKE_VERSION_COMPARE_RESULTS.PROMPT%TYPE;

10: l_amt_mask_2 VARCHAR2(80);
11: l_prc_mask_2 VARCHAR2(80);
12: l_object_type OKE_VERSION_COMPARE_RESULTS.OBJECT_TYPE%TYPE;
13: l_object_name OKE_VERSION_COMPARE_RESULTS.OBJECT_NAME%TYPE;
14: l_prompt OKE_VERSION_COMPARE_RESULTS.PROMPT%TYPE;
15: l_data1 OKE_VERSION_COMPARE_RESULTS.V1DATA%TYPE;
16: l_data2 OKE_VERSION_COMPARE_RESULTS.V2DATA%TYPE;
17: l_current_flag OKE_VERSION_COMPARE_RESULTS.CURRENT_FLAG%TYPE default 'N';
18: l_Object VARCHAR(80); --lookup code in fnd_lookup

Line 15: l_data1 OKE_VERSION_COMPARE_RESULTS.V1DATA%TYPE;

11: l_prc_mask_2 VARCHAR2(80);
12: l_object_type OKE_VERSION_COMPARE_RESULTS.OBJECT_TYPE%TYPE;
13: l_object_name OKE_VERSION_COMPARE_RESULTS.OBJECT_NAME%TYPE;
14: l_prompt OKE_VERSION_COMPARE_RESULTS.PROMPT%TYPE;
15: l_data1 OKE_VERSION_COMPARE_RESULTS.V1DATA%TYPE;
16: l_data2 OKE_VERSION_COMPARE_RESULTS.V2DATA%TYPE;
17: l_current_flag OKE_VERSION_COMPARE_RESULTS.CURRENT_FLAG%TYPE default 'N';
18: l_Object VARCHAR(80); --lookup code in fnd_lookup
19: L_Attribute_Object_Name VARCHAR(80); --object name in oke_object_attributes_vl

Line 16: l_data2 OKE_VERSION_COMPARE_RESULTS.V2DATA%TYPE;

12: l_object_type OKE_VERSION_COMPARE_RESULTS.OBJECT_TYPE%TYPE;
13: l_object_name OKE_VERSION_COMPARE_RESULTS.OBJECT_NAME%TYPE;
14: l_prompt OKE_VERSION_COMPARE_RESULTS.PROMPT%TYPE;
15: l_data1 OKE_VERSION_COMPARE_RESULTS.V1DATA%TYPE;
16: l_data2 OKE_VERSION_COMPARE_RESULTS.V2DATA%TYPE;
17: l_current_flag OKE_VERSION_COMPARE_RESULTS.CURRENT_FLAG%TYPE default 'N';
18: l_Object VARCHAR(80); --lookup code in fnd_lookup
19: L_Attribute_Object_Name VARCHAR(80); --object name in oke_object_attributes_vl
20:

Line 17: l_current_flag OKE_VERSION_COMPARE_RESULTS.CURRENT_FLAG%TYPE default 'N';

13: l_object_name OKE_VERSION_COMPARE_RESULTS.OBJECT_NAME%TYPE;
14: l_prompt OKE_VERSION_COMPARE_RESULTS.PROMPT%TYPE;
15: l_data1 OKE_VERSION_COMPARE_RESULTS.V1DATA%TYPE;
16: l_data2 OKE_VERSION_COMPARE_RESULTS.V2DATA%TYPE;
17: l_current_flag OKE_VERSION_COMPARE_RESULTS.CURRENT_FLAG%TYPE default 'N';
18: l_Object VARCHAR(80); --lookup code in fnd_lookup
19: L_Attribute_Object_Name VARCHAR(80); --object name in oke_object_attributes_vl
20:
21: L_Latest_Version NUMBER :=0; --The highest version in HV table

Line 210: INSERT INTO OKE_VERSION_COMPARE_RESULTS

206: IF L_PROMPT_MULTI IS NULL THEN
207: L_PROMPT_MULTI :=l_prompt;
208: END IF;
209:
210: INSERT INTO OKE_VERSION_COMPARE_RESULTS
211: (k_header_id,
212: version1,
213: version2,
214: object_type,

Line 274: FROM oke_version_compare_results

270: WHERE K_HEADER_ID=p_header_id;
271:
272: cursor c_nCurrent_highest_version is
273: SELECT MAX(version1)
274: FROM oke_version_compare_results
275: WHERE k_header_id=p_header_id;
276:
277: BEGIN
278:

Line 297: DELETE FROM oke_version_compare_results;

293: FETCH c_nCurrent_highest_version INTO nCurrent_highest_version;
294: close c_nCurrent_highest_version;
295:
296: --clear table data
297: DELETE FROM oke_version_compare_results;
298: COMMIT;
299:
300: comp_headers(p_header_id ,vVersion1, vVersion2);
301: comp_header_parties(p_header_id ,vVersion1, vVersion2);