1 PACKAGE PO_CORE_S3 AUTHID CURRENT_USER AS
2 /* $Header: POXCOC3S.pls 120.2.12020000.5 2013/03/22 11:20:03 smvinod ship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: PO_CORE_S3
6
7 DESCRIPTION:
8
9 CLIENT/SERVER: Server
10
11 HISTORY:
12
13 LIBRARY NAME:
14
15 OWNER:
16
17 PROCEDURE NAMES: get_window_org_sob
18
19 FUNCTION NAMES : get_umb_prog_name, get_fon_name
20
21 ===========================================================================*/
22
23 /*===========================================================================
24 PROCEDURE NAME: get_window_org_sob
25
26 DESCRIPTION: Based on whether the calling form supports true
27 multi-org (e.g. the Receiving forms in 10SC) or
28 is single org (e.g. Purchase Orders), retrieve
29 either the appropriate menu org code or sob short
30 name.
31
32
33 PARAMETERS:
34
35 DESIGN REFERENCES:
36
37 ALGORITHM: If the form is true multiorg, find the org code
38 associated with the MANUFACTURING_ORG_ID profile
39 option setting.
40
41 If the form is single-org, but it is operating as
42 multi-org using the 10.6 org_id column, then return
43 the org code associated with the org_id in
44 purchasing system parameters.
45
46 If the form is single-org and is being run in a
47 single-org context, find the set of books short name
48 associated with the sob specified in financials
49 system parameters.
50
51 NOTES:
52
53 OPEN ISSUES:
54
55 CLOSED ISSUES:
56
57 CHANGE HISTORY: Created 01-NOV-95 LBROADBE
58 ===========================================================================*/
59 PROCEDURE get_window_org_sob(x_multi_org_form_flag IN OUT NOCOPY BOOLEAN,
60 x_org_sob_id IN OUT NOCOPY NUMBER,
61 x_org_sob_name IN OUT NOCOPY VARCHAR2);
62
63 /*===========================================================================
64 FUNCTION NAME: get_umb_prog_name
65
66 DESCRIPTION: Based on the umbrella program id get the umbrella program name
67
68 PARAMETERS: Umbrella Program id
69
70 ALGORITHM: Fetch the value by querying PON_UMBRELLA_PROGRAMS table
71
72 CHANGE HISTORY: Created 07-OCT-11 PAMANDAV
73 ===========================================================================*/
74
75 FUNCTION get_umb_prog_name(
76 p_umb_prog_id IN NUMBER )
77 RETURN VARCHAR2;
78
79
80 /*===========================================================================
81 FUNCTION NAME: get_fon_name
82
83 DESCRIPTION: Based on the FON reference id get the FON name
84
85 PARAMETERS: FON reference id
86
87 ALGORITHM: Fetch the value by querying PON_AUCTION_HEADERS_ALL table
88
89 CHANGE HISTORY: Created 07-OCT-11 PAMANDAV
90 ===========================================================================*/
91
92 FUNCTION get_fon_name(
93 p_fon_ref_id IN NUMBER )
94 RETURN VARCHAR2;
95
96 /*===========================================================================
97 FUNCTION NAME: get_umb_prog_id
98
99 DESCRIPTION: Based on the header id get the umbrella program id
100
101 PARAMETERS: document header id
102
103 ALGORITHM: Fetch the value by querying PO_HEADERS_ALL table
104
105 CHANGE HISTORY: Created 11-OCT-11 PAMANDAV
106 ===========================================================================*/
107 FUNCTION get_umb_prog_id(
108 p_doc_header_id IN NUMBER )
109 RETURN NUMBER;
110
111 -- Sunset memo Project
112 -- start
113 -- Creating plsql table for Sunset memo : Contingency contract
114 TYPE g_object_special_contract_cr IS RECORD
115 (
116 FPDS_REPORTING_METHOD PO_CLM_CARS.REPORTING_METHOD%TYPE,
117 FPDS_REASON PO_CLM_CARS.REL_WITHOUT_RPT_REASON%TYPE,
118 EXEMPTION_REASON PO_CLM_CARS.EXEMPTION_REASON%TYPE,
119 CCR_EXCEPTION_REASON VARCHAR2(100),
120 BYPASS_SGD_GENERATION VARCHAR2(1)
121 );
122 -- Creating table of records
123 TYPE object_po_special_contract_tbl IS TABLE OF g_object_special_contract_cr INDEX BY VARCHAR2(50);
124
125 -- Declaring global varaible.
126 g_object_special_contract_tbl object_po_special_contract_tbl ;
127
128 -- Procedure used to get values from global table of type object_po_special_contract_tbl
129 PROCEDURE get_spec_cont_type_rules(
130 specialContractType IN VARCHAR2,
131 po_spec_cont_type_rules_tbl OUT NOCOPY PO_TBL_VARCHAR100 );
132
133 -- Function used to fetch values CCR_EXCEPTION_REASON from global table of type object_po_special_contract_tbl
134 FUNCTION get_ccr_exception_reason(
135 specialContractType IN VARCHAR2)
136 RETURN VARCHAR2;
137
138 -- Function used to fetch values BYPASS_SGD_GENERATION from global table of type object_po_special_contract_tbl
139 FUNCTION get_bypass_sgd_generation_flag(
140 specialContractType IN VARCHAR2)
141 RETURN VARCHAR2;
142
143 FUNCTION get_fiscal_year_from_ccid(p_ledger_id IN NUMBER,
144 ccid IN NUMBER)
145 RETURN NUMBER;
146
147 FUNCTION get_ccid_cancellation_date(p_ledger_id IN NUMBER,
148 ccid IN NUMBER)
149 RETURN DATE;
150
151 -- END Sunset Memo Project
152 -- Payment Instruction
153 PROCEDURE generate_payment_sequence (p_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE);
154
155 --<Event Based Delivery Project Start>
156 --Function to add period to a date.
157 FUNCTION ADD_PERIOD (p_old_date IN DATE,
158 p_period IN NUMBER,
159 p_period_uom IN VARCHAR2)
160 RETURN DATE;
161 --<Event Based Delivery Project End>
162
163 FUNCTION is_non_annual_fund(ccid IN po_distributions_all.CODE_COMBINATION_ID%TYPE,
164 p_ledger_id IN NUMBER)
165 RETURN VARCHAR2;
166
167 FUNCTION get_fiscal_year(p_date IN DATE,
168 p_set_of_books_id IN NUMBER)
169 RETURN NUMBER;
170
171 -- PAR Approval
172 PROCEDURE get_par_header_disp_status (p_draft_id IN NUMBER,
173 p_po_header_id IN NUMBER,
174 x_status_disp OUT NOCOPY VARCHAR2);
175
176 END PO_CORE_S3;