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.IEM_SERVICEREQUEST_PVT_W dependencies on IEM_SERVICEREQUEST_PVT

Line 1: package body iem_servicerequest_pvt_w as

1: package body iem_servicerequest_pvt_w as
2: /* $Header: iemcspkb.pls 115.3 2002/12/23 19:34:53 mrabatin 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_p4(t out nocopy iem_servicerequest_pvt.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_p4(t out nocopy iem_servicerequest_pvt.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_p4(t iem_servicerequest_pvt.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p4;
48: procedure rosetta_table_copy_out_p4(t iem_servicerequest_pvt.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_p6(t out nocopy iem_servicerequest_pvt.contacts_table, a0 JTF_NUMBER_TABLE

108: end if;
109: end if;
110: end rosetta_table_copy_out_p4;
111:
112: procedure rosetta_table_copy_in_p6(t out nocopy iem_servicerequest_pvt.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 141: procedure rosetta_table_copy_out_p6(t iem_servicerequest_pvt.contacts_table, a0 out nocopy JTF_NUMBER_TABLE

137: end loop;
138: end if;
139: end if;
140: end rosetta_table_copy_in_p6;
141: procedure rosetta_table_copy_out_p6(t iem_servicerequest_pvt.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
142: , a1 out nocopy JTF_NUMBER_TABLE
143: , a2 out nocopy JTF_NUMBER_TABLE
144: , a3 out nocopy JTF_VARCHAR2_TABLE_100
145: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 351: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;

347: , x_workflow_process_id out nocopy NUMBER
348: )
349:
350: as
351: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;
352: ddp_notes iem_servicerequest_pvt.notes_table;
353: ddp_contacts iem_servicerequest_pvt.contacts_table;
354: ddindx binary_integer; indx binary_integer;
355: begin

Line 352: ddp_notes iem_servicerequest_pvt.notes_table;

348: )
349:
350: as
351: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;
352: ddp_notes iem_servicerequest_pvt.notes_table;
353: ddp_contacts iem_servicerequest_pvt.contacts_table;
354: ddindx binary_integer; indx binary_integer;
355: begin
356:

Line 353: ddp_contacts iem_servicerequest_pvt.contacts_table;

349:
350: as
351: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;
352: ddp_notes iem_servicerequest_pvt.notes_table;
353: ddp_contacts iem_servicerequest_pvt.contacts_table;
354: ddindx binary_integer; indx binary_integer;
355: begin
356:
357: -- copy data to the local IN or IN-OUT args, if any

Line 498: iem_servicerequest_pvt_w.rosetta_table_copy_in_p4(ddp_notes, p14_a0

494: ddp_service_request_rec.comm_pref_code := p13_a123;
495: ddp_service_request_rec.cust_pref_lang_code := p13_a124;
496: ddp_service_request_rec.last_update_channel := p13_a125;
497:
498: iem_servicerequest_pvt_w.rosetta_table_copy_in_p4(ddp_notes, p14_a0
499: , p14_a1
500: , p14_a2
501: , p14_a3
502: , p14_a4

Line 509: iem_servicerequest_pvt_w.rosetta_table_copy_in_p6(ddp_contacts, p15_a0

505: , p14_a7
506: , p14_a8
507: );
508:
509: iem_servicerequest_pvt_w.rosetta_table_copy_in_p6(ddp_contacts, p15_a0
510: , p15_a1
511: , p15_a2
512: , p15_a3
513: , p15_a4

Line 522: iem_servicerequest_pvt.create_servicerequest_wrap(p_api_version,

518:
519:
520:
521: -- here's the delegated call to the old PL/SQL routine
522: iem_servicerequest_pvt.create_servicerequest_wrap(p_api_version,
523: p_init_msg_list,
524: p_commit,
525: x_return_status,
526: x_msg_count,

Line 729: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;

725: )
726:
727: as
728: ddp_last_update_date date;
729: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;
730: ddp_notes iem_servicerequest_pvt.notes_table;
731: ddp_contacts iem_servicerequest_pvt.contacts_table;
732: ddindx binary_integer; indx binary_integer;
733: begin

Line 730: ddp_notes iem_servicerequest_pvt.notes_table;

726:
727: as
728: ddp_last_update_date date;
729: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;
730: ddp_notes iem_servicerequest_pvt.notes_table;
731: ddp_contacts iem_servicerequest_pvt.contacts_table;
732: ddindx binary_integer; indx binary_integer;
733: begin
734:

Line 731: ddp_contacts iem_servicerequest_pvt.contacts_table;

727: as
728: ddp_last_update_date date;
729: ddp_service_request_rec iem_servicerequest_pvt.service_request_rec_type;
730: ddp_notes iem_servicerequest_pvt.notes_table;
731: ddp_contacts iem_servicerequest_pvt.contacts_table;
732: ddindx binary_integer; indx binary_integer;
733: begin
734:
735: -- copy data to the local IN or IN-OUT args, if any

Line 879: iem_servicerequest_pvt_w.rosetta_table_copy_in_p4(ddp_notes, p16_a0

875: ddp_service_request_rec.comm_pref_code := p15_a123;
876: ddp_service_request_rec.cust_pref_lang_code := p15_a124;
877: ddp_service_request_rec.last_update_channel := p15_a125;
878:
879: iem_servicerequest_pvt_w.rosetta_table_copy_in_p4(ddp_notes, p16_a0
880: , p16_a1
881: , p16_a2
882: , p16_a3
883: , p16_a4

Line 890: iem_servicerequest_pvt_w.rosetta_table_copy_in_p6(ddp_contacts, p17_a0

886: , p16_a7
887: , p16_a8
888: );
889:
890: iem_servicerequest_pvt_w.rosetta_table_copy_in_p6(ddp_contacts, p17_a0
891: , p17_a1
892: , p17_a2
893: , p17_a3
894: , p17_a4

Line 903: iem_servicerequest_pvt.update_servicerequest_wrap(p_api_version,

899:
900:
901:
902: -- here's the delegated call to the old PL/SQL routine
903: iem_servicerequest_pvt.update_servicerequest_wrap(p_api_version,
904: p_init_msg_list,
905: p_commit,
906: x_return_status,
907: x_msg_count,

Line 1079: ddp_sr_record iem_servicerequest_pvt.service_request_rec_type;

1075: , p0_a125 in out nocopy VARCHAR2
1076: )
1077:
1078: as
1079: ddp_sr_record iem_servicerequest_pvt.service_request_rec_type;
1080: ddindx binary_integer; indx binary_integer;
1081: begin
1082:
1083: -- copy data to the local IN or IN-OUT args, if any

Line 1212: iem_servicerequest_pvt.initialize_rec(ddp_sr_record);

1208: ddp_sr_record.cust_pref_lang_code := p0_a124;
1209: ddp_sr_record.last_update_channel := p0_a125;
1210:
1211: -- here's the delegated call to the old PL/SQL routine
1212: iem_servicerequest_pvt.initialize_rec(ddp_sr_record);
1213:
1214: -- copy data back from the local variables to OUT or IN-OUT args, if any
1215: p0_a0 := ddp_sr_record.request_date;
1216: p0_a1 := ddp_sr_record.type_id;

Line 1343: end iem_servicerequest_pvt_w;

1339: p0_a124 := ddp_sr_record.cust_pref_lang_code;
1340: p0_a125 := ddp_sr_record.last_update_channel;
1341: end;
1342:
1343: end iem_servicerequest_pvt_w;