[Home] [Help]
PACKAGE: APPS.GMA_EDITEXT_ATTACH_MIG
Source
1 PACKAGE GMA_EDITEXT_ATTACH_MIG AUTHID CURRENT_USER AS
2 /* $Header: GMAEATHS.pls 120.2 2006/11/02 20:44:44 txdaniel noship $ */
3
4 PROCEDURE Attachment_Main(
5 p_text_code in VARCHAR2 default null,
6 p_text_table_tl in VARCHAR2 default null,
7 p_sy_para_cds_table_name in VARCHAR2 default null,
8 p_attach_form_short_name in VARCHAR2 default null,
9 p_attach_table_name in VARCHAR2 default null,
10 p_attach_pk1_value in VARCHAR2 default null,
11 p_attach_pk2_value in VARCHAR2 default null,
12 p_attach_pk3_value in VARCHAR2 default null,
13 p_attach_pk4_value in VARCHAR2 default null,
14 p_attach_pk5_value in VARCHAR2 default null
15 );
16
17 PROCEDURE Check_Fnd_Attachment_Defined(
18 p_text_code in VARCHAR2 default null,
19 p_sy_para_cds_table_name in VARCHAR2 default null,
20 p_form_short_name in VARCHAR2 default null,
21 p_table_name in VARCHAR2 default null,
22 p_attachment_function_id OUT NOCOPY NUMBER
23 );
24
25 PROCEDURE Check_Fnd_Document_Exists(
26 p_text_tl_table in VARCHAR2 default null,
27 p_sy_para_cds_table_name in VARCHAR2 default null,
28 p_text_code in VARCHAR2,
29 p_paragraph_code in VARCHAR2,
30 p_sub_paracode in NUMBER,
31 p_pk1_value in VARCHAR2 Default null,
32 p_pk2_value in VARCHAR2 Default null,
33 p_pk3_value in VARCHAR2 Default null,
34 p_pk4_value in VARCHAR2 Default null,
35 p_pk5_value in VARCHAR2 Default null,
36 p_paragraph_count in NUMBER Default null,
37 p_document_exist OUT NOCOPY VARCHAR2,
38 p_file_name OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE Get_Fnd_Attachment_Blk_PK(
42 p_text_code in VARCHAR2 default null,
43 p_sy_para_cds_table_name in VARCHAR2 default null,
44 p_form_short_name in VARCHAR2 default null,
45 p_table_name in VARCHAR2 default null,
46 p_attachment_function_id in NUMBER,
47 p_pk1_value OUT NOCOPY VARCHAR2,
48 p_pk2_value OUT NOCOPY VARCHAR2 ,
49 p_pk3_value OUT NOCOPY VARCHAR2 ,
50 p_pk4_value OUT NOCOPY VARCHAR2 ,
51 p_pk5_value OUT NOCOPY VARCHAR2
52 );
53
54 PROCEDURE Fnd_Document_set_languages(
55 p_text_code in NUMBER Default null,
56 p_sy_para_cds_table_name in VARCHAR2 default null,
57 p_text_tl_table in VARCHAR2 Default null,
58 p_paragraph_code in VARCHAR2 Default null,
59 p_sub_paracode in Number Default null
60 );
61
62 PROCEDURE Create_Fnd_Document(
63 p_text_code in VARCHAR2 default null,
64 p_sy_para_cds_table_name in VARCHAR2 default null,
65 p_entity_name in VARCHAR2 Default 'GMA Migration',
66 p_pk1_value in VARCHAR2 Default null,
67 p_pk2_value in VARCHAR2 Default null,
68 p_pk3_value in VARCHAR2 Default null,
69 p_pk4_value in VARCHAR2 Default null,
70 p_pk5_value in VARCHAR2 Default null,
71 x_description in VARCHAR2 Default null,
72 p_file_name IN VARCHAR2 DEFAULT NULL,
73 x_attached_document_id in OUT NOCOPY NUMBER,
74 x_document_id in OUT NOCOPY NUMBER,
75 x_media_id in OUT NOCOPY NUMBER,
76 p_attachment_function_id in NUMBER,
77 p_sequence_num IN NUMBER
78 );
79
80 PROCEDURE Get_Fnd_Attachment_Category(
81 p_text_code in VARCHAR2 default null,
82 p_sy_para_cds_table_name in VARCHAR2 default null,
83 p_category_name in VARCHAR2 default 'OPM_MIGRATED_TEXT',
84 p_user_name in VARCHAR2 default 'GMA Migration Text',
85 p_category_exists OUT NOCOPY NUMBER,
86 p_category_id OUT NOCOPY NUMBER
87 );
88
89 PROCEDURE Get_Fnd_Category_Usage(
90 p_text_code in VARCHAR2 default null,
91 p_sy_para_cds_table_name in VARCHAR2 default null,
92 p_category_id in NUMBER,
93 p_attachment_function_id in NUMBER,
94 p_category_usage_exists OUT NOCOPY NUMBER
95 );
96
97 PROCEDURE Create_Fnd_Short_Text(
98 p_text_tl_table in VARCHAR2 default null,
99 p_sy_para_cds_table_name in VARCHAR2 default null,
100 p_text_code in VARCHAR2,
101 p_paragraph_code in VARCHAR2,
102 p_sub_paracode in NUMBER,
103 p_language in VARCHAR2,
104 p_attached_document_id in OUT NOCOPY NUMBER,
105 p_document_id in OUT NOCOPY NUMBER,
106 p_media_id in OUT NOCOPY NUMBER,
107 p_pk1_value in VARCHAR2 Default null,
108 p_pk2_value in VARCHAR2 Default null,
109 p_pk3_value in VARCHAR2 Default null,
110 p_pk4_value in VARCHAR2 Default null,
111 p_pk5_value in VARCHAR2 Default null,
112 p_paragraph_count in NUMBER Default null
113 );
114
115 PROCEDURE Check_Text_Paragraph_Match
116 (
117 p_text_code IN NUMBER,
118 p_text_tl_table IN VARCHAR2,
119 p_paragraph_code IN VARCHAR2,
120 p_sub_paracode IN NUMBER,
121 x_paragraph_exists OUT NOCOPY BOOLEAN
122 );
123
124 END GMA_EDITEXT_ATTACH_MIG;