APPS.JTF_OBJECTS_PUB dependencies on JTF_OBJECTS_B

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

15: G_OBJECT_PG_TBL OBJECT_PG_TBL;
16:
17:
18: FUNCTION jtf_obj_select_stmt (
19: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
20: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
23: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,

Line 20: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,

16:
17:
18: FUNCTION jtf_obj_select_stmt (
19: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
20: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
23: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
24: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,

Line 21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,

17:
18: FUNCTION jtf_obj_select_stmt (
19: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
20: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
23: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
24: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
25: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL

Line 22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,

18: FUNCTION jtf_obj_select_stmt (
19: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
20: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
23: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
24: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
25: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
26: )

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

19: select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
20: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
23: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
24: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
25: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
26: )
27: RETURN VARCHAR2

Line 24: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,

20: select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
23: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
24: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
25: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
26: )
27: RETURN VARCHAR2
28: IS

Line 25: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL

21: select_details IN jtf_objects_b.select_details%TYPE DEFAULT NULL,
22: from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
23: where_clause IN jtf_objects_b.where_clause%TYPE DEFAULT NULL,
24: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL,
25: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
26: )
27: RETURN VARCHAR2
28: IS
29: l_select_id jtf_objects_b.select_id%TYPE := select_id;

Line 29: l_select_id jtf_objects_b.select_id%TYPE := select_id;

25: order_by_clause IN jtf_objects_b.order_by_clause%TYPE DEFAULT NULL
26: )
27: RETURN VARCHAR2
28: IS
29: l_select_id jtf_objects_b.select_id%TYPE := select_id;
30: l_select_name jtf_objects_b.select_name%TYPE := select_name;
31: l_select_details jtf_objects_b.select_details%TYPE
32: := select_details;
33: l_from_table jtf_objects_b.from_table%TYPE := from_table;

Line 30: l_select_name jtf_objects_b.select_name%TYPE := select_name;

26: )
27: RETURN VARCHAR2
28: IS
29: l_select_id jtf_objects_b.select_id%TYPE := select_id;
30: l_select_name jtf_objects_b.select_name%TYPE := select_name;
31: l_select_details jtf_objects_b.select_details%TYPE
32: := select_details;
33: l_from_table jtf_objects_b.from_table%TYPE := from_table;
34: l_where_clause jtf_objects_b.where_clause%TYPE := where_clause;

Line 31: l_select_details jtf_objects_b.select_details%TYPE

27: RETURN VARCHAR2
28: IS
29: l_select_id jtf_objects_b.select_id%TYPE := select_id;
30: l_select_name jtf_objects_b.select_name%TYPE := select_name;
31: l_select_details jtf_objects_b.select_details%TYPE
32: := select_details;
33: l_from_table jtf_objects_b.from_table%TYPE := from_table;
34: l_where_clause jtf_objects_b.where_clause%TYPE := where_clause;
35: l_order_by_clause jtf_objects_b.order_by_clause%TYPE

Line 33: l_from_table jtf_objects_b.from_table%TYPE := from_table;

29: l_select_id jtf_objects_b.select_id%TYPE := select_id;
30: l_select_name jtf_objects_b.select_name%TYPE := select_name;
31: l_select_details jtf_objects_b.select_details%TYPE
32: := select_details;
33: l_from_table jtf_objects_b.from_table%TYPE := from_table;
34: l_where_clause jtf_objects_b.where_clause%TYPE := where_clause;
35: l_order_by_clause jtf_objects_b.order_by_clause%TYPE
36: := order_by_clause;
37: --l_select_statement VARCHAR2(6000);

Line 34: l_where_clause jtf_objects_b.where_clause%TYPE := where_clause;

30: l_select_name jtf_objects_b.select_name%TYPE := select_name;
31: l_select_details jtf_objects_b.select_details%TYPE
32: := select_details;
33: l_from_table jtf_objects_b.from_table%TYPE := from_table;
34: l_where_clause jtf_objects_b.where_clause%TYPE := where_clause;
35: l_order_by_clause jtf_objects_b.order_by_clause%TYPE
36: := order_by_clause;
37: --l_select_statement VARCHAR2(6000);
38: str VARCHAR2(6000);

Line 35: l_order_by_clause jtf_objects_b.order_by_clause%TYPE

31: l_select_details jtf_objects_b.select_details%TYPE
32: := select_details;
33: l_from_table jtf_objects_b.from_table%TYPE := from_table;
34: l_where_clause jtf_objects_b.where_clause%TYPE := where_clause;
35: l_order_by_clause jtf_objects_b.order_by_clause%TYPE
36: := order_by_clause;
37: --l_select_statement VARCHAR2(6000);
38: str VARCHAR2(6000);
39: initialized BOOLEAN := FALSE;

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

