PACKAGE BODY: APPS.PO_POXCORSL_XMLP_PKG

Source

1 PACKAGE BODY PO_POXCORSL_XMLP_PKG AS
2 /* $Header: POXCORSLB.pls 120.1 2007/12/25 10:53:09 krreddy noship $ */
3 
4 USER_EXIT_FAILURE EXCEPTION;
5 
6 function BeforeReport return boolean is
7 begin
8 declare
9 cursor org_cursor IS
10   select ood.organization_name
11   from org_organization_definitions ood
12   where ood.organization_id = p_ship_to;
13 l_org_displayed  org_organization_definitions.organization_name%type ;
14 
15 
16 begin
17   OPEN org_cursor;
18   FETCH org_cursor INTO l_org_displayed;
19   P_SHIP_TO_ORG_NAME:=l_org_displayed;
20   CLOSE org_cursor;
21 
22 
23 
24 
25   if p_country_of_origin_code IS NOT NULL then
26     p_query_where_country_code := ' paa.country_of_origin_code = '|| '''' || P_COUNTRY_OF_ORIGIN_CODE || '''';
27   end if;
28 end;
29 BEGIN
30   /*SRW.USER_EXIT('FND SRWINIT');*/null;
31 
32   EXCEPTION WHEN  USER_EXIT_FAILURE /*SRW.USER_EXIT_FAILURE */THEN
33             /*SRW.MESSAGE(1,'srw_init');*/null;
34 
35 END;
36 BEGIN
37 
38  null;
39   EXCEPTION WHEN  USER_EXIT_FAILURE /*SRW.USER_EXIT_FAILURE */THEN
40             /*SRW.MESSAGE(1,'Before Item Flex');*/null;
41 
42 END;
43 
44   return (TRUE);
45 end;
46 
47 function AfterReport return boolean is
48 begin
49   /*SRW.USER_EXIT('FND SRWEXIT');*/null;
50 
51   return (TRUE);
52 end;
53 
54 --Functions to refer Oracle report placeholders--
55 
56 END PO_POXCORSL_XMLP_PKG ;
57