1 PACKAGE FTE_PTRACKING AUTHID CURRENT_USER AS
2 /* $Header: FTEPTRKS.pls 115.1 2002/10/09 21:05:53 dmlewis noship $ */
3
4
5 --===================
6 -- TYPES
7 --===================
8
9 type KeyTable is TABLE OF VARCHAR2(64) INDEX BY BINARY_INTEGER;
10 type ValueTable is TABLE OF VARCHAR2(64) INDEX BY BINARY_INTEGER;
11 type TypeTable is TABLE OF VARCHAR2(64) INDEX BY BINARY_INTEGER;
12
13 --===================
14 -- PROCEDURES
15 --===================
16
17 PROCEDURE Punchout(
18 p_application_id IN NUMBER,
19 p_org_id IN NUMBER,
20 p_carrier_id IN NUMBER,
21 p_tracking_event IN VARCHAR2,
22 p_granularity IN NUMBER,
23 p_param_list IN VARCHAR2,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_err_msg OUT NOCOPY VARCHAR2,
26 x_form_output OUT NOCOPY VARCHAR2);
27
28 -- Punchout takes in an application, organization, carrier, tracking event, granularity
29 -- and a list of key parameters from the user in order to create a form to punch out to a
30 -- remote carrier's tracking site. This differs from the other overloaded call in that the
31 -- key/value pairs are represented in a single long VARCHAR2.
32
33 PROCEDURE Punchout(
34 p_application_id IN NUMBER,
35 p_org_id IN NUMBER,
36 p_carrier_id IN NUMBER,
37 p_tracking_event IN VARCHAR2,
38 p_granularity IN NUMBER,
39 p_key_list IN KeyTable,
40 p_value_list IN ValueTable,
41 p_type_list IN TypeTable,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_err_msg OUT NOCOPY VARCHAR2,
44 x_form_output OUT NOCOPY VARCHAR2);
45
46 -- Punchout takes in an application, organization, carrier, tracking event, granularity
47 -- and a list of key parameters from the user in order to create a form to punch out to a
48 -- remote carrier's tracking site. This differs from the other overloaded call in that the
49 -- key/value pairs are represented in two PL/SQL tables.
50
51
52 PROCEDURE Validate(
53 p_application_id IN NUMBER,
54 p_org_id IN NUMBER,
55 p_carrier_id IN NUMBER,
56 p_tracking_event IN VARCHAR2,
57 p_granularity IN NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_page_id OUT NOCOPY NUMBER,
60 x_base_url OUT NOCOPY VARCHAR2,
61 x_request_method OUT NOCOPY VARCHAR2,
62 x_name OUT NOCOPY VARCHAR2,
63 x_description OUT NOCOPY VARCHAR2,
64 x_token OUT NOCOPY VARCHAR2
65 );
66
67 -- this procedure returns a stored page if this granularity, tracking_event and
68 -- application combination is valid and includes information for this carrier and organization.
69
70
71
72
73
74 PROCEDURE FindTokenValue(
75 p_application_id IN NUMBER,
76 p_token_name IN VARCHAR2,
77 p_param_list IN VARCHAR2,
78 x_token_value OUT NOCOPY VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_err_msg OUT NOCOPY VARCHAR2
81 );
82
83
84 -- this procedure takes a token name, application ID and a standard parameter list and
85 -- returns the corresponding calculated token value
86
87 END FTE_PTRACKING;