PACKAGE: APPS.CSP_CREATE_PARTS_REQ_PKG

Source

1 PACKAGE CSP_CREATE_PARTS_REQ_PKG AUTHID CURRENT_USER AS
2 /* $Header: cspgcprs.pls 120.0.12020000.5 2013/03/21 03:55:26 sunarasi noship $ */
3 -- Start of Comments
4 -- Package name     : CSP_CREATE_PARTS_REQ_PKG
5 -- Purpose          :
6 -- History          :
7 --  01-Mar-13, sunarasi
8 --
9 -- NOTE             :
10 -- End of Comments
11 TYPE reqmt_hdr_cur IS REF CURSOR;
12 type reqmt_lines_cur is ref cursor;
13 reqmt_lines_tbl csp_requirement_lines_pub.rql_tbl_type;
14   FUNCTION create_requirement_headers(
15       p_open_requirement  VARCHAR2
16     , p_ship_to_location_id  NUMBER
17     , p_task_id  NUMBER
18     , p_task_assignment_id  NUMBER
19     , p_shipping_method_code  VARCHAR2
20     , p_need_by_date  DATE
21     , p_destination_organization_id  NUMBER
22     , p_parts_defined  VARCHAR2
23     , p_attribute_category  VARCHAR2
24     , p_attribute1  VARCHAR2
25     , p_attribute2  VARCHAR2
26     , p_attribute3  VARCHAR2
27     , p_attribute4  VARCHAR2
28     , p_attribute5  VARCHAR2
29     , p_attribute6  VARCHAR2
30     , p_attribute7  VARCHAR2
31     , p_attribute8  VARCHAR2
32     , p_attribute9  VARCHAR2
33     , p_attribute10  VARCHAR2
34     , p_attribute11  VARCHAR2
35     , p_attribute12  VARCHAR2
36     , p_attribute13  VARCHAR2
37     , p_attribute14  VARCHAR2
38     , p_attribute15  VARCHAR2
39     , p_order_type_id  NUMBER
40     , p_address_type  VARCHAR2
41     , p_resource_id  NUMBER
42     , p_resource_type  VARCHAR2
43     , p_timezone_id  NUMBER
44     , p_destination_subinventory  VARCHAR2
45     , p_created_by  NUMBER
46     , p_creation_date  DATE
47     , p_last_updated_by  NUMBER
48     , p_last_update_date  DATE
49     , p_last_update_login  NUMBER)  RETURN reqmt_hdr_cur;
50 
51     function create_requirement_lines(
52         p_requirement_line_id number
53        ,p_created_by number
54        ,p_creation_date date
55        ,p_last_updated_by number
56        ,p_last_update_date date
57        ,p_last_update_login number
58        ,p_requirement_header_id number
59        ,p_inventory_item_id number
60        ,p_uom_code varchar2
61        ,p_required_quantity number
62        ,p_ship_complete_flag varchar2
63        ,p_likelihood number
64        ,p_revision varchar2
65        ,p_source_organization_id number
66        ,p_source_subinventory varchar2
67        ,p_ordered_quantity number
68        ,p_order_line_id number
69        ,p_reservation_id number
70        ,p_order_by_date date
71        ,p_attribute_category varchar2
72        ,p_attribute1 varchar2
73        ,p_attribute2 varchar2
74        ,p_attribute3 varchar2
75        ,p_attribute4 varchar2
76        ,p_attribute5 varchar2
77        ,p_attribute6 varchar2
78        ,p_attribute7 varchar2
79        ,p_attribute8 varchar2
80        ,p_attribute9 varchar2
81        ,p_attribute10 varchar2
82        ,p_attribute11 varchar2
83        ,p_attribute12 varchar2
84        ,p_attribute13 varchar2
85        ,p_attribute14 varchar2
86        ,p_attribute15 varchar2
87        ,p_arrival_date date
88        ,p_item_scratchpad varchar2
89        ,p_shipping_method_code varchar2
90        ,p_local_reservation_id number
91        ,p_sourced_from VARCHAR2) return reqmt_lines_cur;
92 END;