PACKAGE: APPS.OTA_FR_TRG_SUM

Source

1 PACKAGE OTA_FR_TRG_SUM as
2 /* $Header: otfrtrgsm.pkh 120.0.12010000.1 2008/10/15 11:40:23 praupadh noship $ */
3 
4 
5 TYPE XMLRec IS RECORD(
6 TagName VARCHAR2(1000),
7 TagValue VARCHAR2(1000));
8 
9 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
10 vXMLTable tXMLTable;
11 
12 function get_lookup_value(p_lookup_type varchar2,
13                           p_lookup_code  varchar2)return varchar2;
14 
15 PROCEDURE POPULATE_REPORT_DATA(P_ASG_NUM  IN varchar2,
16                                dummy      IN varchar2,
17 			       dummy1     IN varchar2,
18                                P_COMPANY_ID IN NUMBER ,
19                                P_ESTABLISHMENT_ID IN NUMBER ,
20 			       P_BUSINESS_GROUP_ID IN NUMBER,
21 			       P_ASSIGNMENT_SET_ID IN NUMBER,
22 			       P_PERSON_ID IN NUMBER ,
23 			       P_DATE_FROM IN VARCHAR2 default NULL,
24 			       P_DATE_TO IN VARCHAR2 default NULL,
25 			       P_TEMPLATE_NAME IN VARCHAR2 ,
26 			       P_SORT_ORDER IN VARCHAR2,
27 			       p_xml OUT NOCOPY CLOB
28 			       );
29 
30 PROCEDURE make_employee ( L_P_PERSON_ID IN NUMBER,
31                           L_P_DATE_FROM IN DATE ,
32 			  L_P_DATE_TO IN DATE,
33 			  p_xml   in out nocopy clob
34                         )
35 		      ;
36 
37 
38 END OTA_FR_TRG_SUM;