eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_QUERYOBJ_PVT dependencies on FND_API

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

46: -- Version Initial version number = 1.0
47: -- History Current version number = 1.0
48: --=======================================================
49: procedure DOWNLOAD_QUERY_OBJECT (
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_api_version_number IN NUMBER,
52: p_return_status OUT NOCOPY VARCHAR2,
53: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryObj_PK_Tbl_Type

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

49: procedure DOWNLOAD_QUERY_OBJECT (
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_api_version_number IN NUMBER,
52: p_return_status OUT NOCOPY VARCHAR2,
53: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryObj_PK_Tbl_Type
55: := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL,
56: p_nls_language IN VARCHAR2
57: );

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

64: -- owned by the Core Modules Team (AK).
65: --=======================================================
66:
67: PROCEDURE CREATE_QUERY_OBJECT(
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_api_version_number IN NUMBER,
70: p_init_msg_tbl IN BOOLEAN := FALSE,
71: p_msg_count OUT NOCOPY NUMBER,
72: p_msg_data OUT NOCOPY VARCHAR2,

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

72: p_msg_data OUT NOCOPY VARCHAR2,
73: p_return_status OUT NOCOPY VARCHAR2,
74: p_query_code IN VARCHAR2,
75: p_application_id IN NUMBER,
76: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
77: p_creation_date IN DATE := FND_API.G_MISS_DATE,
78: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
79: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
80: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

73: p_return_status OUT NOCOPY VARCHAR2,
74: p_query_code IN VARCHAR2,
75: p_application_id IN NUMBER,
76: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
77: p_creation_date IN DATE := FND_API.G_MISS_DATE,
78: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
79: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
80: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
81: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

74: p_query_code IN VARCHAR2,
75: p_application_id IN NUMBER,
76: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
77: p_creation_date IN DATE := FND_API.G_MISS_DATE,
78: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
79: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
80: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
81: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
82: p_pass IN NUMBER := 2

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

75: p_application_id IN NUMBER,
76: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
77: p_creation_date IN DATE := FND_API.G_MISS_DATE,
78: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
79: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
80: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
81: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
82: p_pass IN NUMBER := 2
83: );

Line 80: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

76: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
77: p_creation_date IN DATE := FND_API.G_MISS_DATE,
78: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
79: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
80: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
81: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
82: p_pass IN NUMBER := 2
83: );
84:

Line 81: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

77: p_creation_date IN DATE := FND_API.G_MISS_DATE,
78: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
79: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
80: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
81: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
82: p_pass IN NUMBER := 2
83: );
84:
85: --=======================================================

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

90: -- owned by the Core Modules Team (AK).
91: --=======================================================
92:
93: PROCEDURE CREATE_QUERY_OBJECT_LINE(
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_api_version_number IN NUMBER,
96: p_init_msg_tbl IN BOOLEAN := FALSE,
97: p_msg_count OUT NOCOPY NUMBER,
98: p_msg_data OUT NOCOPY VARCHAR2,

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

99: p_return_status OUT NOCOPY VARCHAR2,
100: p_query_code IN VARCHAR2,
101: p_seq_num IN NUMBER,
102: p_query_line_type IN VARCHAR2,
103: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

100: p_query_code IN VARCHAR2,
101: p_seq_num IN NUMBER,
102: p_query_line_type IN VARCHAR2,
103: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
108: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

101: p_seq_num IN NUMBER,
102: p_query_line_type IN VARCHAR2,
103: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
108: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
109: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

102: p_query_line_type IN VARCHAR2,
103: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
108: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
109: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
110: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

103: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
108: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
109: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
110: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
111: p_pass IN NUMBER := 2

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

104: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
108: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
109: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
110: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
111: p_pass IN NUMBER := 2
112: );

Line 109: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

105: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
108: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
109: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
110: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
111: p_pass IN NUMBER := 2
112: );
113:

Line 110: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

106: p_creation_date IN DATE := FND_API.G_MISS_DATE,
107: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
108: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
109: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
110: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
111: p_pass IN NUMBER := 2
112: );
113:
114: --=======================================================

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

159: -- Version Initial version number = 1.0
160: -- History Current version number = 1.0
161: --=======================================================
162: procedure UPLOAD_QUERY_OBJECT (
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: p_api_version_number IN NUMBER,
165: p_return_status OUT NOCOPY VARCHAR2,
166: p_index IN OUT NOCOPY NUMBER,
167: p_loader_timestamp IN DATE,

Line 168: p_line_num IN NUMBER := FND_API.G_MISS_NUM,

164: p_api_version_number IN NUMBER,
165: p_return_status OUT NOCOPY VARCHAR2,
166: p_index IN OUT NOCOPY NUMBER,
167: p_loader_timestamp IN DATE,
168: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
169: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
170: p_line_num_out OUT NOCOPY NUMBER,
171: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
172: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,