57:
58: d_progress NUMBER;
59: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.get_payment_style_settings';
60:
61: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
62: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
63: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
64: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
58: d_progress NUMBER;
59: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.get_payment_style_settings';
60:
61: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
62: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
63: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
64: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
66: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
59: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.get_payment_style_settings';
60:
61: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
62: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
63: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
64: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
66: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
67: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
60:
61: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
62: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
63: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
64: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
66: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
67: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
68:
61: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
62: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
63: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
64: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
66: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
67: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
68:
69: TYPE t_payment_type_tbl IS TABLE OF PO_STYLE_ENABLED_PAY_ITEMS.pay_item_type%TYPE;
62: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
63: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
64: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
66: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
67: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
68:
69: TYPE t_payment_type_tbl IS TABLE OF PO_STYLE_ENABLED_PAY_ITEMS.pay_item_type%TYPE;
70: l_payment_types_tbl t_payment_type_tbl;
63: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
64: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
66: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
67: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
68:
69: TYPE t_payment_type_tbl IS TABLE OF PO_STYLE_ENABLED_PAY_ITEMS.pay_item_type%TYPE;
70: l_payment_types_tbl t_payment_type_tbl;
71:
182:
183: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_complex_work_style';
184: d_progress NUMBER;
185:
186: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
187: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
188: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
183: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_complex_work_style';
184: d_progress NUMBER;
185:
186: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
187: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
188: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
184: d_progress NUMBER;
185:
186: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
187: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
188: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
185:
186: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
187: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
188: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
186: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
187: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
188: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
187: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
188: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
195: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
188: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
195: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
196: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
189: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
195: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
196: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
197:
190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
195: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
196: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
197:
198: l_is_complex_style BOOLEAN;
191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
195: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
196: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
197:
198: l_is_complex_style BOOLEAN;
199:
192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
195: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
196: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
197:
198: l_is_complex_style BOOLEAN;
199:
200: BEGIN
278:
279: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_financing_payment_style';
280: d_progress NUMBER;
281:
282: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
283: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
284: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
279: d_module VARCHAR2(70) := 'po.plsql.PO_COMPLEX_WORK_PVT.is_financing_payment_style';
280: d_progress NUMBER;
281:
282: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
283: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
284: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
280: d_progress NUMBER;
281:
282: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
283: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
284: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
281:
282: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
283: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
284: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
282: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
283: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
284: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
283: l_style_desc PO_DOC_STYLE_HEADERS.style_description%TYPE;
284: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
291: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
284: l_style_type PO_DOC_STYLE_HEADERS.style_type%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
291: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
292: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
285: l_status PO_DOC_STYLE_HEADERS.status%TYPE;
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
291: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
292: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
293:
286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_flag%TYPE;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
291: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
292: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
293:
294: l_is_financing_style BOOLEAN;
287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_flag%TYPE;
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
291: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
292: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
293:
294: l_is_financing_style BOOLEAN;
295:
288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;
289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%TYPE;
290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
291: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_flag%TYPE;
292: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%TYPE;
293:
294: l_is_financing_style BOOLEAN;
295:
296: BEGIN