DBA Data[Home] [Help]

APPS.PO_POXRQSIN_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 10: l_status po_lookup_codes.displayed_field%type ;

6: function BeforeReport return boolean is
7: begin
8:
9: declare
10: l_status po_lookup_codes.displayed_field%type ;
11: l_sort po_lookup_codes.displayed_field%type ;
12: begin
13: if P_status is not null then
14:

Line 11: l_sort po_lookup_codes.displayed_field%type ;

7: begin
8:
9: declare
10: l_status po_lookup_codes.displayed_field%type ;
11: l_sort po_lookup_codes.displayed_field%type ;
12: begin
13: if P_status is not null then
14:
15: select displayed_field

Line 17: from po_lookup_codes

13: if P_status is not null then
14:
15: select displayed_field
16: into l_status
17: from po_lookup_codes
18: where lookup_code = P_status
19: and lookup_type = 'AUTHORIZATION STATUS';
20:
21: P_status_displayed := l_status ;

Line 34: from po_lookup_codes

30: if P_orderby is not null then
31:
32: select displayed_field
33: into l_sort
34: from po_lookup_codes
35: where lookup_code = P_orderby
36: and lookup_type = 'SRS ORDER BY';
37:
38: P_orderby_displayed := l_sort ;

Line 48: l_message1 po_lookup_codes.description%TYPE ;

44: end if;
45: FORMAT_MASK := PO_COMMON_XMLP_PKG.GET_PRECISION(P_QTY_PRECISION);
46: end;
47: DECLARE
48: l_message1 po_lookup_codes.description%TYPE ;
49: Call_variable boolean;
50: l_INDUSTRY Varchar2(100);
51: l_ORACLE_SCHEMA Varchar2(100);
52: Begin

Line 65: from po_lookup_codes

61:
62: if P_OE_STATUS <> 'I' then
63: select description
64: into l_message1
65: from po_lookup_codes
66: where lookup_type = 'SRW MESSAGE'
67: and lookup_code = 'CANNOT RUN PROGRAM' ;
68:
69: /*srw.message(1,l_message1) ;*/null;

Line 77: from po_lookup_codes

73:
74: EXCEPTION WHEN USER_EXIT_FAILURE /*SRW.USER_EXIT_FAILURE */THEN
75: select description
76: into l_message1
77: from po_lookup_codes
78: where lookup_type = 'SRW MESSAGE'
79: and lookup_code = 'FAILURE TO GET STATUS' ;
80:
81: /*srw.message(1,l_message1) ;*/null;