1 PACKAGE IGC_CC_COMMON_UTILS_PVT AS
2 /*$Header: IGCUTILS.pls 120.1.12010000.2 2008/08/29 13:02:11 schakkin ship $*/
3
4 /*=======================================================================+
5 | PROCEDURE Get_Header_Desc
6 | |
7 | Note : This procedure is designed to get the descriptions of all the |
8 | coded fields stored at the header level in igc_cc_headers |
9 | It is used by forms like IGCCSUMM to get the descriptions |
10 | of the field to be displayed to the user. |
11 | |
12 | |
13 | Parameters : |
14 | |
15 | Standard header params for Public Procedures. |
16 | |
17 | p_api_version Version number for API to run |
18 | p_init_msg_list Message stack to be initialized flag |
19 | p_commit Is work to be commited here flag |
20 | p_validation_level Validation Level to be performed |
21 | p_return_status Status returned from Procedure |
22 | p_msg_count Number of messages on stack returned |
23 | p_msg_data Message text information returned |
24 | |
25 | Parameters for Procedure to process properly. |
26 | p_cc_header_id igc_cc_headers.cc_header_id |
27 | |
28 +=======================================================================*/
29 PROCEDURE Get_Header_Desc
30 (
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35 p_return_status OUT NOCOPY VARCHAR2,
36 p_msg_count OUT NOCOPY NUMBER,
37 p_msg_data OUT NOCOPY VARCHAR2,
38
39 p_cc_header_id IN NUMBER,
40 p_type_desc OUT NOCOPY VARCHAR2,
41 p_state_desc OUT NOCOPY VARCHAR2,
42 p_apprvl_status_desc OUT NOCOPY VARCHAR2,
43 p_ctrl_status_desc OUT NOCOPY VARCHAR2,
44 p_cc_owner_name OUT NOCOPY VARCHAR2,
45 p_cc_preparer_name OUT NOCOPY VARCHAR2,
46 p_cc_access_level OUT NOCOPY VARCHAR2,
47 p_vendor_name OUT NOCOPY VARCHAR2,
48 p_bill_to_location OUT NOCOPY VARCHAR2,
49 p_vendor_site_code OUT NOCOPY VARCHAR2,
50 p_vendor_contact OUT NOCOPY VARCHAR2,
51 p_vendor_number OUT NOCOPY VARCHAR2,
52 p_term_name OUT NOCOPY VARCHAR2,
53 p_parent_cc_num OUT NOCOPY VARCHAR2,
54 p_vendor_hold_flag OUT NOCOPY VARCHAR2
55 );
56
57
58 /*=======================================================================+
59 | FUNCTION Date_Is_Valid
60 | |
61 | Note : This procedure is designed to check whether the fiscal year of |
62 | the invoice and that of the payment forecast line of a CC are |
63 | the same or not. |
64 | |
65 | |
66 | Parameters : |
67 | x_gl_date GL Date of the invoice |
68 | x_po_header_id |
69 | x_po_line_id
70 | x_po_dist_num |
71 | x_shipment_num |
72 +=======================================================================*/
73
74 FUNCTION DATE_IS_VALID(x_form_name VARCHAR2,
75 x_gl_date gl_period_statuses.start_date%type,
76 x_po_header_id po_headers_all.po_header_id%type,
77 x_po_line_id po_lines_all.po_line_id%type,
78 x_line_location_id po_line_locations_all.line_location_id%type,
79 x_po_distribution_id po_distributions_all.po_distribution_id%type,
80 x_po_dist_num po_distributions_all.distribution_num%type,
81 x_shipment_num po_line_locations_all.shipment_num%type,
82 x_line_num po_lines_all.line_num%type)
83 RETURN BOOLEAN;
84
85
86
87 /*=======================================================================+
88 | FUNCTION XML_REPORT_ENABLED
89 | |
90 | Note : This function is designed to decide if the xml report(s) is |
91 | to be triggered or not. Presently it returns true. In future |
92 | the function can be modified to incorporate profile options |
93 and return true/false based on conditions. |
94 +=======================================================================*/
95
96 FUNCTION XML_REPORT_ENABLED
97
98 RETURN BOOLEAN;
99
100
101
102 /*=======================================================================+
103 | PROCEDURE GET_XML_LAYOUT_INFO
104 | |
105 | Note : This procedure is designed to get layout information of the |
106 | xml report that is to be generated. |
107 | |
108 | Parameters : |
109 | |
110 | p_lang Language, Takes the default value |
111 | when no value is obtained |
112 | p_terr Territory, Takes the default value |
113 | when no value is obtained |
114 | p_lob_code BiPubllisher Code for the XML Report |
115 | p_application_short_name Short Name of the Application |
116 | p_template_code Template Code for the XML Report |
117 +=======================================================================*/
118
119 PROCEDURE GET_XML_LAYOUT_INFO
120 (
121 p_lang IN OUT NOCOPY VARCHAR2,
122 p_terr IN OUT NOCOPY VARCHAR2,
123 p_lob_code IN VARCHAR2,
124 p_application_short_name IN VARCHAR2,
125 p_template_code IN VARCHAR2
126 );
127
128
129
130
131 END IGC_CC_COMMON_UTILS_PVT;