[Home] [Help]
PACKAGE: APPS.IEX_CHECKLIST_UTILITY
Source
1 PACKAGE IEX_CHECKLIST_UTILITY AUTHID CURRENT_USER AS
2 /* $Header: iexvchks.pls 120.1.12010000.2 2009/07/31 09:08:41 pnaveenk ship $ */
3
4 FUNCTION GET_GO_TO_TASK_IMAGE_NAME(
5 p_checklist_item_name IN VARCHAR2,
6 p_checklist_item_type IN VARCHAR2,
7 p_checklist_item_status IN VARCHAR2) RETURN VARCHAR2;
8
9 FUNCTION GET_STATUS_IMAGE_NAME(
10 p_checklist_item_name IN VARCHAR2,
11 p_checklist_item_type IN VARCHAR2,
12 p_checklist_item_status IN VARCHAR2) RETURN VARCHAR2;
13
14 FUNCTION GET_RANGE_FROM_VALUE(
15 p_score_comp_type_id IN NUMBER,
16 p_lookup_code IN VARCHAR2) RETURN NUMBER;
17
18 FUNCTION GET_RANGE_TO_VALUE(
19 p_score_comp_type_id IN NUMBER,
20 p_lookup_code IN VARCHAR2) RETURN NUMBER;
21
22 PROCEDURE UPDATE_METRIC_RATING(
23 p_score_comp_type_id IN NUMBER,
24 p_low_from IN NUMBER,
25 p_low_to IN NUMBER,
26 p_medium_from IN NUMBER,
27 p_medium_to IN NUMBER,
28 p_high_from IN NUMBER,
29 p_high_to IN NUMBER);
30
31 PROCEDURE UPDATE_CHECKLIST_ITEM(
32 p_checklist_item_id IN NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE CHANGE_LEASING_SETUP(
36 p_leasing_enabled IN VARCHAR2,
37 x_return_status OUT NOCOPY VARCHAR2);
38
39 PROCEDURE CHANGE_LOAN_SETUP(
40 p_loan_enabled IN VARCHAR2,
41 x_return_status OUT NOCOPY VARCHAR2);
42
43 PROCEDURE CHANGE_BUSINESS_LEVEL(
44 p_business_level IN VARCHAR2,
45 p_promise_enabled IN VARCHAR2,
46 p_collections_methods IN VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2);
48
49 PROCEDURE UPDATE_CHECKLIST_ITEM_BY_NAME(
50 p_checklist_item_name IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2);
52
53 -- Added for bug 8708271 pnaveenk multi level strategy
54
55 PROCEDURE CHANGE_MULTIPLE_LEVEL(
56 p_account_level IN VARCHAR2,
57 p_billto_level IN VARCHAR2,
58 p_customer_level IN VARCHAR2,
59 p_delinquency_level IN VARCHAR2,
60 p_override_party_level IN VARCHAR2,
61 p_ou_running_level IN VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2);
63
64 PROCEDURE UPDATE_MLSETUP;
65
66 -- end for bug 8708271
67
68 END;