PACKAGE: APPS.CSF_PARAMS_PKG

Source

1 PACKAGE CSF_PARAMS_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSFCPARS.pls 115.11.11510.2 2004/06/24 04:35:07 srengana ship $ */
3 
4 G_PKG_NAME CONSTANT VARCHAR2(30):='CSF_PARAMS_PKG';
5 
6 type paramrec is
7 record
8 ( primary_key                          number(1)
9 , agenda_progressclock                 number(1)
10 , agenda_forceworkform                 number(1)
11 , agenda_accompletedtask               number(1)
12 , csf_m_agenda_accompletedtask         number(1)
13 , agenda_allowchangesinpast            number(1)
14 , agenda_dayslookback                  number(6)
15 , agenda_roundedofftime                number(2)
16 , agenda_refreshwaittime               number(6)
17 , agenda_usemileagestartofday          number(1)
18 , agenda_usemileagefinishofday         number(1)
19 , agenda_usemileagestarttask           number(1)
20 , agenda_usemileagefinishtask          number(1)
21 , agenda_mileageuom                    varchar2(3)
22 , agenda_unit_of_measure_tl            varchar2(25)
23 , agenda_on_duty_item_id               number
24 , csf_m_agenda_on_duty_item_id         number
25 , agenda_inventory_item_name_tl        varchar2(40)
26 , agenda_trip_blg_type_id              number
27 , csf_m_agenda_trip_blg_type_id        number
28 , agenda_trip_blg_type_name            varchar2(30)
29 , parts_allowstocklevelbelowzero       number(1)
30 , parts_showtime                       number(1)
31 , parts_editserialnumber               number(1)
32 , soexp_addsoh_remote                  number(1)
33 , soexp_editsoh_remote                 number(1)
34 , soexp_addsoa_remote                  number(1)
35 , soexp_editsoa_remote                 number(1)
36 , soexp_standardtaskduration           varchar2(7)
37 , recipients_boundary                  number(1)
38 , csf_m_recipients_boundary            number(1)
39 , mail_engbeepunreadmail               number(1)
40 , userdefbutton1                       varchar2(2000)
41 , userdefbutton2                       varchar2(2000)
42 , userdefbutton3                       varchar2(2000)
43 , userdefbutton4                       varchar2(2000)
44 , userdefbutton5                       varchar2(2000)
45 , userdefbutton6                       varchar2(2000)
46 , userdefbutton7                       varchar2(2000)
47 , agenda_trip_process_id               number
48 , csf_m_agenda_trip_process_id         number
49 );
50 
51 type paramtab is
52 table of paramrec
53 index by binary_integer;
54 
55 cursor c_read_parameter
56 (b_name varchar2
57 )
58 is
59 select par.param_id
60 ,      par.value
61 from   csf_params par
62 where  Upper(par.name) = Upper(b_name);
63 
64 io_param paramtab;
65 
66 function query_parameter
67 ( i_name varchar2
68 , i_default_value number
69 )
70 return number;
71 
72 function query_parameter
73 ( i_name varchar2
74 , i_default_value varchar2
75 )
76 return varchar2;
77 
78 procedure query_parameters
79 ( io_param in out paramtab
80 );
81 
82 procedure update_parameters
83 ( io_param in out paramtab
84 );
85 
86 procedure lock_parameters
87 ( io_param in out paramtab
88 );
89 
90 end CSF_PARAMS_PKG;