[Home] [Help]
PACKAGE: APPS.FWK_TBX_SEED
Source
1 package fwk_tbx_seed AUTHID CURRENT_USER as
2 /* $Header: fwktbx_seeds.pls 120.2 2005/12/19 02:09:32 nigoel noship $ */
3
4 procedure insert_lookup_type(p_lookup_type varchar2,
5 p_display_name varchar2,
6 p_description varchar2);
7
8 procedure insert_lookup_code(p_lookup_type varchar2,
9 p_lookup_code varchar2,
10 p_meaning varchar2,
11 p_description varchar2,
12 p_start_date date,
13 p_end_date date);
14
15 procedure update_lookup_type(p_lookup_type varchar2,
16 p_display_name varchar2,
17 p_description varchar2);
18
19 procedure update_lookup_code(p_lookup_type varchar2,
20 p_lookup_code varchar2,
21 p_meaning varchar2,
22 p_description varchar2,
23 p_start_date date,
24 p_end_date date);
25
26 procedure delete_lookup_type(p_lookup_type varchar2);
27
28 procedure delete_lookup_code(p_lookup_type varchar2,
29 p_lookup_code varchar2);
30
31 procedure insert_employee(p_employee_id number,
32 p_title varchar2,
33 p_first_name varchar2,
34 p_middle_names varchar2,
35 p_last_name varchar2,
36 p_email_address varchar2,
37 p_manager_id number,
38 p_position_code varchar2,
39 p_salary number,
40 p_start_date date,
41 p_end_date date);
42
43 procedure insert_address(p_address_id number,
44 p_address_name varchar2,
45 p_address_line_1 varchar2,
46 p_address_line_2 varchar2,
47 p_address_line_3 varchar2,
48 p_description varchar2,
49 p_email_address varchar2,
50 p_country varchar2,
51 p_town_or_city varchar2,
52 p_postal_code varchar2,
53 p_start_date date,
54 p_end_date date,
55 p_telephone_number_1 varchar2,
56 p_telephone_number_2 varchar2,
57 p_telephone_number_3 varchar2);
58
59 procedure insert_supplier(p_supplier_id number,
60 p_name varchar2,
61 p_on_hold_flag varchar2,
62 p_start_date date,
63 p_end_date date);
64
65
66 procedure insert_supplier_site(p_supplier_site_id number,
67 p_supplier_id number,
68 p_site_name varchar2,
69 p_payment_terms_code varchar2,
70 p_carrier_code varchar2,
71 p_purchasing_site_flag varchar2,
72 p_address_id number,
73 p_start_date date,
74 p_end_date date);
75
76
77 procedure insert_item(p_item_id number,
78 p_item_description varchar2,
79 p_start_date_active date,
80 p_end_date_active date,
81 p_enabled_flag varchar2,
82 p_summary_flag varchar2,
83 p_segment1 varchar2,
84 p_segment2 varchar2,
85 p_segment3 varchar2,
86 p_segment4 varchar2,
87 p_fwkitem_id number,
88 p_fwkitem_structure_id number);
89
90
91 procedure insert_po_header(p_header_id number,
92 p_description varchar2,
93 p_status_code varchar2,
94 p_confirm_flag varchar2,
95 p_supplier_id number,
96 p_supplier_site_id number,
97 p_currency_code varchar2,
98 p_buyer_id number,
99 p_payment_terms_code varchar2,
100 p_carrier_code varchar2,
101 p_ship_to_address_id number,
102 p_bill_to_address_id number,
103 p_rate number);
104
105
106 procedure insert_po_line(p_line_id number,
107 p_header_id number,
108 p_line_number number,
109 p_item_id number,
110 p_item_description varchar2,
111 p_unit_of_measure varchar2,
112 p_quantity number,
113 p_unit_price number);
114
115
116 procedure insert_po_shipment(p_shipment_id number,
117 p_line_id number,
118 p_shipment_number number,
119 p_need_by_date date,
120 p_promise_date date,
121 p_receipt_quantity number,
122 p_order_quantity number,
123 p_ship_to_address_id number,
124 p_receipt_date date);
125
126
127 procedure insert_item_ccids(p_fwkitem_id number,
128 p_fwkitem_structure_id number,
129 p_summary_flag varchar2,
130 p_enabled_flag varchar2,
131 p_segment1 varchar2,
132 p_segment2 varchar2,
133 p_segment3 varchar2,
134 p_segment4 varchar2,
135 p_segment5 varchar2,
136 p_segment6 varchar2,
137 p_segment7 varchar2,
138 p_segment8 varchar2,
139 p_segment9 varchar2,
140 p_segment10 varchar2);
141
142 procedure insert_project_header(p_project_id number,
143 p_name varchar2,
144 p_start_date date,
145 p_completion_date date,
146 p_start_from date,
147 p_end_to date,
148 p_task_type varchar2,
149 p_text_right varchar2);
150
151 procedure insert_project_detail(p_project_id number,
152 p_top_task_id number,
153 p_task_id number,
154 p_task_number varchar2,
155 p_task_name varchar2,
156 p_start_from date,
157 p_end_to date,
158 p_task_type varchar2,
159 p_text_right varchar2);
160 end fwk_tbx_seed;