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.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on DBMS_LOB

Line 29: DBMS_LOB.createtemporary (p_xfdf_string, FALSE, DBMS_LOB.CALL);

25: l_str6 := '';
26: l_str7 :=
27: '
28: ';
29: DBMS_LOB.createtemporary (p_xfdf_string, FALSE, DBMS_LOB.CALL);
30: DBMS_LOB.OPEN (p_xfdf_string, DBMS_LOB.lob_readwrite);
31: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 13);
32:
33: IF vxmltable.COUNT > 0

Line 30: DBMS_LOB.OPEN (p_xfdf_string, DBMS_LOB.lob_readwrite);

26: l_str7 :=
27: '
28: ';
29: DBMS_LOB.createtemporary (p_xfdf_string, FALSE, DBMS_LOB.CALL);
30: DBMS_LOB.OPEN (p_xfdf_string, DBMS_LOB.lob_readwrite);
31: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 13);
32:
33: IF vxmltable.COUNT > 0
34: THEN

Line 35: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str1), l_str1);

31: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 13);
32:
33: IF vxmltable.COUNT > 0
34: THEN
35: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str1), l_str1);
36:
37: FOR ctr_table IN vxmltable.FIRST .. vxmltable.LAST
38: LOOP
39: hr_utility.set_location ( vxmltable (ctr_table).tagname

Line 52: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);

48: AND l_str8 NOT LIKE '/%'
49: AND SUBSTR (l_str8, 1, 2) <> 'G_'
50: )
51: THEN
52: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
53: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);
56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);

Line 53: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);

49: AND SUBSTR (l_str8, 1, 2) <> 'G_'
50: )
51: THEN
52: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
53: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);
56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);
57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);

Line 54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);

50: )
51: THEN
52: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
53: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);
56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);
57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);

Line 55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);

51: THEN
52: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
53: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);
56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);
57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);
59: ELSIF l_str8 LIKE '/%' OR SUBSTR (l_str8, 1, 2) = 'G_'

Line 56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);

52: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
53: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);
56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);
57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);
59: ELSIF l_str8 LIKE '/%' OR SUBSTR (l_str8, 1, 2) = 'G_'
60: THEN

Line 57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);

53: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);
56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);
57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);
59: ELSIF l_str8 LIKE '/%' OR SUBSTR (l_str8, 1, 2) = 'G_'
60: THEN
61: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);

Line 58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);

54: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
55: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str9), l_str9);
56: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str4), l_str4);
57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);
59: ELSIF l_str8 LIKE '/%' OR SUBSTR (l_str8, 1, 2) = 'G_'
60: THEN
61: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
62: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);

Line 61: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);

57: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);
59: ELSIF l_str8 LIKE '/%' OR SUBSTR (l_str8, 1, 2) = 'G_'
60: THEN
61: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
62: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
63: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
64: ELSE
65: NULL;

Line 62: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);

58: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str5), l_str5);
59: ELSIF l_str8 LIKE '/%' OR SUBSTR (l_str8, 1, 2) = 'G_'
60: THEN
61: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
62: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
63: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
64: ELSE
65: NULL;
66: END IF;

Line 63: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);

59: ELSIF l_str8 LIKE '/%' OR SUBSTR (l_str8, 1, 2) = 'G_'
60: THEN
61: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str2), l_str2);
62: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str8), l_str8);
63: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str3), l_str3);
64: ELSE
65: NULL;
66: END IF;
67: END LOOP;

Line 69: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str6), l_str6);

65: NULL;
66: END IF;
67: END LOOP;
68:
69: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str6), l_str6);
70: ELSE
71: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str7), l_str7);
72: END IF;
73: /* INSERT INTO tmp

Line 71: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str7), l_str7);

67: END LOOP;
68:
69: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str6), l_str6);
70: ELSE
71: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str7), l_str7);
72: END IF;
73: /* INSERT INTO tmp
74: * VALUES (p_xfdf_string);*/
75: END writetoclob;