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
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: (
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
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
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: (
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,
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:
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
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';
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 || '.';
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
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';
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
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';
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 || '.';
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
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,
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';
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: