[Home] [Help]
PACKAGE: APPS.POA_SUPPERF_POPULATE_PKG
Source
1 PACKAGE POA_SUPPERF_POPULATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: POASPPPS.pls 115.3 2003/12/09 12:12:17 bthammin ship $: */
3
4 PROCEDURE populate_fact_table(p_start_date IN DATE, p_end_date IN DATE);
5 PROCEDURE delete_row(p_line_location_id NUMBER);
6 PROCEDURE insert_row(p_shipment_id NUMBER,
7 p_ship_to_location_id NUMBER,
8 p_ship_to_organization_id NUMBER,
9 p_org_id NUMBER,
10 p_item_id NUMBER,
11 p_category_id NUMBER,
12 p_supplier_id NUMBER,
13 p_supplier_site_id NUMBER,
14 p_buyer_id NUMBER,
15 p_date_dimension DATE,
16 p_quantity_purchased NUMBER,
17 p_purchase_price NUMBER,
18 p_primary_uom VARCHAR2,
19 p_currency_code VARCHAR2,
20 p_rate_type VARCHAR2,
21 p_rate_date DATE,
22 p_rate NUMBER,
23 p_quantity_ordered NUMBER,
24 p_quantity_received NUMBER,
25 p_quantity_rejected NUMBER,
26 p_amount NUMBER,
27 p_number_of_receipts NUMBER,
28 p_quantity_received_late NUMBER,
29 p_quantity_received_early NUMBER,
30 p_quantity_past_due NUMBER,
31 p_first_receipt_date DATE,
32 p_shipment_expected_date DATE,
33 p_month_bucket DATE,
34 p_quarter_bucket DATE,
35 p_year_bucket DATE,
36 p_created_by NUMBER,
37 p_creation_date DATE,
38 p_last_update_date DATE,
39 p_last_updated_by NUMBER,
40 p_last_update_login NUMBER,
41 p_request_id NUMBER,
42 p_program_application_id NUMBER,
43 p_program_id NUMBER,
44 p_program_update_date DATE);
45
46 END POA_SUPPERF_POPULATE_PKG;
47