DBA Data[Home] [Help]

APPS.AR_ARXINVAD_XMLP_PKG dependencies on FND_LOOKUPS

Line 13: l_sequence_method fnd_lookups.meaning%type;

9: END;
10: FUNCTION get_nls_strings RETURN BOOLEAN IS
11: nls_no_data fnd_new_messages.message_text%type;
12: l_sequence_name fnd_document_sequences.name%type;
13: l_sequence_method fnd_lookups.meaning%type;
14: lang varchar2(50);
15: BEGIN
16: nls_no_data := ARP_STANDARD.FND_MESSAGE('AR_NO_DATA_FOUND');
17: c_nls_no_data_exists := '*** '|| nls_no_data || ' ***';

Line 23: fnd_lookups lu

19: lu.meaning
20: INTO l_sequence_name,
21: l_sequence_method
22: FROM fnd_document_sequences ds,
23: fnd_lookups lu
24: WHERE ds.doc_sequence_id = p_sequence_id
25: AND lu.lookup_type = 'SEQUENCE_METHOD'
26: AND lu.LOOKUP_CODE = ds.type;
27: c_sequence_name := l_sequence_name;

Line 111: from fnd_lookups

107: status VARCHAR2(30);
108: BEGIN
109: select SUBSTR(meaning, 1, 30)
110: into status
111: from fnd_lookups
112: where lookup_type='SEQ_DOCUMENT_STATUS'
113: and lookup_code='E';
114: return(status);
115: END;

Line 124: from fnd_lookups

120: status VARCHAR2(30);
121: BEGIN
122: select SUBSTR(meaning, 1, 30)
123: into status
124: from fnd_lookups
125: where lookup_type = 'SEQ_DOCUMENT_STATUS'
126: and lookup_code = 'D';
127: return(status);
128: END;

Line 154: from fnd_lookups

150: status VARCHAR2(30);
151: BEGIN
152: select SUBSTR(meaning, 1, 30)
153: into status
154: from fnd_lookups
155: where lookup_type = 'SEQ_DOCUMENT_STATUS'
156: and lookup_code = 'N';
157: return(status);
158: END;