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.CS_SERVICEREQUEST_PUB_W dependencies on JTF_DATE_TABLE

Line 119: , a7 JTF_DATE_TABLE

115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_VARCHAR2_TABLE_100
119: , a7 JTF_DATE_TABLE
120: , a8 JTF_DATE_TABLE
121: ) as
122: ddindx binary_integer; indx binary_integer;
123: begin

Line 120: , a8 JTF_DATE_TABLE

116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_VARCHAR2_TABLE_100
119: , a7 JTF_DATE_TABLE
120: , a8 JTF_DATE_TABLE
121: ) as
122: ddindx binary_integer; indx binary_integer;
123: begin
124: if a0 is not null and a0.count > 0 then

Line 154: , a7 out nocopy JTF_DATE_TABLE

150: , a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_DATE_TABLE
155: , a8 out nocopy JTF_DATE_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin

Line 155: , a8 out nocopy JTF_DATE_TABLE

151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_DATE_TABLE
155: , a8 out nocopy JTF_DATE_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then

Line 167: a7 := JTF_DATE_TABLE();

163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_DATE_TABLE();
168: a8 := JTF_DATE_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();

Line 168: a8 := JTF_DATE_TABLE();

164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_DATE_TABLE();
168: a8 := JTF_DATE_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();

Line 177: a7 := JTF_DATE_TABLE();

173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: if t.count > 0 then
180: a0.extend(t.count);
181: a1.extend(t.count);

Line 178: a8 := JTF_DATE_TABLE();

174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: if t.count > 0 then
180: a0.extend(t.count);
181: a1.extend(t.count);
182: a2.extend(t.count);

Line 358: , a6 JTF_DATE_TABLE

354: , a2 JTF_VARCHAR2_TABLE_200
355: , a3 JTF_VARCHAR2_TABLE_200
356: , a4 JTF_VARCHAR2_TABLE_200
357: , a5 JTF_NUMBER_TABLE
358: , a6 JTF_DATE_TABLE
359: , a7 JTF_VARCHAR2_TABLE_1000
360: , a8 JTF_VARCHAR2_TABLE_100
361: ) as
362: ddindx binary_integer; indx binary_integer;

Line 393: , a6 out nocopy JTF_DATE_TABLE

389: , a2 out nocopy JTF_VARCHAR2_TABLE_200
390: , a3 out nocopy JTF_VARCHAR2_TABLE_200
391: , a4 out nocopy JTF_VARCHAR2_TABLE_200
392: , a5 out nocopy JTF_NUMBER_TABLE
393: , a6 out nocopy JTF_DATE_TABLE
394: , a7 out nocopy JTF_VARCHAR2_TABLE_1000
395: , a8 out nocopy JTF_VARCHAR2_TABLE_100
396: ) as
397: ddindx binary_integer; indx binary_integer;

Line 406: a6 := JTF_DATE_TABLE();

402: a2 := JTF_VARCHAR2_TABLE_200();
403: a3 := JTF_VARCHAR2_TABLE_200();
404: a4 := JTF_VARCHAR2_TABLE_200();
405: a5 := JTF_NUMBER_TABLE();
406: a6 := JTF_DATE_TABLE();
407: a7 := JTF_VARCHAR2_TABLE_1000();
408: a8 := JTF_VARCHAR2_TABLE_100();
409: else
410: a0 := JTF_NUMBER_TABLE();

Line 416: a6 := JTF_DATE_TABLE();

412: a2 := JTF_VARCHAR2_TABLE_200();
413: a3 := JTF_VARCHAR2_TABLE_200();
414: a4 := JTF_VARCHAR2_TABLE_200();
415: a5 := JTF_NUMBER_TABLE();
416: a6 := JTF_DATE_TABLE();
417: a7 := JTF_VARCHAR2_TABLE_1000();
418: a8 := JTF_VARCHAR2_TABLE_100();
419: if t.count > 0 then
420: a0.extend(t.count);

Line 1409: , p15_a7 JTF_DATE_TABLE

1405: , p15_a3 JTF_VARCHAR2_TABLE_100
1406: , p15_a4 JTF_VARCHAR2_TABLE_100
1407: , p15_a5 JTF_VARCHAR2_TABLE_100
1408: , p15_a6 JTF_VARCHAR2_TABLE_100
1409: , p15_a7 JTF_DATE_TABLE
1410: , p15_a8 JTF_DATE_TABLE
1411: , p_auto_assign VARCHAR2
1412: , p_auto_generate_tasks VARCHAR2
1413: , p18_a0 out nocopy NUMBER

Line 1410: , p15_a8 JTF_DATE_TABLE

1406: , p15_a4 JTF_VARCHAR2_TABLE_100
1407: , p15_a5 JTF_VARCHAR2_TABLE_100
1408: , p15_a6 JTF_VARCHAR2_TABLE_100
1409: , p15_a7 JTF_DATE_TABLE
1410: , p15_a8 JTF_DATE_TABLE
1411: , p_auto_assign VARCHAR2
1412: , p_auto_generate_tasks VARCHAR2
1413: , p18_a0 out nocopy NUMBER
1414: , p18_a1 out nocopy VARCHAR2

Line 1998: , p15_a7 JTF_DATE_TABLE

1994: , p15_a3 JTF_VARCHAR2_TABLE_100
1995: , p15_a4 JTF_VARCHAR2_TABLE_100
1996: , p15_a5 JTF_VARCHAR2_TABLE_100
1997: , p15_a6 JTF_VARCHAR2_TABLE_100
1998: , p15_a7 JTF_DATE_TABLE
1999: , p15_a8 JTF_DATE_TABLE
2000: , p_auto_assign VARCHAR2
2001: , p_default_contract_sla_ind VARCHAR2
2002: , x_request_id out nocopy NUMBER

Line 1999: , p15_a8 JTF_DATE_TABLE

1995: , p15_a4 JTF_VARCHAR2_TABLE_100
1996: , p15_a5 JTF_VARCHAR2_TABLE_100
1997: , p15_a6 JTF_VARCHAR2_TABLE_100
1998: , p15_a7 JTF_DATE_TABLE
1999: , p15_a8 JTF_DATE_TABLE
2000: , p_auto_assign VARCHAR2
2001: , p_default_contract_sla_ind VARCHAR2
2002: , x_request_id out nocopy NUMBER
2003: , x_request_number out nocopy VARCHAR2

Line 2565: , p17_a7 JTF_DATE_TABLE

2561: , p17_a3 JTF_VARCHAR2_TABLE_100
2562: , p17_a4 JTF_VARCHAR2_TABLE_100
2563: , p17_a5 JTF_VARCHAR2_TABLE_100
2564: , p17_a6 JTF_VARCHAR2_TABLE_100
2565: , p17_a7 JTF_DATE_TABLE
2566: , p17_a8 JTF_DATE_TABLE
2567: , p_called_by_workflow VARCHAR2
2568: , p_workflow_process_id NUMBER
2569: , p_auto_assign VARCHAR2

Line 2566: , p17_a8 JTF_DATE_TABLE

2562: , p17_a4 JTF_VARCHAR2_TABLE_100
2563: , p17_a5 JTF_VARCHAR2_TABLE_100
2564: , p17_a6 JTF_VARCHAR2_TABLE_100
2565: , p17_a7 JTF_DATE_TABLE
2566: , p17_a8 JTF_DATE_TABLE
2567: , p_called_by_workflow VARCHAR2
2568: , p_workflow_process_id NUMBER
2569: , p_auto_assign VARCHAR2
2570: , p_validate_sr_closure VARCHAR2

Line 3150: , p17_a7 JTF_DATE_TABLE

3146: , p17_a3 JTF_VARCHAR2_TABLE_100
3147: , p17_a4 JTF_VARCHAR2_TABLE_100
3148: , p17_a5 JTF_VARCHAR2_TABLE_100
3149: , p17_a6 JTF_VARCHAR2_TABLE_100
3150: , p17_a7 JTF_DATE_TABLE
3151: , p17_a8 JTF_DATE_TABLE
3152: , p_called_by_workflow VARCHAR2
3153: , p_workflow_process_id NUMBER
3154: , p_default_contract_sla_ind VARCHAR2

Line 3151: , p17_a8 JTF_DATE_TABLE

3147: , p17_a4 JTF_VARCHAR2_TABLE_100
3148: , p17_a5 JTF_VARCHAR2_TABLE_100
3149: , p17_a6 JTF_VARCHAR2_TABLE_100
3150: , p17_a7 JTF_DATE_TABLE
3151: , p17_a8 JTF_DATE_TABLE
3152: , p_called_by_workflow VARCHAR2
3153: , p_workflow_process_id NUMBER
3154: , p_default_contract_sla_ind VARCHAR2
3155: , x_workflow_process_id out nocopy NUMBER

Line 3816: , p15_a7 JTF_DATE_TABLE

3812: , p15_a3 JTF_VARCHAR2_TABLE_100
3813: , p15_a4 JTF_VARCHAR2_TABLE_100
3814: , p15_a5 JTF_VARCHAR2_TABLE_100
3815: , p15_a6 JTF_VARCHAR2_TABLE_100
3816: , p15_a7 JTF_DATE_TABLE
3817: , p15_a8 JTF_DATE_TABLE
3818: , p_default_contract_sla_ind VARCHAR2
3819: , x_request_id out nocopy NUMBER
3820: , x_request_number out nocopy VARCHAR2

Line 3817: , p15_a8 JTF_DATE_TABLE

3813: , p15_a4 JTF_VARCHAR2_TABLE_100
3814: , p15_a5 JTF_VARCHAR2_TABLE_100
3815: , p15_a6 JTF_VARCHAR2_TABLE_100
3816: , p15_a7 JTF_DATE_TABLE
3817: , p15_a8 JTF_DATE_TABLE
3818: , p_default_contract_sla_ind VARCHAR2
3819: , x_request_id out nocopy NUMBER
3820: , x_request_number out nocopy VARCHAR2
3821: , x_interaction_id out nocopy NUMBER

Line 4153: , p5_a6 JTF_DATE_TABLE

4149: , p5_a2 JTF_VARCHAR2_TABLE_200
4150: , p5_a3 JTF_VARCHAR2_TABLE_200
4151: , p5_a4 JTF_VARCHAR2_TABLE_200
4152: , p5_a5 JTF_NUMBER_TABLE
4153: , p5_a6 JTF_DATE_TABLE
4154: , p5_a7 JTF_VARCHAR2_TABLE_1000
4155: , p5_a8 JTF_VARCHAR2_TABLE_100
4156: , p_modified_by NUMBER
4157: , p_modified_on date