DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_TBL_VARCHAR240

Line 264: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,

260: PROCEDURE derive_contract_type
261: (
262: p_key IN po_session_gt.key%TYPE,
263: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
264: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,
265: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
266: );
267:
268: PROCEDURE derive_cost_constraint

Line 265: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240

261: (
262: p_key IN po_session_gt.key%TYPE,
263: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
264: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,
265: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
266: );
267:
268: PROCEDURE derive_cost_constraint
269: (

Line 272: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,

268: PROCEDURE derive_cost_constraint
269: (
270: p_key IN po_session_gt.key%TYPE,
271: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
272: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,
273: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
274: );
275:
276: PROCEDURE derive_clm_idc_type

Line 280: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,

276: PROCEDURE derive_clm_idc_type
277: (
278: p_key IN po_session_gt.key%TYPE,
279: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
280: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,
281: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
282: );
283:
284: PROCEDURE derive_clm_base_line_num

Line 281: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240

277: (
278: p_key IN po_session_gt.key%TYPE,
279: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
280: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,
281: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
282: );
283:
284: PROCEDURE derive_clm_base_line_num
285: (

Line 288: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,

284: PROCEDURE derive_clm_base_line_num
285: (
286: p_key IN po_session_gt.key%TYPE,
287: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
288: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
289: p_intf_line_id_tbl IN PO_TBL_NUMBER,
290: p_intf_header_id_tbl IN PO_TBL_NUMBER,
291: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
292: p_clm_option_indicator IN PO_TBL_VARCHAR1,

Line 300: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,

296: PROCEDURE derive_from_line_id
297: (
298: p_key IN po_session_gt.key%TYPE,
299: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
300: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
301: p_from_header_id_tbl IN PO_TBL_NUMBER,
302: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
303: );
304:

Line 309: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,

305: PROCEDURE derive_from_header_id
306: (
307: p_key IN po_session_gt.key%TYPE,
308: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
309: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,
310: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
311: );
312:
313: PROCEDURE default_clm_option_indicator

Line 9105: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,

9101: PROCEDURE derive_contract_type
9102: (
9103: p_key IN po_session_gt.key%TYPE,
9104: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9105: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,
9106: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
9107: ) IS
9108:
9109: d_api_name CONSTANT VARCHAR2(30) := 'derive_contract_type';

Line 9106: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240

9102: (
9103: p_key IN po_session_gt.key%TYPE,
9104: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9105: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,
9106: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
9107: ) IS
9108:
9109: d_api_name CONSTANT VARCHAR2(30) := 'derive_contract_type';
9110: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9115: l_result_tbl PO_TBL_VARCHAR240;

9111: d_position NUMBER;
9112:
9113: -- tables to store the derived result
9114: l_index_tbl PO_TBL_NUMBER;
9115: l_result_tbl PO_TBL_VARCHAR240;
9116: BEGIN
9117: d_position := 0;
9118:
9119: IF (PO_LOG.d_proc) THEN

Line 9176: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,

9172: PROCEDURE derive_cost_constraint
9173: (
9174: p_key IN po_session_gt.key%TYPE,
9175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9176: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,
9177: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
9178: ) IS
9179:
9180: d_api_name CONSTANT VARCHAR2(30) := 'derive_cost_constraint';

Line 9186: l_result_tbl PO_TBL_VARCHAR240;

9182: d_position NUMBER;
9183:
9184: -- tables to store the derived result
9185: l_index_tbl PO_TBL_NUMBER;
9186: l_result_tbl PO_TBL_VARCHAR240;
9187: BEGIN
9188: d_position := 0;
9189:
9190: IF (PO_LOG.d_proc) THEN

Line 9246: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,

9242: PROCEDURE derive_clm_idc_type
9243: (
9244: p_key IN po_session_gt.key%TYPE,
9245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9246: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,
9247: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
9248: ) IS
9249:
9250: d_api_name CONSTANT VARCHAR2(30) := 'derive_clm_idc_type';

Line 9247: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240

9243: (
9244: p_key IN po_session_gt.key%TYPE,
9245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9246: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,
9247: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
9248: ) IS
9249:
9250: d_api_name CONSTANT VARCHAR2(30) := 'derive_clm_idc_type';
9251: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9256: l_result_tbl PO_TBL_VARCHAR240;

9252: d_position NUMBER;
9253:
9254: -- tables to store the derived result
9255: l_index_tbl PO_TBL_NUMBER;
9256: l_result_tbl PO_TBL_VARCHAR240;
9257: BEGIN
9258: d_position := 0;
9259:
9260: IF (PO_LOG.d_proc) THEN

Line 9316: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,

9312: PROCEDURE derive_clm_base_line_num
9313: (
9314: p_key IN po_session_gt.key%TYPE,
9315: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9316: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
9317: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9318: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9319: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
9320: p_clm_option_indicator IN PO_TBL_VARCHAR1,

Line 9397: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,

9393: PROCEDURE derive_from_header_id
9394: (
9395: p_key IN po_session_gt.key%TYPE,
9396: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9397: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,
9398: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9399: ) IS
9400:
9401: d_api_name CONSTANT VARCHAR2(30) := 'derive_from_header_id';

Line 9471: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,

9467: PROCEDURE derive_from_line_id
9468: (
9469: p_key IN po_session_gt.key%TYPE,
9470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9471: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
9472: p_from_header_id_tbl IN PO_TBL_NUMBER,
9473: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9474: ) IS
9475: