DBA Data[Home] [Help]

APPS.PO_POXRQSDD_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 10: l_sort po_lookup_codes.displayed_field%type ;

6: function BeforeReport return boolean is
7: begin
8:
9: declare
10: l_sort po_lookup_codes.displayed_field%type ;
11: begin
12: FORMAT_MASK := PO_COMMON_XMLP_PKG.GET_PRECISION(P_qty_precision);
13: if P_orderby is not null then
14:

Line 17: from po_lookup_codes

13: if P_orderby is not null then
14:
15: select displayed_field
16: into l_sort
17: from po_lookup_codes
18: where lookup_code = P_orderby
19: and lookup_type = 'SRS ORDER BY';
20:
21: P_orderby_displayed := l_sort ;

Line 32: l_message1 po_lookup_codes.description%TYPE ;

28:
29:
30: end;
31: DECLARE
32: l_message1 po_lookup_codes.description%TYPE ;
33: l_INDUSTRY varchar2(100);
34: l_Oracle_schema varchar2(100);
35: L_boolean_var boolean;
36: Begin

Line 48: from po_lookup_codes

44:
45: if P_OE_STATUS <> 'I' then
46: select description
47: into l_message1
48: from po_lookup_codes
49: where lookup_type = 'SRW MESSAGE'
50: and lookup_code = 'CANNOT RUN PROGRAM' ;
51:
52: /*srw.message(1,l_message1) ;*/null;

Line 60: from po_lookup_codes

56:
57: EXCEPTION WHEN USER_EXIT_FAILURE /*SRW.USER_EXIT_FAILURE */THEN
58: select description
59: into l_message1
60: from po_lookup_codes
61: where lookup_type = 'SRW MESSAGE'
62: and lookup_code = 'FAILURE TO GET STATUS' ;
63:
64: /*srw.message(1,l_message1) ;*/null;