157: procedure bind_asset_variable(p_get_asset_cursor_id NUMBER
158: , p0_a0 NUMBER := 0-1962.0724
159: , p0_a1 NUMBER := 0-1962.0724
160: , p0_a2 NUMBER := 0-1962.0724
161: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
162: , p0_a4 NUMBER := 0-1962.0724
163: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
164: , p0_a6 NUMBER := 0-1962.0724
165: );
159: , p0_a1 NUMBER := 0-1962.0724
160: , p0_a2 NUMBER := 0-1962.0724
161: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
162: , p0_a4 NUMBER := 0-1962.0724
163: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
164: , p0_a6 NUMBER := 0-1962.0724
165: );
166: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
167: , p0_a1 in out nocopy JTF_NUMBER_TABLE
194: procedure gen_asset_where_clause(x_where_clause out nocopy VARCHAR2
195: , p0_a0 NUMBER := 0-1962.0724
196: , p0_a1 NUMBER := 0-1962.0724
197: , p0_a2 NUMBER := 0-1962.0724
198: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a4 NUMBER := 0-1962.0724
200: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a6 NUMBER := 0-1962.0724
202: );
196: , p0_a1 NUMBER := 0-1962.0724
197: , p0_a2 NUMBER := 0-1962.0724
198: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a4 NUMBER := 0-1962.0724
200: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a6 NUMBER := 0-1962.0724
202: );
203: procedure get_instance_assets(p_api_version NUMBER
204: , p_commit VARCHAR2
238: , x_msg_data out nocopy VARCHAR2
239: , p4_a0 NUMBER := 0-1962.0724
240: , p4_a1 NUMBER := 0-1962.0724
241: , p4_a2 NUMBER := 0-1962.0724
242: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
243: , p4_a4 NUMBER := 0-1962.0724
244: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
245: , p4_a6 NUMBER := 0-1962.0724
246: );
240: , p4_a1 NUMBER := 0-1962.0724
241: , p4_a2 NUMBER := 0-1962.0724
242: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
243: , p4_a4 NUMBER := 0-1962.0724
244: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
245: , p4_a6 NUMBER := 0-1962.0724
246: );
247: procedure create_instance_asset(p_api_version NUMBER
248: , p_commit VARCHAR2