[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;