DBA Data[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;