DBA Data[Home] [Help]

APPS.JTF_OBJECTS_PUB dependencies on JTF_OBJECTS_B

Line 17: * The metadata are coming from the table 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

Line 37: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,

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,

Line 38: select_name IN jtf_objects_b.select_name%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,

Line 39: select_details IN jtf_objects_b.select_details%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

Line 40: from_table IN jtf_objects_b.from_table%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;

Line 41: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,

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:

Line 42: p_inactive_clause IN jtf_objects_b.inactive_clause%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:
46: /*#

Line 43: order_by_clause IN jtf_objects_b.order_by_clause%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: /*#
47: * Creates the query statement for given metadata. It also checks syntax

Line 79: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,

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,

Line 80: p_select_name IN jtf_objects_b.select_name%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,

Line 81: p_select_details IN jtf_objects_b.select_details%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,

Line 82: p_from_table IN jtf_objects_b.from_table%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,

Line 83: p_where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,

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,

Line 84: p_inactive_clause IN jtf_objects_b.inactive_clause%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,
88: x_msg_data OUT NOCOPY VARCHAR2,

Line 85: p_order_by_clause IN jtf_objects_b.order_by_clause%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,
89: x_sql_statement OUT NOCOPY VARCHAR2