103: );
104:
105: PROCEDURE derive_parent_interface_ids
106: ( p_table_name IN VARCHAR2,
107: p_table_id_tbl IN PO_TBL_NUMBER,
108: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
109: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
110: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
111: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
104:
105: PROCEDURE derive_parent_interface_ids
106: ( p_table_name IN VARCHAR2,
107: p_table_id_tbl IN PO_TBL_NUMBER,
108: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
109: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
110: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
111: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
112: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
105: PROCEDURE derive_parent_interface_ids
106: ( p_table_name IN VARCHAR2,
107: p_table_id_tbl IN PO_TBL_NUMBER,
108: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
109: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
110: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
111: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
112: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
113: );
106: ( p_table_name IN VARCHAR2,
107: p_table_id_tbl IN PO_TBL_NUMBER,
108: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
109: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
110: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
111: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
112: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
113: );
114:
107: p_table_id_tbl IN PO_TBL_NUMBER,
108: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
109: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
110: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
111: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
112: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
113: );
114:
115:
108: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
109: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
110: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
111: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
112: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
113: );
114:
115:
116: