DBA Data[Home] [Help]

APPS.PO_COMPLEX_WORK_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 61: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;

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;

Line 62: l_style_desc PO_DOC_STYLE_HEADERS.style_description%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;

Line 63: l_style_type PO_DOC_STYLE_HEADERS.style_type%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;

Line 64: l_status PO_DOC_STYLE_HEADERS.status%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:

Line 65: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_flag%TYPE;

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;

Line 66: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%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;

Line 67: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%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;
71:

Line 186: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;

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;

Line 187: l_style_desc PO_DOC_STYLE_HEADERS.style_description%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;

Line 188: l_style_type PO_DOC_STYLE_HEADERS.style_type%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;

Line 189: l_status PO_DOC_STYLE_HEADERS.status%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;

Line 190: l_advances_flag PO_DOC_STYLE_HEADERS.advances_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;

Line 191: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_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;

Line 192: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_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;

Line 193: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%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:

Line 194: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%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:
198: l_is_complex_style BOOLEAN;

Line 195: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_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;
199:

Line 196: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%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:
200: BEGIN

Line 282: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;

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;

Line 283: l_style_desc PO_DOC_STYLE_HEADERS.style_description%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;

Line 284: l_style_type PO_DOC_STYLE_HEADERS.style_type%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;

Line 285: l_status PO_DOC_STYLE_HEADERS.status%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;

Line 286: l_advances_flag PO_DOC_STYLE_HEADERS.advances_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;

Line 287: l_retainage_flag PO_DOC_STYLE_HEADERS.retainage_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;

Line 288: l_price_breaks_flag PO_DOC_STYLE_HEADERS.price_breaks_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;

Line 289: l_price_diffs_flag PO_DOC_STYLE_HEADERS.price_differentials_flag%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:

Line 290: l_complex_work_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%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:
294: l_is_financing_style BOOLEAN;

Line 291: l_financing_flag PO_DOC_STYLE_HEADERS.contract_financing_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;
295:

Line 292: l_line_type_allowed PO_DOC_STYLE_HEADERS.line_type_allowed%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:
296: BEGIN