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_SR_EXTATTRIBUTES_PVT_W dependencies on CS_SR_EXTATTRIBUTES_PVT

Line 1: package body cs_sr_extattributes_pvt_w as

1: package body cs_sr_extattributes_pvt_w as
2: /* $Header: csvextrb.pls 120.4.12010000.2 2009/06/23 10:46:57 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_p4(t out nocopy cs_sr_extattributes_pvt.ext_attr_audit_tbl_type, a0 JTF_NUMBER_TABLE

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_p4(t out nocopy cs_sr_extattributes_pvt.ext_attr_audit_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_200
19: , a3 JTF_VARCHAR2_TABLE_200
20: , a4 JTF_VARCHAR2_TABLE_200

Line 301: procedure rosetta_table_copy_out_p4(t cs_sr_extattributes_pvt.ext_attr_audit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

297: end loop;
298: end if;
299: end if;
300: end rosetta_table_copy_in_p4;
301: procedure rosetta_table_copy_out_p4(t cs_sr_extattributes_pvt.ext_attr_audit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
302: , a1 out nocopy JTF_NUMBER_TABLE
303: , a2 out nocopy JTF_VARCHAR2_TABLE_200
304: , a3 out nocopy JTF_VARCHAR2_TABLE_200
305: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 990: procedure rosetta_table_copy_in_p6(t out nocopy cs_sr_extattributes_pvt.ext_grp_attr_tbl_type, a0 JTF_NUMBER_TABLE

986: end if;
987: end if;
988: end rosetta_table_copy_out_p4;
989:
990: procedure rosetta_table_copy_in_p6(t out nocopy cs_sr_extattributes_pvt.ext_grp_attr_tbl_type, a0 JTF_NUMBER_TABLE
991: , a1 JTF_NUMBER_TABLE
992: , a2 JTF_VARCHAR2_TABLE_100
993: , a3 JTF_VARCHAR2_TABLE_100
994: , a4 JTF_VARCHAR2_TABLE_200

Line 1029: procedure rosetta_table_copy_out_p6(t cs_sr_extattributes_pvt.ext_grp_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1025: end loop;
1026: end if;
1027: end if;
1028: end rosetta_table_copy_in_p6;
1029: procedure rosetta_table_copy_out_p6(t cs_sr_extattributes_pvt.ext_grp_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1030: , a1 out nocopy JTF_NUMBER_TABLE
1031: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1032: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1033: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 1155: cs_sr_extattributes_pvt.get_sr_ext_attrs(p_api_version,

1151:
1152:
1153:
1154: -- here's the delegated call to the old PL/SQL routine
1155: cs_sr_extattributes_pvt.get_sr_ext_attrs(p_api_version,
1156: p_init_msg_list,
1157: p_commit,
1158: p_incident_id,
1159: p_object_name,

Line 1290: cs_sr_extattributes_pvt.process_sr_ext_attrs(p_api_version,

1286:
1287:
1288:
1289: -- here's the delegated call to the old PL/SQL routine
1290: cs_sr_extattributes_pvt.process_sr_ext_attrs(p_api_version,
1291: p_init_msg_list,
1292: p_commit,
1293: p_incident_id,
1294: ddp_ext_attr_grp_tbl,

Line 1596: ddp_sr_ea_new_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

1592: , x_msg_data out nocopy VARCHAR2
1593: )
1594:
1595: as
1596: ddp_sr_ea_new_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
1597: ddp_sr_ea_old_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
1598: ddp_modified_on date;
1599: ddindx binary_integer; indx binary_integer;
1600: begin

Line 1597: ddp_sr_ea_old_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

1593: )
1594:
1595: as
1596: ddp_sr_ea_new_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
1597: ddp_sr_ea_old_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
1598: ddp_modified_on date;
1599: ddindx binary_integer; indx binary_integer;
1600: begin
1601:

Line 1603: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_sr_ea_new_audit_rec_table, p0_a0

1599: ddindx binary_integer; indx binary_integer;
1600: begin
1601:
1602: -- copy data to the local IN or IN-OUT args, if any
1603: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_sr_ea_new_audit_rec_table, p0_a0
1604: , p0_a1
1605: , p0_a2
1606: , p0_a3
1607: , p0_a4

Line 1739: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_sr_ea_old_audit_rec_table, p1_a0

1735: , p0_a132
1736: , p0_a133
1737: );
1738:
1739: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_sr_ea_old_audit_rec_table, p1_a0
1740: , p1_a1
1741: , p1_a2
1742: , p1_a3
1743: , p1_a4

Line 1883: cs_sr_extattributes_pvt.create_ext_attr_audit(ddp_sr_ea_new_audit_rec_table,

1879:
1880:
1881:
1882: -- here's the delegated call to the old PL/SQL routine
1883: cs_sr_extattributes_pvt.create_ext_attr_audit(ddp_sr_ea_new_audit_rec_table,
1884: ddp_sr_ea_old_audit_rec_table,
1885: p_object_name,
1886: p_modified_by,
1887: ddp_modified_on,

Line 1945: ddx_ext_grp_attr_tbl cs_sr_extattributes_pvt.ext_grp_attr_tbl_type;

1941:
1942: as
1943: ddp_ext_attr_grp_tbl cs_servicerequest_pub.ext_attr_grp_tbl_type;
1944: ddp_ext_attr_tbl cs_servicerequest_pub.ext_attr_tbl_type;
1945: ddx_ext_grp_attr_tbl cs_sr_extattributes_pvt.ext_grp_attr_tbl_type;
1946: ddindx binary_integer; indx binary_integer;
1947: begin
1948:
1949: -- copy data to the local IN or IN-OUT args, if any

Line 1983: cs_sr_extattributes_pvt.merge_ext_attrs_details(ddp_ext_attr_grp_tbl,

1979:
1980:
1981:
1982: -- here's the delegated call to the old PL/SQL routine
1983: cs_sr_extattributes_pvt.merge_ext_attrs_details(ddp_ext_attr_grp_tbl,
1984: ddp_ext_attr_tbl,
1985: ddx_ext_grp_attr_tbl,
1986: x_return_status,
1987: x_msg_count,

Line 1993: cs_sr_extattributes_pvt_w.rosetta_table_copy_out_p6(ddx_ext_grp_attr_tbl, p2_a0

1989:
1990: -- copy data back from the local variables to OUT or IN-OUT args, if any
1991:
1992:
1993: cs_sr_extattributes_pvt_w.rosetta_table_copy_out_p6(ddx_ext_grp_attr_tbl, p2_a0
1994: , p2_a1
1995: , p2_a2
1996: , p2_a3
1997: , p2_a4

Line 2286: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

2282: , x_msg_data out nocopy VARCHAR2
2283: )
2284:
2285: as
2286: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2287: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2288: ddp_modified_on date;
2289: ddindx binary_integer; indx binary_integer;
2290: begin

Line 2287: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

2283: )
2284:
2285: as
2286: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2287: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2288: ddp_modified_on date;
2289: ddindx binary_integer; indx binary_integer;
2290: begin
2291:

Line 2293: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_new_ext_attrs, p0_a0

2289: ddindx binary_integer; indx binary_integer;
2290: begin
2291:
2292: -- copy data to the local IN or IN-OUT args, if any
2293: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_new_ext_attrs, p0_a0
2294: , p0_a1
2295: , p0_a2
2296: , p0_a3
2297: , p0_a4

Line 2429: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0

2425: , p0_a132
2426: , p0_a133
2427: );
2428:
2429: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0
2430: , p1_a1
2431: , p1_a2
2432: , p1_a3
2433: , p1_a4

Line 2572: cs_sr_extattributes_pvt.insert_sr_row(ddp_new_ext_attrs,

2568:
2569:
2570:
2571: -- here's the delegated call to the old PL/SQL routine
2572: cs_sr_extattributes_pvt.insert_sr_row(ddp_new_ext_attrs,
2573: ddp_old_ext_attrs,
2574: p_modified_by,
2575: ddp_modified_on,
2576: x_return_status,

Line 2865: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

2861: , x_msg_data out nocopy VARCHAR2
2862: )
2863:
2864: as
2865: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2866: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2867: ddp_modified_on date;
2868: ddindx binary_integer; indx binary_integer;
2869: begin

Line 2866: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

2862: )
2863:
2864: as
2865: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2866: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2867: ddp_modified_on date;
2868: ddindx binary_integer; indx binary_integer;
2869: begin
2870:

Line 2872: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_new_ext_attrs, p0_a0

2868: ddindx binary_integer; indx binary_integer;
2869: begin
2870:
2871: -- copy data to the local IN or IN-OUT args, if any
2872: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_new_ext_attrs, p0_a0
2873: , p0_a1
2874: , p0_a2
2875: , p0_a3
2876: , p0_a4

Line 3008: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0

3004: , p0_a132
3005: , p0_a133
3006: );
3007:
3008: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0
3009: , p1_a1
3010: , p1_a2
3011: , p1_a3
3012: , p1_a4

Line 3151: cs_sr_extattributes_pvt.insert_pr_row(ddp_new_ext_attrs,

3147:
3148:
3149:
3150: -- here's the delegated call to the old PL/SQL routine
3151: cs_sr_extattributes_pvt.insert_pr_row(ddp_new_ext_attrs,
3152: ddp_old_ext_attrs,
3153: p_modified_by,
3154: ddp_modified_on,
3155: x_return_status,

Line 3309: ddx_ext_attrs_tbl cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

3305: , x_msg_data out nocopy VARCHAR2
3306: )
3307:
3308: as
3309: ddx_ext_attrs_tbl cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
3310: ddindx binary_integer; indx binary_integer;
3311: begin
3312:
3313: -- copy data to the local IN or IN-OUT args, if any

Line 3320: cs_sr_extattributes_pvt.populate_ext_attr_audit_tbl(p_extension_id,

3316:
3317:
3318:
3319: -- here's the delegated call to the old PL/SQL routine
3320: cs_sr_extattributes_pvt.populate_ext_attr_audit_tbl(p_extension_id,
3321: ddx_ext_attrs_tbl,
3322: x_return_status,
3323: x_msg_count,
3324: x_msg_data);

Line 3328: cs_sr_extattributes_pvt_w.rosetta_table_copy_out_p4(ddx_ext_attrs_tbl, p1_a0

3324: x_msg_data);
3325:
3326: -- copy data back from the local variables to OUT or IN-OUT args, if any
3327:
3328: cs_sr_extattributes_pvt_w.rosetta_table_copy_out_p4(ddx_ext_attrs_tbl, p1_a0
3329: , p1_a1
3330: , p1_a2
3331: , p1_a3
3332: , p1_a4

Line 3468: end cs_sr_extattributes_pvt_w;

3464:
3465:
3466: end;
3467:
3468: end cs_sr_extattributes_pvt_w;