DBA Data[Home] [Help]

PACKAGE: APPS.OZF_SD_REQUEST_LINES_PKG

Source


1 PACKAGE OZF_SD_REQUEST_LINES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftspls.pls 120.2 2008/01/03 13:27:39 bkunjan noship $ */
3 
4 PROCEDURE Insert_Row(
5     p_request_line_id                  NUMBER,
6     p_object_version_number            NUMBER,
7     p_last_update_date                 DATE,
8     p_last_updated_by                  NUMBER,
9     p_creation_date                    DATE,
10     p_created_by                       NUMBER,
11     p_last_update_login                NUMBER,
12     p_request_id                       NUMBER,
13     p_program_application_id           NUMBER,
14     p_program_update_date              DATE,
15     p_program_id                       NUMBER,
16     p_create_from                      VARCHAR2,
17     p_request_header_id                NUMBER,
18     p_product_context                  VARCHAR2,
19     p_inventory_item_id                NUMBER,
20     p_prod_catg_id                     NUMBER,
21     p_product_cat_set_id               NUMBER,
22     p_product_cost                     NUMBER,
23     p_item_uom                         VARCHAR2,
24     p_requested_discount_type          VARCHAR2,
25     p_requested_discount_value         NUMBER,
26     p_cost_basis                       VARCHAR2,
27     p_max_qty                          NUMBER,
28     p_limit_qty                        NUMBER,
29     p_design_win                       VARCHAR2,
30     p_end_customer_price               NUMBER,
31     p_requested_line_amount            NUMBER,
32     p_approved_discount_type           VARCHAR2,
33     p_approved_discount_value          NUMBER,
34     p_approved_amount                  NUMBER,
35     p_total_requested_amount           NUMBER,
36     p_total_approved_amount            NUMBER,
37     p_approved_max_qty                 NUMBER,
38     p_attribute_category               VARCHAR2,
39     p_attribute1                       VARCHAR2,
40     p_attribute2                       VARCHAR2,
41     p_attribute3                       VARCHAR2,
42     p_attribute4                       VARCHAR2,
43     p_attribute5                       VARCHAR2,
44     p_attribute6                       VARCHAR2,
45     p_attribute7                       VARCHAR2,
46     p_attribute8                       VARCHAR2,
47     p_attribute9                       VARCHAR2,
48     p_attribute10                      VARCHAR2,
49     p_attribute11                      VARCHAR2,
50     p_attribute12                      VARCHAR2,
51     p_attribute13                      VARCHAR2,
52     p_attribute14                      VARCHAR2,
53     p_attribute15                      VARCHAR2,
54     p_vendor_approved_flag             VARCHAR2,
55     p_vendor_item_code                 VARCHAR2,
56     p_start_date                       DATE,
57     p_end_date                         DATE,
58     p_end_customer_price_type          VARCHAR2,
59     p_end_customer_tolerance_type      VARCHAR2,
60     p_end_customer_tolerance_value     NUMBER,
61     p_security_group_id                NUMBER,
62     p_org_id                           NUMBER,
63     p_rejection_code                   VARCHAR2,
64     p_discount_currency                VARCHAR2,
65     p_product_cost_currency            VARCHAR2,
66     p_end_customer_currency            VARCHAR2,
67     p_approved_discount_currency       VARCHAR2
68     );
69 
70 PROCEDURE Update_Row(
71     p_request_line_id                  NUMBER,
72     p_object_version_number            NUMBER,
73     p_last_update_date                 DATE,
74     p_last_updated_by                  NUMBER,
75     p_last_update_login                NUMBER,
76     p_request_id                       NUMBER,
77     p_program_application_id           NUMBER,
78     p_program_update_date              DATE,
79     p_program_id                       NUMBER,
80     p_create_from                      VARCHAR2,
81     p_request_header_id                NUMBER,
82     p_product_context                  VARCHAR2,
83     p_inventory_item_id                NUMBER,
84     p_prod_catg_id                     NUMBER,
85     p_product_cat_set_id               NUMBER,
86     p_product_cost                     NUMBER,
87     p_item_uom                         VARCHAR2,
88     p_requested_discount_type          VARCHAR2,
89     p_requested_discount_value         NUMBER,
90     p_cost_basis                       VARCHAR2,
91     p_max_qty                          NUMBER,
92     p_limit_qty                        NUMBER,
93     p_design_win                       VARCHAR2,
94     p_end_customer_price               NUMBER,
95     p_requested_line_amount            NUMBER,
96     p_approved_discount_type           VARCHAR2,
97     p_approved_discount_value          NUMBER,
98     p_approved_amount                  NUMBER,
99     p_total_requested_amount           NUMBER,
100     p_total_approved_amount            NUMBER,
101     p_approved_max_qty                 NUMBER,
102     p_attribute_category               VARCHAR2,
103     p_attribute1                       VARCHAR2,
104     p_attribute2                       VARCHAR2,
105     p_attribute3                       VARCHAR2,
106     p_attribute4                       VARCHAR2,
107     p_attribute5                       VARCHAR2,
108     p_attribute6                       VARCHAR2,
109     p_attribute7                       VARCHAR2,
110     p_attribute8                       VARCHAR2,
111     p_attribute9                       VARCHAR2,
112     p_attribute10                      VARCHAR2,
113     p_attribute11                      VARCHAR2,
114     p_attribute12                      VARCHAR2,
115     p_attribute13                      VARCHAR2,
116     p_attribute14                      VARCHAR2,
117     p_attribute15                      VARCHAR2,
118     p_vendor_approved_flag             VARCHAR2,
119     p_vendor_item_code                 VARCHAR2,
120     p_start_date                       DATE,
121     p_end_date                         DATE,
122     p_end_customer_price_type          VARCHAR2,
123     p_end_customer_tolerance_type      VARCHAR2,
124     p_end_customer_tolerance_value     NUMBER,
125     p_security_group_id                NUMBER,
126     p_org_id                           NUMBER,
127     p_rejection_code                   VARCHAR2,
128     p_discount_currency                VARCHAR2,
129     p_product_cost_currency            VARCHAR2,
130     p_end_customer_currency            VARCHAR2,
131     p_approved_discount_currency       VARCHAR2);
132 
133 END OZF_SD_REQUEST_LINES_PKG;