JTF_OBJECTS_B.
13: */
14:
15: /*#
16: * Creates the query statement for given metadata.
17: * The metadata are coming from the table JTF_OBJECTS_B
18: * This method returns null if the SQL statement cannot be created.
19: * (for example, the parameter from_table is null).
20: *
21: * @param select_id the source id to be queried
33: * @rep:displayname Create Select Statement
34: * @rep:compatibility N
35: */
36: FUNCTION jtf_obj_select_stmt (
37: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
38: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
39: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
40: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
34: * @rep:compatibility N
35: */
36: FUNCTION jtf_obj_select_stmt (
37: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
38: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
39: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
40: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
42: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
35: */
36: FUNCTION jtf_obj_select_stmt (
37: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
38: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
39: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
40: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
42: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
43: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
36: FUNCTION jtf_obj_select_stmt (
37: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
38: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
39: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
40: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
42: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
43: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
44: ) RETURN VARCHAR2;
37: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
38: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
39: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
40: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
42: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
43: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
44: ) RETURN VARCHAR2;
45:
38: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
39: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
40: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
42: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
43: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
44: ) RETURN VARCHAR2;
45:
46: /*#
39: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
40: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
42: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
43: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
44: ) RETURN VARCHAR2;
45:
46: /*#
47: * Creates the query statement for given metadata. It also checks syntax
75: PROCEDURE check_syntax (
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
78: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
80: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
81: p_select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
82: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
78: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
80: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
81: p_select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
82: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
84: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
77: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
78: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
80: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
81: p_select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
82: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
84: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
85: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL,
78: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
80: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
81: p_select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
82: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
84: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
85: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL,
86: x_return_status OUT NOCOPY VARCHAR2,
79: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
80: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
81: p_select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
82: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
84: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
85: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
80: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
81: p_select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
82: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
84: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
85: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
81: p_select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
82: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
84: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
85: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: x_sql_statement OUT NOCOPY VARCHAR2