112: PROCEDURE check_syntax (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
118: p_select_details IN jtf_objects_b.select_details%TYPE
119: DEFAULT NULL,
120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,

Line 117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,

113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
118: p_select_details IN jtf_objects_b.select_details%TYPE
119: DEFAULT NULL,
120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
121: p_where_clause IN jtf_objects_b.where_clause%TYPE

Line 118: p_select_details IN jtf_objects_b.select_details%TYPE

114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
118: p_select_details IN jtf_objects_b.select_details%TYPE
119: DEFAULT NULL,
120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
121: p_where_clause IN jtf_objects_b.where_clause%TYPE
122: DEFAULT NULL,

Line 120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,

116: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
118: p_select_details IN jtf_objects_b.select_details%TYPE
119: DEFAULT NULL,
120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
121: p_where_clause IN jtf_objects_b.where_clause%TYPE
122: DEFAULT NULL,
123: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL, -- Added for Bug# 2557586
124: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE

Line 121: p_where_clause IN jtf_objects_b.where_clause%TYPE

117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
118: p_select_details IN jtf_objects_b.select_details%TYPE
119: DEFAULT NULL,
120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
121: p_where_clause IN jtf_objects_b.where_clause%TYPE
122: DEFAULT NULL,
123: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL, -- Added for Bug# 2557586
124: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE
125: DEFAULT NULL,

Line 123: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL, -- Added for Bug# 2557586

119: DEFAULT NULL,
120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
121: p_where_clause IN jtf_objects_b.where_clause%TYPE
122: DEFAULT NULL,
123: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL, -- Added for Bug# 2557586
124: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE
125: DEFAULT NULL,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,

Line 124: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE

120: p_from_table IN jtf_objects_b.from_table%TYPE DEFAULT NULL,
121: p_where_clause IN jtf_objects_b.where_clause%TYPE
122: DEFAULT NULL,
123: p_inactive_clause IN jtf_objects_b.inactive_clause%TYPE DEFAULT NULL, -- Added for Bug# 2557586
124: p_order_by_clause IN jtf_objects_b.order_by_clause%TYPE
125: DEFAULT NULL,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,

Line 135: l_select_id jtf_objects_b.select_id%TYPE

131: IS
132: l_api_name VARCHAR2(240)
133: := 'CHECK_SYNTAX';
134: l_api_version NUMBER := 1.0;
135: l_select_id jtf_objects_b.select_id%TYPE
136: := p_select_id;
137: l_select_name jtf_objects_b.select_name%TYPE
138: := p_select_name;
139: l_select_details jtf_objects_b.select_details%TYPE

Line 137: l_select_name jtf_objects_b.select_name%TYPE

133: := 'CHECK_SYNTAX';
134: l_api_version NUMBER := 1.0;
135: l_select_id jtf_objects_b.select_id%TYPE
136: := p_select_id;
137: l_select_name jtf_objects_b.select_name%TYPE
138: := p_select_name;
139: l_select_details jtf_objects_b.select_details%TYPE
140: := p_select_details;
141: l_from_table jtf_objects_b.from_table%TYPE

Line 139: l_select_details jtf_objects_b.select_details%TYPE

135: l_select_id jtf_objects_b.select_id%TYPE
136: := p_select_id;
137: l_select_name jtf_objects_b.select_name%TYPE
138: := p_select_name;
139: l_select_details jtf_objects_b.select_details%TYPE
140: := p_select_details;
141: l_from_table jtf_objects_b.from_table%TYPE
142: := p_from_table;
143: l_where_clause jtf_objects_b.where_clause%TYPE

Line 141: l_from_table jtf_objects_b.from_table%TYPE

137: l_select_name jtf_objects_b.select_name%TYPE
138: := p_select_name;
139: l_select_details jtf_objects_b.select_details%TYPE
140: := p_select_details;
141: l_from_table jtf_objects_b.from_table%TYPE
142: := p_from_table;
143: l_where_clause jtf_objects_b.where_clause%TYPE
144: := p_where_clause;
145: l_order_by_clause jtf_objects_b.order_by_clause%TYPE

Line 143: l_where_clause jtf_objects_b.where_clause%TYPE

139: l_select_details jtf_objects_b.select_details%TYPE
140: := p_select_details;
141: l_from_table jtf_objects_b.from_table%TYPE
142: := p_from_table;
143: l_where_clause jtf_objects_b.where_clause%TYPE
144: := p_where_clause;
145: l_order_by_clause jtf_objects_b.order_by_clause%TYPE
146: := p_order_by_clause;
147: --x_sql_statement VARCHAR2(6000);

Line 145: l_order_by_clause jtf_objects_b.order_by_clause%TYPE

141: l_from_table jtf_objects_b.from_table%TYPE
142: := p_from_table;
143: l_where_clause jtf_objects_b.where_clause%TYPE
144: := p_where_clause;
145: l_order_by_clause jtf_objects_b.order_by_clause%TYPE
146: := p_order_by_clause;
147: --x_sql_statement VARCHAR2(6000);
148: str VARCHAR2(6000);
149: l_select_columns NUMBER := 0;

Line 316: FROM JTF_OBJECTS_B JOB

312: SELECT 1 AS OBJ_ROW_TYPE
313: , JOPD.PG_REGION_PATH
314: , JOPP.DEST_PARAM
315: , JOPP.SOURCE_PARAM
316: FROM JTF_OBJECTS_B JOB
317: , JTF_OBJECT_PG_DTLS JOPD
318: , JTF_OBJECT_PG_PARAMS JOPP
319: WHERE JOB.OBJECT_CODE = b_object_code
320: AND JOPD.OBJECT_CODE = JOB.OBJECT_CODE

Line 329: FROM JTF_OBJECTS_B JOB

325: SELECT 2 AS OBJ_ROW_TYPE
326: , JOPD.PG_REGION_PATH
327: , JOPP.DEST_PARAM
328: , JOPP.SOURCE_PARAM
329: FROM JTF_OBJECTS_B JOB
330: , JTF_OBJECT_PG_DTLS JOPD
331: , JTF_OBJECT_PG_PARAMS JOPP
332: WHERE JOB.OBJECT_CODE = b_default_object_code
333: AND JOPD.OBJECT_CODE = JOB.OBJECT_CODE