APPS.PO_DOC_STYLE_PVT dependencies on PO_DOC_STYLE_LINES_TL

Line 1017: l_style_display_name PO_DOC_STYLE_LINES_TL.DISPLAY_NAME%type;

1013: FUNCTION get_style_display_name(p_doc_id IN NUMBER,
1014: p_language IN VARCHAR2 DEFAULT NULL)
1015: RETURN VARCHAR2 IS
1016:
1017: l_style_display_name PO_DOC_STYLE_LINES_TL.DISPLAY_NAME%type;
1018:
1019: BEGIN
1020: --
1021: l_style_display_name := get_style_display_name(p_doc_id,-1,p_language);

Line 1056: l_style_display_name PO_DOC_STYLE_LINES_TL.DISPLAY_NAME%type;

1052:
1053: d_progress NUMBER;
1054: d_module VARCHAR2(60) := 'po.plsql.PO_DOC_STYLE_PVT.get_style_display_name';
1055:
1056: l_style_display_name PO_DOC_STYLE_LINES_TL.DISPLAY_NAME%type;
1057: --Bug 14115069 Need to check if type is planned po
1058: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
1059:
1060: BEGIN

Line 1080: from PO_DOC_STYLE_LINES_TL TL,

1076: --Bug 14115069 Need to check if type is planned po
1077: IF(l_type_lookup_code <> 'PLANNED') THEN
1078: select DISPLAY_NAME
1079: into l_style_display_name
1080: from PO_DOC_STYLE_LINES_TL TL,
1081: PO_HEADERS_MERGE_V ph
1082: where tl.LANGUAGE = nvl(p_language,
1083: USERENV('LANG'))
1084: and tl.style_id = ph.style_id