26: -- Version Initial version number = 1.0
27: -- History Current version number = 1.0
28: --=======================================================
29: procedure CREATE_QUERY_OBJECT (
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_api_version_number IN NUMBER,
32: p_init_msg_tbl IN BOOLEAN := FALSE,
33: p_msg_count OUT NOCOPY NUMBER,
34: p_msg_data OUT NOCOPY VARCHAR2,
34: p_msg_data OUT NOCOPY VARCHAR2,
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_query_code IN VARCHAR2,
37: p_application_id IN NUMBER,
38: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
39: p_creation_date IN DATE := FND_API.G_MISS_DATE,
40: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
41: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
42: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_query_code IN VARCHAR2,
37: p_application_id IN NUMBER,
38: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
39: p_creation_date IN DATE := FND_API.G_MISS_DATE,
40: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
41: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
42: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
43: );
36: p_query_code IN VARCHAR2,
37: p_application_id IN NUMBER,
38: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
39: p_creation_date IN DATE := FND_API.G_MISS_DATE,
40: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
41: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
42: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
43: );
44:
37: p_application_id IN NUMBER,
38: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
39: p_creation_date IN DATE := FND_API.G_MISS_DATE,
40: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
41: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
42: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
43: );
44:
45: --=======================================================
38: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
39: p_creation_date IN DATE := FND_API.G_MISS_DATE,
40: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
41: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
42: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
43: );
44:
45: --=======================================================
46: -- Procedure CREATE_QUERY_OBJECT_LINE
60: -- Version Initial version number = 1.0
61: -- History Current version number = 1.0
62: --=======================================================
63: procedure CREATE_QUERY_OBJECT_LINE (
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_api_version_number IN NUMBER,
66: p_init_msg_tbl IN BOOLEAN := FALSE,
67: p_msg_count OUT NOCOPY NUMBER,
68: p_msg_data OUT NOCOPY VARCHAR2,
68: p_msg_data OUT NOCOPY VARCHAR2,
69: p_return_status OUT NOCOPY VARCHAR2,
70: p_query_code IN VARCHAR2,
71: p_seq_num IN NUMBER,
72: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
69: p_return_status OUT NOCOPY VARCHAR2,
70: p_query_code IN VARCHAR2,
71: p_seq_num IN NUMBER,
72: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70: p_query_code IN VARCHAR2,
71: p_seq_num IN NUMBER,
72: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71: p_seq_num IN NUMBER,
72: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
72: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
80: );
73: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
80: );
81:
74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
80: );
81:
82: --========================================================
75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
76: p_creation_date IN DATE := FND_API.G_MISS_DATE,
77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
80: );
81:
82: --========================================================
83: -- Procedure DOWNLOAD_QUERY_OBJECT
119: -- Version Initial version number = 1.0
120: -- History Current version number = 1.0
121: --=======================================================
122: procedure DOWNLOAD_QUERY_OBJECT (
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_api_version_number IN NUMBER,
125: p_init_msg_tbl IN BOOLEAN := FALSE,
126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,
125: p_init_msg_tbl IN BOOLEAN := FALSE,
126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,
128: p_return_status OUT NOCOPY VARCHAR2,
129: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryobj_PK_Tbl_Type :=
133: AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL
126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,
128: p_return_status OUT NOCOPY VARCHAR2,
129: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryobj_PK_Tbl_Type :=
133: AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL
134: );
127: p_msg_data OUT NOCOPY VARCHAR2,
128: p_return_status OUT NOCOPY VARCHAR2,
129: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
131: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryobj_PK_Tbl_Type :=
133: AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL
134: );
135: