DBA Data[Home] [Help]

APPS.OKS_UTIL_PUB dependencies on OKC_LINE_STYLES_B

Line 707: -- p_lty_code : Line Type Code (lty_code from okc_line_styles_b)

703:
704: -- ===========================================================================
705: -- Function get_line_name
706: -- Input Parameters:
707: -- p_lty_code : Line Type Code (lty_code from okc_line_styles_b)
708: -- p_object1_id1 : Object Id 1 (object1_id1 from okc_k_items)
709: -- p_object1_id2 : Object Id 2 (object1_id2 from okc_k_items)
710: -- Return Value:
711: -- Name of the line item (VARCHAR2)

Line 840: FROM okc_k_lines_b sle, okc_k_items item, okc_line_styles_b lse

836: -- To be used if only the line id is known
837: FUNCTION get_line_name( p_subline_id IN NUMBER ) RETURN VARCHAR2 IS
838: CURSOR sublinecur IS
839: SELECT lse.lty_code, item.object1_id1, item.object1_id2
840: FROM okc_k_lines_b sle, okc_k_items item, okc_line_styles_b lse
841: WHERE item.cle_id = sle.id
842: AND lse.id = sle.lse_id
843: AND sle.id = p_subline_id;
844: l_name VARCHAR2(200);