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.3 2005/09/07 15:37 aneemuch noship $ */
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:

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

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
14: , a1 JTF_VARCHAR2_TABLE_32767
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 744: ddp_sr_record cs_servicerequest_pub.service_request_rec_type;

740: , p0_a207 in out nocopy NUMBER
741: )
742:
743: as
744: ddp_sr_record cs_servicerequest_pub.service_request_rec_type;
745: ddindx binary_integer; indx binary_integer;
746: begin
747:
748: -- copy data to the local IN or IN-OUT args, if any

Line 959: cs_servicerequest_pub.initialize_rec(ddp_sr_record);

955: ddp_sr_record.coverage_type := p0_a206;
956: ddp_sr_record.maint_organization_id := p0_a207;
957:
958: -- here's the delegated call to the old PL/SQL routine
959: cs_servicerequest_pub.initialize_rec(ddp_sr_record);
960:
961: -- copy data back from the local variables to OUT or IN-OUT args, if any
962: p0_a0 := ddp_sr_record.request_date;
963: p0_a1 := ddp_sr_record.type_id;

Line 1433: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

1429: , p_default_coverage_template_id NUMBER
1430: )
1431:
1432: as
1433: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1434: ddp_notes cs_servicerequest_pub.notes_table;
1435: ddp_contacts cs_servicerequest_pub.contacts_table;
1436: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
1437: ddindx binary_integer; indx binary_integer;

Line 1434: ddp_notes cs_servicerequest_pub.notes_table;

1430: )
1431:
1432: as
1433: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1434: ddp_notes cs_servicerequest_pub.notes_table;
1435: ddp_contacts cs_servicerequest_pub.contacts_table;
1436: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
1437: ddindx binary_integer; indx binary_integer;
1438: begin

Line 1435: ddp_contacts cs_servicerequest_pub.contacts_table;

1431:
1432: as
1433: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1434: ddp_notes cs_servicerequest_pub.notes_table;
1435: ddp_contacts cs_servicerequest_pub.contacts_table;
1436: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
1437: ddindx binary_integer; indx binary_integer;
1438: begin
1439:

Line 1436: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;

1432: as
1433: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1434: ddp_notes cs_servicerequest_pub.notes_table;
1435: ddp_contacts cs_servicerequest_pub.contacts_table;
1436: ddx_sr_create_out_rec cs_servicerequest_pub.sr_create_out_rec_type;
1437: ddindx binary_integer; indx binary_integer;
1438: begin
1439:
1440: -- copy data to the local IN or IN-OUT args, if any

Line 1663: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0

1659: ddp_service_request_rec.incident_location_type := p13_a205;
1660: ddp_service_request_rec.coverage_type := p13_a206;
1661: ddp_service_request_rec.maint_organization_id := p13_a207;
1662:
1663: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
1664: , p14_a1
1665: , p14_a2
1666: , p14_a3
1667: , p14_a4

Line 1674: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0

1670: , p14_a7
1671: , p14_a8
1672: );
1673:
1674: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
1675: , p15_a1
1676: , p15_a2
1677: , p15_a3
1678: , p15_a4

Line 1691: cs_servicerequest_pub.create_servicerequest(p_api_version,

1687:
1688:
1689:
1690: -- here's the delegated call to the old PL/SQL routine
1691: cs_servicerequest_pub.create_servicerequest(p_api_version,
1692: p_init_msg_list,
1693: p_commit,
1694: x_return_status,
1695: x_msg_count,

Line 2012: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

2008: , x_individual_type out nocopy VARCHAR2
2009: )
2010:
2011: as
2012: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2013: ddp_notes cs_servicerequest_pub.notes_table;
2014: ddp_contacts cs_servicerequest_pub.contacts_table;
2015: ddindx binary_integer; indx binary_integer;
2016: begin

Line 2013: ddp_notes cs_servicerequest_pub.notes_table;

2009: )
2010:
2011: as
2012: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2013: ddp_notes cs_servicerequest_pub.notes_table;
2014: ddp_contacts cs_servicerequest_pub.contacts_table;
2015: ddindx binary_integer; indx binary_integer;
2016: begin
2017:

Line 2014: ddp_contacts cs_servicerequest_pub.contacts_table;

2010:
2011: as
2012: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2013: ddp_notes cs_servicerequest_pub.notes_table;
2014: ddp_contacts cs_servicerequest_pub.contacts_table;
2015: ddindx binary_integer; indx binary_integer;
2016: begin
2017:
2018: -- copy data to the local IN or IN-OUT args, if any

Line 2241: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0

2237: ddp_service_request_rec.incident_location_type := p13_a205;
2238: ddp_service_request_rec.coverage_type := p13_a206;
2239: ddp_service_request_rec.maint_organization_id := p13_a207;
2240:
2241: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
2242: , p14_a1
2243: , p14_a2
2244: , p14_a3
2245: , p14_a4

Line 2252: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0

2248: , p14_a7
2249: , p14_a8
2250: );
2251:
2252: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
2253: , p15_a1
2254: , p15_a2
2255: , p15_a3
2256: , p15_a4

Line 2273: cs_servicerequest_pub.create_servicerequest(p_api_version,

2269:
2270:
2271:
2272: -- here's the delegated call to the old PL/SQL routine
2273: cs_servicerequest_pub.create_servicerequest(p_api_version,
2274: p_init_msg_list,
2275: p_commit,
2276: x_return_status,
2277: x_msg_count,

Line 2586: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

2582: )
2583:
2584: as
2585: ddp_last_update_date date;
2586: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2587: ddp_notes cs_servicerequest_pub.notes_table;
2588: ddp_contacts cs_servicerequest_pub.contacts_table;
2589: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
2590: ddindx binary_integer; indx binary_integer;

Line 2587: ddp_notes cs_servicerequest_pub.notes_table;

2583:
2584: as
2585: ddp_last_update_date date;
2586: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2587: ddp_notes cs_servicerequest_pub.notes_table;
2588: ddp_contacts cs_servicerequest_pub.contacts_table;
2589: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
2590: ddindx binary_integer; indx binary_integer;
2591: begin

Line 2588: ddp_contacts cs_servicerequest_pub.contacts_table;

2584: as
2585: ddp_last_update_date date;
2586: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2587: ddp_notes cs_servicerequest_pub.notes_table;
2588: ddp_contacts cs_servicerequest_pub.contacts_table;
2589: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
2590: ddindx binary_integer; indx binary_integer;
2591: begin
2592:

Line 2589: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;

2585: ddp_last_update_date date;
2586: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
2587: ddp_notes cs_servicerequest_pub.notes_table;
2588: ddp_contacts cs_servicerequest_pub.contacts_table;
2589: ddx_sr_update_out_rec cs_servicerequest_pub.sr_update_out_rec_type;
2590: ddindx binary_integer; indx binary_integer;
2591: begin
2592:
2593: -- copy data to the local IN or IN-OUT args, if any

Line 2819: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0

2815: ddp_service_request_rec.incident_location_type := p15_a205;
2816: ddp_service_request_rec.coverage_type := p15_a206;
2817: ddp_service_request_rec.maint_organization_id := p15_a207;
2818:
2819: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0
2820: , p16_a1
2821: , p16_a2
2822: , p16_a3
2823: , p16_a4

Line 2830: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0

2826: , p16_a7
2827: , p16_a8
2828: );
2829:
2830: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0
2831: , p17_a1
2832: , p17_a2
2833: , p17_a3
2834: , p17_a4

Line 2849: cs_servicerequest_pub.update_servicerequest(p_api_version,

2845:
2846:
2847:
2848: -- here's the delegated call to the old PL/SQL routine
2849: cs_servicerequest_pub.update_servicerequest(p_api_version,
2850: p_init_msg_list,
2851: p_commit,
2852: x_return_status,
2853: x_msg_count,

Line 3161: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

3157: )
3158:
3159: as
3160: ddp_last_update_date date;
3161: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3162: ddp_notes cs_servicerequest_pub.notes_table;
3163: ddp_contacts cs_servicerequest_pub.contacts_table;
3164: ddindx binary_integer; indx binary_integer;
3165: begin

Line 3162: ddp_notes cs_servicerequest_pub.notes_table;

3158:
3159: as
3160: ddp_last_update_date date;
3161: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3162: ddp_notes cs_servicerequest_pub.notes_table;
3163: ddp_contacts cs_servicerequest_pub.contacts_table;
3164: ddindx binary_integer; indx binary_integer;
3165: begin
3166:

Line 3163: ddp_contacts cs_servicerequest_pub.contacts_table;

3159: as
3160: ddp_last_update_date date;
3161: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3162: ddp_notes cs_servicerequest_pub.notes_table;
3163: ddp_contacts cs_servicerequest_pub.contacts_table;
3164: ddindx binary_integer; indx binary_integer;
3165: begin
3166:
3167: -- copy data to the local IN or IN-OUT args, if any

Line 3393: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0

3389: ddp_service_request_rec.incident_location_type := p15_a205;
3390: ddp_service_request_rec.coverage_type := p15_a206;
3391: ddp_service_request_rec.maint_organization_id := p15_a207;
3392:
3393: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p16_a0
3394: , p16_a1
3395: , p16_a2
3396: , p16_a3
3397: , p16_a4

Line 3404: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0

3400: , p16_a7
3401: , p16_a8
3402: );
3403:
3404: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p17_a0
3405: , p17_a1
3406: , p17_a2
3407: , p17_a3
3408: , p17_a4

Line 3421: cs_servicerequest_pub.update_servicerequest(p_api_version,

3417:
3418:
3419:
3420: -- here's the delegated call to the old PL/SQL routine
3421: cs_servicerequest_pub.update_servicerequest(p_api_version,
3422: p_init_msg_list,
3423: p_commit,
3424: x_return_status,
3425: x_msg_count,

Line 3528: cs_servicerequest_pub.update_status(p_api_version,

3524:
3525:
3526:
3527: -- here's the delegated call to the old PL/SQL routine
3528: cs_servicerequest_pub.update_status(p_api_version,
3529: p_init_msg_list,
3530: p_commit,
3531: x_return_status,
3532: x_msg_count,

Line 3826: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;

3822: , x_workflow_process_id out nocopy NUMBER
3823: )
3824:
3825: as
3826: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3827: ddp_notes cs_servicerequest_pub.notes_table;
3828: ddp_contacts cs_servicerequest_pub.contacts_table;
3829: ddindx binary_integer; indx binary_integer;
3830: begin

Line 3827: ddp_notes cs_servicerequest_pub.notes_table;

3823: )
3824:
3825: as
3826: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3827: ddp_notes cs_servicerequest_pub.notes_table;
3828: ddp_contacts cs_servicerequest_pub.contacts_table;
3829: ddindx binary_integer; indx binary_integer;
3830: begin
3831:

Line 3828: ddp_contacts cs_servicerequest_pub.contacts_table;

3824:
3825: as
3826: ddp_service_request_rec cs_servicerequest_pub.service_request_rec_type;
3827: ddp_notes cs_servicerequest_pub.notes_table;
3828: ddp_contacts cs_servicerequest_pub.contacts_table;
3829: ddindx binary_integer; indx binary_integer;
3830: begin
3831:
3832: -- copy data to the local IN or IN-OUT args, if any

Line 4055: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0

4051: ddp_service_request_rec.incident_location_type := p13_a205;
4052: ddp_service_request_rec.coverage_type := p13_a206;
4053: ddp_service_request_rec.maint_organization_id := p13_a207;
4054:
4055: cs_servicerequest_pub_w.rosetta_table_copy_in_p1(ddp_notes, p14_a0
4056: , p14_a1
4057: , p14_a2
4058: , p14_a3
4059: , p14_a4

Line 4066: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0

4062: , p14_a7
4063: , p14_a8
4064: );
4065:
4066: cs_servicerequest_pub_w.rosetta_table_copy_in_p3(ddp_contacts, p15_a0
4067: , p15_a1
4068: , p15_a2
4069: , p15_a3
4070: , p15_a4

Line 4083: cs_servicerequest_pub.create_servicerequest(p_api_version,

4079:
4080:
4081:
4082: -- here's the delegated call to the old PL/SQL routine
4083: cs_servicerequest_pub.create_servicerequest(p_api_version,
4084: p_init_msg_list,
4085: p_commit,
4086: x_return_status,
4087: x_msg_count,

Line 4166: ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;

4162: , x_msg_data out nocopy VARCHAR2
4163: )
4164:
4165: as
4166: ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;
4167: ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;
4168: ddp_modified_on date;
4169: ddindx binary_integer; indx binary_integer;
4170: begin

Line 4167: ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;

4163: )
4164:
4165: as
4166: ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;
4167: ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;
4168: ddp_modified_on date;
4169: ddindx binary_integer; indx binary_integer;
4170: begin
4171:

Line 4177: cs_servicerequest_pub_w.rosetta_table_copy_in_p8(ddp_ext_attr_grp_tbl, p4_a0

4173:
4174:
4175:
4176:
4177: cs_servicerequest_pub_w.rosetta_table_copy_in_p8(ddp_ext_attr_grp_tbl, p4_a0
4178: , p4_a1
4179: , p4_a2
4180: , p4_a3
4181: , p4_a4

Line 4194: cs_servicerequest_pub_w.rosetta_table_copy_in_p10(ddp_ext_attr_tbl, p5_a0

4190: , p4_a13
4191: , p4_a14
4192: );
4193:
4194: cs_servicerequest_pub_w.rosetta_table_copy_in_p10(ddp_ext_attr_tbl, p5_a0
4195: , p5_a1
4196: , p5_a2
4197: , p5_a3
4198: , p5_a4

Line 4214: cs_servicerequest_pub.process_sr_ext_attrs(p_api_version,

4210:
4211:
4212:
4213: -- here's the delegated call to the old PL/SQL routine
4214: cs_servicerequest_pub.process_sr_ext_attrs(p_api_version,
4215: p_init_msg_list,
4216: p_commit,
4217: p_incident_id,
4218: ddp_ext_attr_grp_tbl,

Line 4243: end cs_servicerequest_pub_w;

4239:
4240:
4241: end;
4242:
4243: end cs_servicerequest_pub_w;