1 PACKAGE IGS_CO_GEN_004 AS
2 /* $Header: IGSCO23S.pls 120.0 2005/06/01 16:00:45 appldev noship $ */
3
4 /* +=======================================================================+
5 | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | NAME |
9 | IGSCO23B.pls |
10 | |
11 | DESCRIPTION |
12 | This package provides service functions and procedures to |
13 | correspondence forms for sending test mails, resending requests |
14 | and view attachments . |
15 | |
16 | NOTES
17 | HISTORY |
18 | who when what
19 | ssawhney 3-may-04 IBC.C patchset changes bug 3565861 + 3442719
20 +==========================================================================*/
21
22 TYPE T_VARCHAR_100 IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
23 TYPE T_VARCHAR_300 IS TABLE OF VARCHAR2(300) INDEX BY BINARY_INTEGER;
24 TYPE T_VARCHAR_4000 IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
25 TYPE T_NUMBER IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
26
27 PROCEDURE resend_request
28 (
29 X_ROWID IN OUT NOCOPY VARCHAR2,
30 X_STUDENT_ID IN NUMBER,
31 X_DOCUMENT_ID IN NUMBER,
32 X_DOCUMENT_TYPE IN VARCHAR2,
33 X_SYS_LTR_CODE IN VARCHAR2,
34 X_ADM_APPLICATION_NUMBER IN NUMBER,
35 X_NOMINATED_COURSE_CD IN VARCHAR2,
36 X_SEQUENCE_NUMBER IN NUMBER,
37 X_CAL_TYPE IN VARCHAR2,
38 X_CI_SEQUENCE_NUMBER IN NUMBER,
39 X_REQUESTED_DATE IN DATE,
40 X_DELIVERY_TYPE IN VARCHAR2,
41 X_OLD_REQUEST_ID IN NUMBER,
42 X_NEW_REQUEST_ID OUT NOCOPY NUMBER,
43 X_MSG_COUNT OUT NOCOPY NUMBER,
44 X_MSG_DATA OUT NOCOPY VARCHAR2,
45 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
47 X_VERSION_ID IN NUMBER -- ssawhney 3565861
48 );
49
50
51 PROCEDURE send_test_mail
52 (
53 X_MAIL_ID IN VARCHAR2,
54 X_SUBJECT IN VARCHAR2,
55 X_CRM_USER_ID IN NUMBER,
56 X_TEMPLATE_ID IN NUMBER,
57 X_VERSION_ID IN NUMBER,
58 X_MSG_COUNT OUT NOCOPY NUMBER,
59 X_MSG_DATA OUT NOCOPY VARCHAR2,
60 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61 X_REQUEST_ID OUT NOCOPY NUMBER,
62 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
63 ) ;
64
65
66 PROCEDURE get_attachments
67 (
68 p_version_id IN NUMBER, -- this should pass the IBC_CITEMS_V.CITEM_VER_ID, ssawhney
69 x_item_id OUT NOCOPY NUMBER,
70 x_item_name OUT NOCOPY VARCHAR2,
71 x_version OUT NOCOPY NUMBER,
72 x_item_description OUT NOCOPY VARCHAR2,
73 x_type_code OUT NOCOPY VARCHAR2,
74 x_type_name OUT NOCOPY VARCHAR2,
75 x_attribute_type_codes OUT NOCOPY T_VARCHAR_100,
76 x_attribute_type_names OUT NOCOPY T_VARCHAR_300,
77 x_attributes OUT NOCOPY T_VARCHAR_4000,
78 x_component_citems OUT NOCOPY T_NUMBER,
79 x_component_attrib_types OUT NOCOPY T_VARCHAR_100,
80 x_component_citem_names OUT NOCOPY T_VARCHAR_300,
81 x_component_owner_ids OUT NOCOPY T_NUMBER,
82 x_component_owner_types OUT NOCOPY T_VARCHAR_100,
83 x_component_sort_orders OUT NOCOPY T_NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE get_list_query (
90 p_file_id IN NUMBER,
91 p_query_text OUT NOCOPY VARCHAR2
92 );
93
94
95 PROCEDURE create_associations (
96 p_doc_id IN NUMBER,
97 p_assoc_type_codes IN VARCHAR2,
98 p_letter_code IN VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2
102 ) ;
103
104 END IGS_CO_GEN_004;