1 PACKAGE AP_CARD_UTILITY_PKG AS
2 /* $Header: apwpcuts.pls 120.4 2006/10/26 15:31:34 pranpaul noship $ */
3
4 C_ApplicationID CONSTANT NUMBER := 601;
5 SUBTYPE expFeedDists_costCenter IS AP_EXPENSE_FEED_DISTS.cost_center%TYPE;
6
7 -------------------------------------------------------------------------------
8
9 FUNCTION get_combination_id(p_application_short_name IN VARCHAR2,
10 p_key_flex_code IN VARCHAR2,
11 p_structure_number IN NUMBER,
12 p_validation_date IN DATE,
13 p_n_segments IN NUMBER,
14 p_segments IN fnd_flex_ext.SegmentArray,
15 p_concatSegments IN VARCHAR2,
16 p_combination_id OUT NOCOPY NUMBER,
17 p_return_error_message IN OUT NOCOPY VARCHAR2)
18 RETURN BOOLEAN;
19
20 -------------------------------------------------------------------------------
21 FUNCTION validateSession(p_func IN varchar2 default NULL,
22 p_commit IN boolean default TRUE,
23 p_update IN boolean default TRUE)
24 RETURN BOOLEAN;
25
26 -------------------------------------------------------------------------------
27 PROCEDURE JumpIntoFunction(p_id IN NUMBER,
28 p_mode IN VARCHAR2,
29 p_url OUT NOCOPY VARCHAR2);
30 -------------------------------------------------------------------------------
31
32 PROCEDURE ICXSetOrgContext(p_session_id IN VARCHAR2,
33 p_org_id IN VARCHAR2);
34
35 -------------------------------------------------------------------------------
36 /*The following procedures have been added for PCARD project.
37 Moved the Validate Cost Center procedure and all its dependent
38 procedure to AP packages*/
39
40 PROCEDURE BUILD_ACCOUNT(
41 P_CODE_COMBINATION_ID IN NUMBER,
42 P_COST_CENTER IN VARCHAR2,
43 P_ACCOUNT_SEGMENT_VALUE IN VARCHAR2,
44 P_ERROR_MESSAGE IN VARCHAR2,
45 P_CALLING_SEQUENCE IN VARCHAR2,
46 P_EMPLOYEE_ID IN NUMBER,
47 P_CCID OUT NOCOPY VARCHAR);
48 PROCEDURE WF_UTILS(
49 p_desc in VARCHAR,p_out out NOCOPY VARCHAR);
50 FUNCTION CustomValidateCostCenter(
51 p_cs_error OUT NOCOPY VARCHAR2,
52 p_CostCenterValue IN VARCHAR2,
53 p_CostCenterValid IN OUT NOCOPY BOOLEAN,
54 p_employee_id IN NUMBER) return BOOLEAN;
55 PROCEDURE ValidateCostCenter(p_costcenter IN varchar2,
56 p_cs_error OUT NOCOPY varchar2,
57 p_employee_id IN NUMBER);
58 FUNCTION COSTCENTERVALID(
59 P_COST_CENTER IN EXPFEEDDISTS_COSTCENTER,
60 P_VALID OUT NOCOPY BOOLEAN,
61 P_EMPLOYEE_ID IN NUMBER
62 ) RETURN BOOLEAN;
63 FUNCTION GetDependentSegment(
64 p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
65 p_chart_of_accounts_id IN NUMBER,
66 p_dependent_seg_num OUT NOCOPY NUMBER)
67 RETURN BOOLEAN ;
68 FUNCTION GetCOAofSOB(
69 p_chart_of_accounts OUT NOCOPY NUMBER
70 ) RETURN BOOLEAN ;
71 FUNCTION IsPersonCwk (p_person_id IN NUMBER) return VARCHAR2;
72
73
74 END AP_CARD_UTILITY_PKG;