[Home] [Help]
PACKAGE: APPS.CS_SR_LOG_PKG
Source
1 PACKAGE CS_SR_LOG_PKG AUTHID CURRENT_USER as
2 /* $Header: csvsrlgs.pls 115.0 2000/02/29 19:47:44 pkm ship $ */
3 -- Start of Comments
4 -- Package name : CS_SR_LOG_PKG
5 -- Purpose : package has a function that outputs the log
6 -- for the fulfillment report
7 -- History :
8 -- NOTE :
9 -- End of Comments
10
11 --create or replace PACKAGE CS_DIARY_PKG IS
12 FUNCTION SR_LOG (p_incident_id varchar2,
13 p_public_notes_only varchar2 DEFAULT 'Y',
14 p_order_by varchar2 DEFAULT 'Y')
15 Return varchar2 ;
16
17 PROCEDURE audit_display(x_source_type varchar2,
18 x_last_update_date date,
19 x_owner varchar2,
20 x_severity_old varchar2,
21 x_severity_new varchar2,
22 x_type_old varchar2,
23 x_type_new varchar2,
24 x_status_old varchar2,
25 x_status_new varchar2,
26 x_urgency_old varchar2,
27 x_urgency_new varchar2,
28 x_group_old varchar2,
29 x_group_new varchar2,
30 x_owner_old varchar2,
31 x_owner_new varchar2,
32 x_date_old varchar2,
33 x_date_new varchar2,
34 x_obligation_date_new varchar2 ,
35 x_obligation_date_old varchar2 ,
36 x_site_id_new varchar2 ,
37 x_site_id_old varchar2 ,
38 x_old_bill_to_contact_name varchar2 ,
39 x_new_bill_to_contact_name varchar2 ,
40 x_old_ship_to_contact_name varchar2 ,
41 x_new_ship_to_contact_name varchar2 ,
42 x_old_platform_name varchar2 ,
43 x_new_platform_name varchar2 ,
44 x_old_platform_version_name varchar2 ,
45 x_new_platform_version_name varchar2 ,
46 x_old_description varchar2 ,
47 x_new_description varchar2 ,
48 x_old_language varchar2 ,
49 x_new_language varchar2 ,
50 x_details OUT VARCHAR2) ;
51
52 PROCEDURE TASK_NOTES ( x_task_id NUMBER,
53 x_details OUT VARCHAR2);
54
55 gs_newline varchar2(1) := substr('
56
57 ',1,1);
58
59 END;