1 PACKAGE cst_mohRules_pub AUTHID CURRENT_USER AS
2 /* $Header: CSTMOHRS.pls 115.3 2002/11/08 23:01:54 awwang ship $*/
3
4 PROCEDURE insert_row_moh(
5 p_rule_id IN NUMBER,
6 p_last_update_date IN DATE,
7 p_creation_date IN DATE,
8 p_last_updated_by IN NUMBER,
9 p_created_by IN NUMBER,
10 p_organization_id IN NUMBER,
11 p_earn_moh IN NUMBER,
12 p_transaction_type IN NUMBER,
13 p_selection_criteria IN NUMBER DEFAULT NULL,
14 p_category_id IN NUMBER DEFAULT NULL,
15 p_item_from IN NUMBER DEFAULT NULL,
16 p_item_to IN NUMBER DEFAULT NULL,
17 p_item_type IN NUMBER,
18 p_ship_from_org IN NUMBER DEFAULT NULL,
19 p_cost_type_id IN NUMBER,
20 err_code OUT NOCOPY NUMBER,
21 err_msg OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE update_row_moh(
25 p_rule_id IN NUMBER,
26 p_last_update_date IN DATE,
27 p_last_updated_by IN NUMBER,
28 p_earn_moh IN NUMBER,
29 p_transaction_type IN NUMBER,
30 p_selection_criteria IN NUMBER DEFAULT NULL,
31 p_category_id IN NUMBER DEFAULT NULL,
32 p_item_from IN NUMBER DEFAULT NULL,
33 p_item_to IN NUMBER DEFAULT NULL,
34 p_item_type IN NUMBER,
35 p_ship_from_org IN NUMBER DEFAULT NULL,
36 p_cost_type_id IN NUMBER,
37 err_code OUT NOCOPY NUMBER,
38 err_msg OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE delete_row_moh(
42 p_rule_id IN NUMBER,
43 err_code OUT NOCOPY NUMBER,
44 err_msg OUT NOCOPY VARCHAR2
45 );
46
47
48 PROCEDURE apply_moh(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE,
52 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53 p_organization_id IN NUMBER,
54 p_earn_moh OUT NOCOPY NUMBER,
55 p_txn_id IN NUMBER,
56 p_item_id IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62
63 END;