1 PACKAGE AP_CARD_UTILITY_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwpcuts.pls 120.7 2011/11/17 06:40:23 ppodhiya ship $ */
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 /*
41 -- Bug 13331297. P_ERROR_MESSAGE is OUT parameter now.
42 */
43
44 PROCEDURE BUILD_ACCOUNT(
45 P_CODE_COMBINATION_ID IN NUMBER,
46 P_COST_CENTER IN VARCHAR2,
47 P_ACCOUNT_SEGMENT_VALUE IN VARCHAR2,
48 P_CALLING_SEQUENCE IN VARCHAR2,
49 P_EMPLOYEE_ID IN NUMBER,
50 P_ORG_ID IN NUMBER,
51 P_CCID OUT NOCOPY VARCHAR2,
52 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
53
54 PROCEDURE WF_UTILS(
55 p_desc in VARCHAR,p_out out NOCOPY VARCHAR);
56 FUNCTION CustomValidateCostCenter(
57 p_cs_error OUT NOCOPY VARCHAR2,
58 p_CostCenterValue IN VARCHAR2,
59 p_CostCenterValid IN OUT NOCOPY BOOLEAN,
60 p_employee_id IN NUMBER) return BOOLEAN;
61 PROCEDURE ValidateCostCenter(p_costcenter IN varchar2,
62 p_cs_error OUT NOCOPY varchar2,
63 p_employee_id IN NUMBER,
64 P_ORG_ID IN NUMBER);
65 FUNCTION COSTCENTERVALID(
66 P_COST_CENTER IN EXPFEEDDISTS_COSTCENTER,
67 P_VALID OUT NOCOPY BOOLEAN,
68 P_EMPLOYEE_ID IN NUMBER,
69 P_ORG_ID IN NUMBER
70 ) RETURN BOOLEAN;
71 FUNCTION GetDependentSegment(
72 p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
73 p_chart_of_accounts_id IN NUMBER,
74 p_dependent_seg_num OUT NOCOPY NUMBER)
75 RETURN BOOLEAN ;
76 FUNCTION GetCOAofSOB(
77 P_ORG_ID IN NUMBER,
78 p_chart_of_accounts OUT NOCOPY NUMBER
79 ) RETURN BOOLEAN ;
80 FUNCTION IsPersonCwk (p_person_id IN NUMBER) return VARCHAR2;
81
82 PROCEDURE GET_SEGNUM(p_appl_id IN NUMBER,
83 p_key_flex_code IN VARCHAR2,
84 p_structure_number IN NUMBER,
85 p_flex_qual_name IN VARCHAR2,
86 p_segment_name OUT nocopy VARCHAR );
87
88
89 END AP_CARD_UTILITY_PKG;