[Home] [Help]
PACKAGE: APPS.IEX_CHECKLIST_UTILITY
Source
1 PACKAGE IEX_CHECKLIST_UTILITY AS
2 /* $Header: iexvchks.pls 120.1 2005/08/31 17:37:21 jypark noship $ */
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 END;