DBA Data[Home] [Help]

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 2005/12/22 17:04 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_p4(t out nocopy cs_sr_extattributes_pvt.ext_attr_audit_tbl_type, a0 JTF_NUMBER_TABLE

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 cs_sr_extattributes_pvt.ext_attr_audit_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_200
16: , a3 JTF_VARCHAR2_TABLE_200
17: , a4 JTF_VARCHAR2_TABLE_200

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

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

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

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

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

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

Line 1152: cs_sr_extattributes_pvt.get_sr_ext_attrs(p_api_version,

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

Line 1287: cs_sr_extattributes_pvt.process_sr_ext_attrs(p_api_version,

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

Line 1593: ddp_sr_ea_new_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

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

Line 1594: ddp_sr_ea_old_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

1590: )
1591:
1592: as
1593: ddp_sr_ea_new_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
1594: ddp_sr_ea_old_audit_rec_table cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
1595: ddp_modified_on date;
1596: ddindx binary_integer; indx binary_integer;
1597: begin
1598:

Line 1600: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_sr_ea_new_audit_rec_table, p0_a0

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

Line 1736: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_sr_ea_old_audit_rec_table, p1_a0

1732: , p0_a132
1733: , p0_a133
1734: );
1735:
1736: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_sr_ea_old_audit_rec_table, p1_a0
1737: , p1_a1
1738: , p1_a2
1739: , p1_a3
1740: , p1_a4

Line 1880: cs_sr_extattributes_pvt.create_ext_attr_audit(ddp_sr_ea_new_audit_rec_table,

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

Line 1942: ddx_ext_grp_attr_tbl cs_sr_extattributes_pvt.ext_grp_attr_tbl_type;

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

Line 1980: cs_sr_extattributes_pvt.merge_ext_attrs_details(ddp_ext_attr_grp_tbl,

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

Line 1990: cs_sr_extattributes_pvt_w.rosetta_table_copy_out_p6(ddx_ext_grp_attr_tbl, p2_a0

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

Line 2283: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

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

Line 2284: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

2280: )
2281:
2282: as
2283: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2284: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2285: ddp_modified_on date;
2286: ddindx binary_integer; indx binary_integer;
2287: begin
2288:

Line 2290: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_new_ext_attrs, p0_a0

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

Line 2426: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0

2422: , p0_a132
2423: , p0_a133
2424: );
2425:
2426: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0
2427: , p1_a1
2428: , p1_a2
2429: , p1_a3
2430: , p1_a4

Line 2569: cs_sr_extattributes_pvt.insert_sr_row(ddp_new_ext_attrs,

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

Line 2862: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

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

Line 2863: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

2859: )
2860:
2861: as
2862: ddp_new_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2863: ddp_old_ext_attrs cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;
2864: ddp_modified_on date;
2865: ddindx binary_integer; indx binary_integer;
2866: begin
2867:

Line 2869: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_new_ext_attrs, p0_a0

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

Line 3005: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0

3001: , p0_a132
3002: , p0_a133
3003: );
3004:
3005: cs_sr_extattributes_pvt_w.rosetta_table_copy_in_p4(ddp_old_ext_attrs, p1_a0
3006: , p1_a1
3007: , p1_a2
3008: , p1_a3
3009: , p1_a4

Line 3148: cs_sr_extattributes_pvt.insert_pr_row(ddp_new_ext_attrs,

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

Line 3306: ddx_ext_attrs_tbl cs_sr_extattributes_pvt.ext_attr_audit_tbl_type;

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

Line 3317: cs_sr_extattributes_pvt.populate_ext_attr_audit_tbl(p_extension_id,

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

Line 3325: cs_sr_extattributes_pvt_w.rosetta_table_copy_out_p4(ddx_ext_attrs_tbl, p1_a0

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

Line 3465: end cs_sr_extattributes_pvt_w;

3461:
3462:
3463: end;
3464:
3465: end cs_sr_extattributes_pvt_w;