[Home] [Help]
PACKAGE: APPS.HR_ATTACHMENTS_LOADER
Source
1 PACKAGE HR_ATTACHMENTS_LOADER AUTHID CURRENT_USER as
2 /* $Header: hratload.pkh 115.1 99/10/12 07:04:55 porting ship $ */
3 --
4 procedure cre_or_sel_att_form_function(p_function_name IN VARCHAR2
5 ,p_function_type IN VARCHAR2
6 ,p_attachment_function_id OUT NUMBER
7 ,p_application_id OUT NUMBER);
8 --
9 procedure associate_category(p_attachment_function_id IN NUMBER
10 ,p_category_name IN VARCHAR2);
11 --
12 procedure create_or_update_block
13 (p_attachment_function_id IN NUMBER
14 ,p_block_name IN VARCHAR2
15 ,p_query_flag IN VARCHAR2 default 'N'
16 ,p_security_type IN NUMBER default 4
17 ,p_org_context_field IN VARCHAR2 default null
18 ,p_set_of_books_context_field IN VARCHAR2 default null
19 ,p_business_unit_context_field IN VARCHAR2 default null
20 ,p_context1_field IN VARCHAR2 default null
21 ,p_context2_field IN VARCHAR2 default null
22 ,p_context3_field IN VARCHAR2 default null
23 ,p_attachment_blk_id OUT NUMBER);
24 --
25 procedure create_or_select_entity
26 (p_data_object_code IN VARCHAR2
27 ,p_entity_user_name IN VARCHAR2 default null
28 ,p_language_code IN VARCHAR2 default null
29 ,p_application_id IN NUMBER default null
30 ,p_table_name IN VARCHAR2 default null
31 ,p_entity_name IN VARCHAR2 default null
32 ,p_pk1_column IN VARCHAR2 default null
33 ,p_pk2_column IN VARCHAR2 default null
34 ,p_pk3_column IN VARCHAR2 default null
35 ,p_pk4_column IN VARCHAR2 default null
36 ,p_pk5_column IN VARCHAR2 default null
37 ,p_document_entity_id OUT NUMBER);
38 --
39 procedure attach_entity
40 (p_attachment_blk_id IN NUMBER
41 ,p_data_object_code IN VARCHAR2
42 ,p_display_method IN VARCHAR2 default 'M'
43 ,p_include_in_indicator_flag IN VARCHAR2 default 'Y'
44 ,p_indicator_in_view_flag IN VARCHAR2 default 'N'
45 ,p_pk1_field IN VARCHAR2 default null
46 ,p_pk2_field IN VARCHAR2 default null
47 ,p_pk3_field IN VARCHAR2 default null
48 ,p_pk4_field IN VARCHAR2 default null
49 ,p_pk5_field IN VARCHAR2 default null
50 ,p_sql_statement IN VARCHAR2 default null
51 ,p_query_permission_type IN VARCHAR2 default 'Y'
52 ,p_insert_permission_type IN VARCHAR2 default 'Y'
53 ,p_update_permission_type IN VARCHAR2 default 'Y'
54 ,p_delete_permission_type IN VARCHAR2 default 'Y'
55 ,p_condition_field IN VARCHAR2 default null
56 ,p_condition_operator IN VARCHAR2 default null
57 ,p_condition_value1 IN VARCHAR2 default null
58 ,p_condition_value2 IN VARCHAR2 default null
59 ,p_attachment_blk_entity_id OUT NUMBER);
60 --
61 end HR_ATTACHMENTS_LOADER;