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 CS_SERVICEREQUEST_PUB

Line 1: package body cs_servicerequest_pub_w as

1: package body cs_servicerequest_pub_w as
2: /* $Header: cssrrswb.pls 120.10.12020000.3 2013/02/04 15:52:13 lkullamb ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
17: , a1 JTF_VARCHAR2_TABLE_32767
18: , a2 JTF_VARCHAR2_TABLE_300
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 51: procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
52: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
53: , a2 out nocopy JTF_VARCHAR2_TABLE_300
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE

Line 115: procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 JTF_NUMBER_TABLE

111: end if;
112: end if;
113: end rosetta_table_copy_out_p1;
114:
115: procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_VARCHAR2_TABLE_100
119: , a4 JTF_VARCHAR2_TABLE_100

Line 150: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE

146: end loop;
147: end if;
148: end if;
149: end rosetta_table_copy_in_p3;
150: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
151: , a1 out nocopy JTF_NUMBER_TABLE
152: , a2 out nocopy JTF_NUMBER_TABLE
153: , a3 out nocopy JTF_VARCHAR2_TABLE_100
154: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 214: procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE

210: end if;
211: end if;
212: end rosetta_table_copy_out_p3;
213:
214: procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE
215: , a1 JTF_VARCHAR2_TABLE_200
216: , a2 JTF_VARCHAR2_TABLE_200
217: , a3 JTF_VARCHAR2_TABLE_200
218: , a4 JTF_VARCHAR2_TABLE_200

Line 261: procedure rosetta_table_copy_out_p8(t cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

257: end loop;
258: end if;
259: end if;
260: end rosetta_table_copy_in_p8;
261: procedure rosetta_table_copy_out_p8(t cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
262: , a1 out nocopy JTF_VARCHAR2_TABLE_200
263: , a2 out nocopy JTF_VARCHAR2_TABLE_200
264: , a3 out nocopy JTF_VARCHAR2_TABLE_200
265: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 355: procedure rosetta_table_copy_in_p10(t out nocopy cs_servicerequest_pub.ext_attr_tbl_type, a0 JTF_NUMBER_TABLE

351: end if;
352: end if;
353: end rosetta_table_copy_out_p8;
354:
355: procedure rosetta_table_copy_in_p10(t out nocopy cs_servicerequest_pub.ext_attr_tbl_type, a0 JTF_NUMBER_TABLE
356: , a1 JTF_VARCHAR2_TABLE_100
357: , a2 JTF_VARCHAR2_TABLE_200
358: , a3 JTF_VARCHAR2_TABLE_200
359: , a4 JTF_VARCHAR2_TABLE_4000

Line 390: procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

386: end loop;
387: end if;
388: end if;
389: end rosetta_table_copy_in_p10;
390: procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
391: , a1 out nocopy JTF_VARCHAR2_TABLE_100
392: , a2 out nocopy JTF_VARCHAR2_TABLE_200
393: , a3 out nocopy JTF_VARCHAR2_TABLE_200
394: , a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 454: procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE) as

450: end if;
451: end if;
452: end rosetta_table_copy_out_p10;
453:
454: procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE) as
455: ddindx binary_integer; indx binary_integer;
456: begin
457: if a0 is not null and a0.count > 0 then
458: if a0.count > 0 then

Line 472: procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

468: end loop;
469: end if;
470: end if;
471: end rosetta_table_copy_in_p11;
472: procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
473: ddindx binary_integer; indx binary_integer;
474: begin
475: if t is null or t.count = 0 then
476: a0 := JTF_NUMBER_TABLE();

Line 495: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100) as

491: end if;
492: end if;
493: end rosetta_table_copy_out_p11;
494:
495: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100) as
496: ddindx binary_integer; indx binary_integer;
497: begin
498: if a0 is not null and a0.count > 0 then
499: if a0.count > 0 then

Line 513: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

509: end loop;
510: end if;
511: end if;
512: end rosetta_table_copy_in_p13;
513: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
514: ddindx binary_integer; indx binary_integer;
515: begin
516: if t is null or t.count = 0 then
517: a0 := JTF_VARCHAR2_TABLE_100();

Line 536: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000

532: end if;
533: end if;
534: end rosetta_table_copy_out_p13;
535:
536: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000
537: , a1 JTF_VARCHAR2_TABLE_100
538: , a2 JTF_CLOB_TABLE
539: , a3 JTF_NUMBER_TABLE
540: ) as

Line 561: procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000

557: end loop;
558: end if;
559: end if;
560: end rosetta_table_copy_in_p17;
561: procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
562: , a1 out nocopy JTF_VARCHAR2_TABLE_100
563: , a2 out nocopy JTF_CLOB_TABLE
564: , a3 out nocopy JTF_NUMBER_TABLE
565: ) as

Line 600: procedure rosetta_table_copy_in_p19(t out nocopy cs_servicerequest_pub.tasks_table, a0 JTF_VARCHAR2_TABLE_100

596: end if;
597: end if;
598: end rosetta_table_copy_out_p17;
599:
600: procedure rosetta_table_copy_in_p19(t out nocopy cs_servicerequest_pub.tasks_table, a0 JTF_VARCHAR2_TABLE_100
601: , a1 JTF_VARCHAR2_TABLE_100
602: , a2 JTF_VARCHAR2_TABLE_100
603: , a3 JTF_VARCHAR2_TABLE_100
604: , a4 JTF_VARCHAR2_TABLE_100

Line 757: procedure rosetta_table_copy_out_p19(t cs_servicerequest_pub.tasks_table, a0 out nocopy JTF_VARCHAR2_TABLE_100

753: end loop;
754: end if;
755: end if;
756: end rosetta_table_copy_in_p19;
757: procedure rosetta_table_copy_out_p19(t cs_servicerequest_pub.tasks_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
758: , a1 out nocopy JTF_VARCHAR2_TABLE_100
759: , a2 out nocopy JTF_VARCHAR2_TABLE_100
760: , a3 out nocopy JTF_VARCHAR2_TABLE_100
761: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1355: ddp_sr_record cs_servicerequest_pub.service_request_rec_type;

1351: , p0_a225 in out nocopy NUMBER
1352: )
1353:
1354: as
1355: ddp_sr_record cs_servicerequest_pub.service_request_rec_type;
1356: ddindx binary_integer; indx binary_integer;
1357: begin
1358:
1359: -- copy data to the local IN or IN-OUT args, if any

Line 1588: cs_servicerequest_pub.initialize_rec(ddp_sr_record);

1584: ddp_sr_record.sla_duration_2 := p0_a224;
1585: ddp_sr_record.price_list_header_id := p0_a225;
1586:
1587: -- here's the delegated call to the old PL/SQL routine
1588: cs_servicerequest_pub.initialize_rec(ddp_sr_record);
1589:
1590: -- copy data back from the local variables to OUT or IN-OUT args, if any
1591: p0_a0 := ddp_sr_record.request_date;
1592: p0_a1 := ddp_sr_record.type_id;

Line 2099: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

2095: , p_default_coverage_template_id NUMBER
2096: )
2097:
2098: as
2099: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2100: ddp_notes cs_servicerequest_pub.notes_table;
2101: ddp_contacts cs_servicerequest_pub.contacts_table;
2102: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
2103: ddindx binary_integer; indx binary_integer;

Line 2100: ddp_notes cs_servicerequest_pub.notes_table;

2096: )
2097:
2098: as
2099: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2100: ddp_notes cs_servicerequest_pub.notes_table;
2101: ddp_contacts cs_servicerequest_pub.contacts_table;
2102: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
2103: ddindx binary_integer; indx binary_integer;
2104: begin

Line 2101: ddp_contacts cs_servicerequest_pub.contacts_table;

2097:
2098: as
2099: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2100: ddp_notes cs_servicerequest_pub.notes_table;
2101: ddp_contacts cs_servicerequest_pub.contacts_table;
2102: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
2103: ddindx binary_integer; indx binary_integer;
2104: begin
2105:

Line 2102: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;

2098: as
2099: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2100: ddp_notes cs_servicerequest_pub.notes_table;
2101: ddp_contacts cs_servicerequest_pub.contacts_table;
2102: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
2103: ddindx binary_integer; indx binary_integer;
2104: begin
2105:
2106: -- copy data to the local IN or IN-OUT args, if any

Line 2347: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0

2343: ddp_service_request_rec.sla_duration_1 := p13_a223;
2344: ddp_service_request_rec.sla_duration_2 := p13_a224;
2345: ddp_service_request_rec.price_list_header_id := p13_a225;
2346:
2347: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
2348: , p14_a1
2349: , p14_a2
2350: , p14_a3
2351: , p14_a4

Line 2358: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0

2354: , p14_a7
2355: , p14_a8
2356: );
2357:
2358: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
2359: , p15_a1
2360: , p15_a2
2361: , p15_a3
2362: , p15_a4

Line 2375: cs_servicerequest_pub.create_servicerequest(p_api_version,

2371:
2372:
2373:
2374: -- here's the delegated call to the old PL/SQL routine
2375: cs_servicerequest_pub.create_servicerequest(p_api_version,
2376: p_init_msg_list,
2377: p_commit,
2378: x_return_status,
2379: x_msg_count,

Line 2715: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

2711: , x_individual_type out nocopy VARCHAR2
2712: )
2713:
2714: as
2715: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2716: ddp_notes cs_servicerequest_pub.notes_table;
2717: ddp_contacts cs_servicerequest_pub.contacts_table;
2718: ddindx binary_integer; indx binary_integer;
2719: begin

Line 2716: ddp_notes cs_servicerequest_pub.notes_table;

2712: )
2713:
2714: as
2715: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2716: ddp_notes cs_servicerequest_pub.notes_table;
2717: ddp_contacts cs_servicerequest_pub.contacts_table;
2718: ddindx binary_integer; indx binary_integer;
2719: begin
2720:

Line 2717: ddp_contacts cs_servicerequest_pub.contacts_table;

2713:
2714: as
2715: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2716: ddp_notes cs_servicerequest_pub.notes_table;
2717: ddp_contacts cs_servicerequest_pub.contacts_table;
2718: ddindx binary_integer; indx binary_integer;
2719: begin
2720:
2721: -- copy data to the local IN or IN-OUT args, if any

Line 2962: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0

2958: ddp_service_request_rec.sla_duration_1 := p13_a223;
2959: ddp_service_request_rec.sla_duration_2 := p13_a224;
2960: ddp_service_request_rec.price_list_header_id := p13_a225;
2961:
2962: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
2963: , p14_a1
2964: , p14_a2
2965: , p14_a3
2966: , p14_a4

Line 2973: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0

2969: , p14_a7
2970: , p14_a8
2971: );
2972:
2973: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
2974: , p15_a1
2975: , p15_a2
2976: , p15_a3
2977: , p15_a4

Line 2994: cs_servicerequest_pub.create_servicerequest(p_api_version,

2990:
2991:
2992:
2993: -- here's the delegated call to the old PL/SQL routine
2994: cs_servicerequest_pub.create_servicerequest(p_api_version,
2995: p_init_msg_list,
2996: p_commit,
2997: x_return_status,
2998: x_msg_count,

Line 3327: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

3323: )
3324:
3325: as
3326: ddp_last_update_date date;
3327: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3328: ddp_notes cs_servicerequest_pub.notes_table;
3329: ddp_contacts cs_servicerequest_pub.contacts_table;
3330: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
3331: ddindx binary_integer; indx binary_integer;

Line 3328: ddp_notes cs_servicerequest_pub.notes_table;

3324:
3325: as
3326: ddp_last_update_date date;
3327: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3328: ddp_notes cs_servicerequest_pub.notes_table;
3329: ddp_contacts cs_servicerequest_pub.contacts_table;
3330: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
3331: ddindx binary_integer; indx binary_integer;
3332: begin

Line 3329: ddp_contacts cs_servicerequest_pub.contacts_table;

3325: as
3326: ddp_last_update_date date;
3327: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3328: ddp_notes cs_servicerequest_pub.notes_table;
3329: ddp_contacts cs_servicerequest_pub.contacts_table;
3330: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
3331: ddindx binary_integer; indx binary_integer;
3332: begin
3333:

Line 3330: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;

3326: ddp_last_update_date date;
3327: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3328: ddp_notes cs_servicerequest_pub.notes_table;
3329: ddp_contacts cs_servicerequest_pub.contacts_table;
3330: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
3331: ddindx binary_integer; indx binary_integer;
3332: begin
3333:
3334: -- copy data to the local IN or IN-OUT args, if any

Line 3578: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0

3574: ddp_service_request_rec.sla_duration_1 := p15_a223;
3575: ddp_service_request_rec.sla_duration_2 := p15_a224;
3576: ddp_service_request_rec.price_list_header_id := p15_a225;
3577:
3578: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0
3579: , p16_a1
3580: , p16_a2
3581: , p16_a3
3582: , p16_a4

Line 3589: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0

3585: , p16_a7
3586: , p16_a8
3587: );
3588:
3589: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0
3590: , p17_a1
3591: , p17_a2
3592: , p17_a3
3593: , p17_a4

Line 3609: cs_servicerequest_pub.update_servicerequest(p_api_version,

3605:
3606:
3607:
3608: -- here's the delegated call to the old PL/SQL routine
3609: cs_servicerequest_pub.update_servicerequest(p_api_version,
3610: p_init_msg_list,
3611: p_commit,
3612: x_return_status,
3613: x_msg_count,

Line 3942: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

3938: )
3939:
3940: as
3941: ddp_last_update_date date;
3942: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3943: ddp_notes cs_servicerequest_pub.notes_table;
3944: ddp_contacts cs_servicerequest_pub.contacts_table;
3945: ddindx binary_integer; indx binary_integer;
3946: begin

Line 3943: ddp_notes cs_servicerequest_pub.notes_table;

3939:
3940: as
3941: ddp_last_update_date date;
3942: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3943: ddp_notes cs_servicerequest_pub.notes_table;
3944: ddp_contacts cs_servicerequest_pub.contacts_table;
3945: ddindx binary_integer; indx binary_integer;
3946: begin
3947:

Line 3944: ddp_contacts cs_servicerequest_pub.contacts_table;

3940: as
3941: ddp_last_update_date date;
3942: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3943: ddp_notes cs_servicerequest_pub.notes_table;
3944: ddp_contacts cs_servicerequest_pub.contacts_table;
3945: ddindx binary_integer; indx binary_integer;
3946: begin
3947:
3948: -- copy data to the local IN or IN-OUT args, if any

Line 4192: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0

4188: ddp_service_request_rec.sla_duration_1 := p15_a223;
4189: ddp_service_request_rec.sla_duration_2 := p15_a224;
4190: ddp_service_request_rec.price_list_header_id := p15_a225;
4191:
4192: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0
4193: , p16_a1
4194: , p16_a2
4195: , p16_a3
4196: , p16_a4

Line 4203: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0

4199: , p16_a7
4200: , p16_a8
4201: );
4202:
4203: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0
4204: , p17_a1
4205: , p17_a2
4206: , p17_a3
4207: , p17_a4

Line 4220: cs_servicerequest_pub.update_servicerequest(p_api_version,

4216:
4217:
4218:
4219: -- here's the delegated call to the old PL/SQL routine
4220: cs_servicerequest_pub.update_servicerequest(p_api_version,
4221: p_init_msg_list,
4222: p_commit,
4223: x_return_status,
4224: x_msg_count,

Line 4329: cs_servicerequest_pub.update_status(p_api_version,

4325:
4326:
4327:
4328: -- here's the delegated call to the old PL/SQL routine
4329: cs_servicerequest_pub.update_status(p_api_version,
4330: p_init_msg_list,
4331: p_commit,
4332: x_return_status,
4333: x_msg_count,

Line 4647: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

4643: , x_workflow_process_id out nocopy NUMBER
4644: )
4645:
4646: as
4647: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
4648: ddp_notes cs_servicerequest_pub.notes_table;
4649: ddp_contacts cs_servicerequest_pub.contacts_table;
4650: ddindx binary_integer; indx binary_integer;
4651: begin

Line 4648: ddp_notes cs_servicerequest_pub.notes_table;

4644: )
4645:
4646: as
4647: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
4648: ddp_notes cs_servicerequest_pub.notes_table;
4649: ddp_contacts cs_servicerequest_pub.contacts_table;
4650: ddindx binary_integer; indx binary_integer;
4651: begin
4652:

Line 4649: ddp_contacts cs_servicerequest_pub.contacts_table;

4645:
4646: as
4647: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
4648: ddp_notes cs_servicerequest_pub.notes_table;
4649: ddp_contacts cs_servicerequest_pub.contacts_table;
4650: ddindx binary_integer; indx binary_integer;
4651: begin
4652:
4653: -- copy data to the local IN or IN-OUT args, if any

Line 4894: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0

4890: ddp_service_request_rec.sla_duration_1 := p13_a223;
4891: ddp_service_request_rec.sla_duration_2 := p13_a224;
4892: ddp_service_request_rec.price_list_header_id := p13_a225;
4893:
4894: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
4895: , p14_a1
4896: , p14_a2
4897: , p14_a3
4898: , p14_a4

Line 4905: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0

4901: , p14_a7
4902: , p14_a8
4903: );
4904:
4905: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
4906: , p15_a1
4907: , p15_a2
4908: , p15_a3
4909: , p15_a4

Line 4922: cs_servicerequest_pub.create_servicerequest(p_api_version,

4918:
4919:
4920:
4921: -- here's the delegated call to the old PL/SQL routine
4922: cs_servicerequest_pub.create_servicerequest(p_api_version,
4923: p_init_msg_list,
4924: p_commit,
4925: x_return_status,
4926: x_msg_count,

Line 5005: ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;

5001: , x_msg_data out nocopy VARCHAR2
5002: )
5003:
5004: as
5005: ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;
5006: ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;
5007: ddp_modified_on date;
5008: ddindx binary_integer; indx binary_integer;
5009: begin

Line 5006: ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;

5002: )
5003:
5004: as
5005: ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;
5006: ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;
5007: ddp_modified_on date;
5008: ddindx binary_integer; indx binary_integer;
5009: begin
5010:

Line 5016: cs_servicerequest_pub_w.rosetta_table_copy_in_p8(ddp_ext_attr_grp_tbl, p4_a0

5012:
5013:
5014:
5015:
5016: cs_servicerequest_pub_w.rosetta_table_copy_in_p8(ddp_ext_attr_grp_tbl, p4_a0
5017: , p4_a1
5018: , p4_a2
5019: , p4_a3
5020: , p4_a4

Line 5033: cs_servicerequest_pub_w.rosetta_table_copy_in_p10(ddp_ext_attr_tbl, p5_a0

5029: , p4_a13
5030: , p4_a14
5031: );
5032:
5033: cs_servicerequest_pub_w.rosetta_table_copy_in_p10(ddp_ext_attr_tbl, p5_a0
5034: , p5_a1
5035: , p5_a2
5036: , p5_a3
5037: , p5_a4

Line 5053: cs_servicerequest_pub.process_sr_ext_attrs(p_api_version,

5049:
5050:
5051:
5052: -- here's the delegated call to the old PL/SQL routine
5053: cs_servicerequest_pub.process_sr_ext_attrs(p_api_version,
5054: p_init_msg_list,
5055: p_commit,
5056: p_incident_id,
5057: ddp_ext_attr_grp_tbl,

Line 5270: ddx_getsr_out_rec cs_servicerequest_pub.get_sr_rec;

5266: , x_msg_data out nocopy VARCHAR2
5267: )
5268:
5269: as
5270: ddx_getsr_out_rec cs_servicerequest_pub.get_sr_rec;
5271: ddx_tasks cs_servicerequest_pub.tasks_table;
5272: ddx_notes cs_servicerequest_pub.sr_notes_table;
5273: ddindx binary_integer; indx binary_integer;
5274: begin

Line 5271: ddx_tasks cs_servicerequest_pub.tasks_table;

5267: )
5268:
5269: as
5270: ddx_getsr_out_rec cs_servicerequest_pub.get_sr_rec;
5271: ddx_tasks cs_servicerequest_pub.tasks_table;
5272: ddx_notes cs_servicerequest_pub.sr_notes_table;
5273: ddindx binary_integer; indx binary_integer;
5274: begin
5275:

Line 5272: ddx_notes cs_servicerequest_pub.sr_notes_table;

5268:
5269: as
5270: ddx_getsr_out_rec cs_servicerequest_pub.get_sr_rec;
5271: ddx_tasks cs_servicerequest_pub.tasks_table;
5272: ddx_notes cs_servicerequest_pub.sr_notes_table;
5273: ddindx binary_integer; indx binary_integer;
5274: begin
5275:
5276: -- copy data to the local IN or IN-OUT args, if any

Line 5386: cs_servicerequest_pub_w.rosetta_table_copy_in_p19(ddx_tasks, p4_a0

5382: ddx_getsr_out_rec.extattribute14 := p3_a102;
5383: ddx_getsr_out_rec.extattribute15 := p3_a103;
5384: ddx_getsr_out_rec.ext_context := p3_a104;
5385:
5386: cs_servicerequest_pub_w.rosetta_table_copy_in_p19(ddx_tasks, p4_a0
5387: , p4_a1
5388: , p4_a2
5389: , p4_a3
5390: , p4_a4

Line 5458: cs_servicerequest_pub_w.rosetta_table_copy_in_p17(ddx_notes, p5_a0

5454: , p4_a68
5455: , p4_a69
5456: );
5457:
5458: cs_servicerequest_pub_w.rosetta_table_copy_in_p17(ddx_notes, p5_a0
5459: , p5_a1
5460: , p5_a2
5461: , p5_a3
5462: );

Line 5468: cs_servicerequest_pub.get_sr_info(p_api_version,

5464:
5465:
5466:
5467: -- here's the delegated call to the old PL/SQL routine
5468: cs_servicerequest_pub.get_sr_info(p_api_version,
5469: p_incident_id,
5470: p_incident_number,
5471: ddx_getsr_out_rec,
5472: ddx_tasks,

Line 5588: cs_servicerequest_pub_w.rosetta_table_copy_out_p19(ddx_tasks, p4_a0

5584: p3_a102 := ddx_getsr_out_rec.extattribute14;
5585: p3_a103 := ddx_getsr_out_rec.extattribute15;
5586: p3_a104 := ddx_getsr_out_rec.ext_context;
5587:
5588: cs_servicerequest_pub_w.rosetta_table_copy_out_p19(ddx_tasks, p4_a0
5589: , p4_a1
5590: , p4_a2
5591: , p4_a3
5592: , p4_a4

Line 5660: cs_servicerequest_pub_w.rosetta_table_copy_out_p17(ddx_notes, p5_a0

5656: , p4_a68
5657: , p4_a69
5658: );
5659:
5660: cs_servicerequest_pub_w.rosetta_table_copy_out_p17(ddx_notes, p5_a0
5661: , p5_a1
5662: , p5_a2
5663: , p5_a3
5664: );

Line 5670: end cs_servicerequest_pub_w;

5666:
5667:
5668: end;
5669:
5670: end cs_servicerequest_pub_w;