[Home] [Help]
PACKAGE: APPS.ASO_SUP_CAPTURE_DATA_PKG
Source
1 PACKAGE ASO_SUP_CAPTURE_DATA_PKG AUTHID CURRENT_USER AS
2 /* $Header: asospdcs.pls 120.1 2005/06/29 16:04:48 appldev ship $ */
3
4 PROCEDURE create_template_instance(
5 p_template_id IN NUMBER,
6 p_owner_table_name IN VARCHAR2,
7 p_owner_table_id IN NUMBER,
8 p_created_by IN NUMBER,
9 p_last_updated_by IN NUMBER,
10 p_last_update_login IN NUMBER,
11 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
12 x_template_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
13 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
14 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
15 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
16
17
18 PROCEDURE update_data (
19 p_template_instance_id IN NUMBER,
20 p_sect_comp_map_id IN NUMBER,
21 p_created_by IN NUMBER,
22 p_last_updated_by IN NUMBER,
23 p_last_update_login IN NUMBER,
24 p_response_id IN NUMBER,
25 p_response_value IN VARCHAR2,
26 p_multiple_response_flag IN VARCHAR2,
27 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
29 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
30 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
31
32 PROCEDURE delete_data (
33 p_template_instance_id IN NUMBER,
34 p_sect_comp_map_id IN NUMBER,
35 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
37 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
38 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
39
40
41 Procedure create_template_instance (
42 P_VERSION_NUMBER IN NUMBER,
43 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 P_Template_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
46 P_comp_sect_map_id IN JTF_NUMBER_TABLE,
47 P_response_value IN JTF_VARCHAR2_TABLE_2000,
48 P_response_id IN JTF_NUMBER_TABLE,
49 P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,
50 P_owner_table_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
51 P_owner_table_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52 X_template_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
53 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
54 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
55 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
56
57 Procedure update_instance_value (
58 P_VERSION_NUMBER IN NUMBER,
59 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
61 P_Template_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
62 P_comp_sect_map_id IN JTF_NUMBER_TABLE,
63 P_response_value IN JTF_VARCHAR2_TABLE_2000,
64 P_response_id IN JTF_NUMBER_TABLE,
65 P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,
66 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
67 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
68 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
69
70 END ASO_SUP_CAPTURE_DATA_PKG;