DBA Data[Home] [Help]

APPS.AK_QUERYOBJ_GRP dependencies on FND_API

Line 30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 38: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

Line 39: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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: );

Line 40: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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:

Line 41: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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: --=======================================================

Line 42: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

Line 64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 72: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 73: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 74: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 75: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

Line 76: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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: );

Line 77: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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:

Line 78: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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: --========================================================

Line 79: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

Line 123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 129: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 130: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 131: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: