APPS.CSP_EXCESS_LISTS_PKG_W dependencies on CSP_EXCESS_LISTS_PKG

Line 1: package body csp_excess_lists_pkg_w as

1: package body csp_excess_lists_pkg_w as
2: /* $Header: csptexcwb.pls 120.1 2011/04/09 18:11:50 htank 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_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_p2(t out nocopy csp_excess_lists_pkg.excess_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 103: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 375: csp_excess_lists_pkg.insert_row(px_excess_line_id,

371:
372:
373:
374: -- here's the delegated call to the old PL/SQL routine
375: csp_excess_lists_pkg.insert_row(px_excess_line_id,
376: p_created_by,
377: ddp_creation_date,
378: p_last_updated_by,
379: ddp_last_update_date,

Line 516: csp_excess_lists_pkg.update_row(p_excess_line_id,

512:
513:
514:
515: -- here's the delegated call to the old PL/SQL routine
516: csp_excess_lists_pkg.update_row(p_excess_line_id,
517: p_created_by,
518: ddp_creation_date,
519: p_last_updated_by,
520: ddp_last_update_date,

Line 651: csp_excess_lists_pkg.lock_row(p_excess_line_id,

647:
648:
649:
650: -- here's the delegated call to the old PL/SQL routine
651: csp_excess_lists_pkg.lock_row(p_excess_line_id,
652: p_created_by,
653: ddp_creation_date,
654: p_last_updated_by,
655: ddp_last_update_date,

Line 714: end csp_excess_lists_pkg_w;

710:
711:
712: end;
713:
714: end csp_excess_lists_pkg_w;