1 PACKAGE CS_SR_INTERFACE_CP AUTHID CURRENT_USER AS
2 /* $Header: cspapgs.pls 120.0.12020000.4 2013/04/26 06:35:20 bkanimoz noship $ */
3
4 PROCEDURE interface_cost_details
5 ( errbuf IN OUT NOCOPY VARCHAR2
6 , errcode IN OUT NOCOPY INTEGER
7 , p_creation_from_date IN VARCHAR2
8 , p_creation_to_date IN VARCHAR2
9 , p_project_id IN NUMBER
10 , p_project_task_id IN NUMBER
11 , p_transaction_type_id IN NUMBER
12 , p_billing_type IN VARCHAR2
13 , p_incident_id IN NUMBER
14 , p_incident_status_id IN NUMBER
15 , p_source_code IN VARCHAR2
16 , p_source_number IN NUMBER
17 , p_org_id IN NUMBER
18 , p_inv_org_id IN NUMBER
19 , p_expenditure_org_id IN NUMBER
20
21 --, p_api_version_number IN NUMBER
22 --, p_init_msg_list IN VARCHAR2
23 --, p_commit IN VARCHAR2
24 --, p_validation_level IN NUMBER
25 ) ;
26
27 PROCEDURE Validate_transaction(
28 p_project_id IN NUMBER
29 , p_task_id IN NUMBER
30 , p_ei_date IN DATE
31 , p_expenditure_type IN VARCHAR2
32 , p_non_labor_resource IN VARCHAR2
33 , p_person_id IN NUMBER
34 , p_quantity IN NUMBER DEFAULT NULL
35 , p_denom_currency_code IN VARCHAR2 DEFAULT NULL
36 , p_acct_currency_code IN VARCHAR2 DEFAULT NULL
37 , p_denom_raw_cost IN NUMBER DEFAULT NULL
38 , p_acct_raw_cost IN NUMBER DEFAULT NULL
39 , p_acct_rate_type IN VARCHAR2 DEFAULT NULL
40 , p_acct_rate_date IN DATE DEFAULT NULL
41 , p_acct_exchange_rate IN NUMBER DEFAULT NULL
42 , p_transfer_ei IN NUMBER DEFAULT NULL
43 , p_incurred_by_org_id IN NUMBER DEFAULT NULL
44 , p_nl_resource_org_id IN NUMBER DEFAULT NULL
45 , p_transaction_source IN VARCHAR2 DEFAULT NULL
46 , p_calling_module IN VARCHAR2 DEFAULT NULL
47 , p_vendor_id IN NUMBER DEFAULT NULL
48 , p_entered_by_user_id IN NUMBER DEFAULT NULL
49 , p_attribute_category IN VARCHAR2 DEFAULT NULL
50 , p_attribute1 IN VARCHAR2 DEFAULT NULL
51 , p_attribute2 IN VARCHAR2 DEFAULT NULL
52 , p_attribute3 IN VARCHAR2 DEFAULT NULL
53 , p_attribute4 IN VARCHAR2 DEFAULT NULL
54 , p_attribute5 IN VARCHAR2 DEFAULT NULL
55 , p_attribute6 IN VARCHAR2 DEFAULT NULL
56 , p_attribute7 IN VARCHAR2 DEFAULT NULL
57 , p_attribute8 IN VARCHAR2 DEFAULT NULL
58 , p_attribute9 IN VARCHAR2 DEFAULT NULL
59 , p_attribute10 IN VARCHAR2 DEFAULT NULL
60 , p_attribute11 IN VARCHAR2 DEFAULT NULL
61 , p_attribute12 IN VARCHAR2 DEFAULT NULL
62 , p_attribute13 IN VARCHAR2 DEFAULT NULL
63 , p_attribute14 IN VARCHAR2 DEFAULT NULL
64 , p_attribute15 IN VARCHAR2 DEFAULT NULL
65 , p_msg_application IN OUT NOCOPY VARCHAR2
66 , p_msg_type OUT NOCOPY VARCHAR2
67 , p_msg_token1 OUT NOCOPY VARCHAR2
68 , p_msg_token2 OUT NOCOPY VARCHAR2
69 , p_msg_token3 OUT NOCOPY VARCHAR2
70 , p_msg_count OUT NOCOPY NUMBER
71 , p_msg_data OUT NOCOPY VARCHAR2
72 , p_billable_flag OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE update_interface_status(P_transaction_source IN VARCHAR2,
76 P_batch IN VARCHAR2,
77 P_user_id IN NUMBER,
78 P_xface_id IN NUMBER);
79
80
81 End CS_SR_INTERFACE_CP;