DBA Data[Home] [Help]

APPS.IEU_PVT dependencies on JTF_OBJECTS_B

Line 2887: l_select_id JTF_OBJECTS_B.SELECT_ID%TYPE;

2883: l_sql_stmt VARCHAR2(1000);
2884: l_count NUMBER;
2885: l_count1 NUMBER; --Added for bug7149127
2886: l_obj_code_flag VARCHAR2(1);
2887: l_select_id JTF_OBJECTS_B.SELECT_ID%TYPE;
2888: l_select_name JTF_OBJECTS_B.SELECT_NAME%TYPE;
2889: l_select_details JTF_OBJECTS_B.SELECT_DETAILS%TYPE;
2890: l_from_table JTF_OBJECTS_B.FROM_TABLE%TYPE;
2891: l_where_Clause JTF_OBJECTS_B.WHERE_CLAUSE%TYPE;

Line 2888: l_select_name JTF_OBJECTS_B.SELECT_NAME%TYPE;

2884: l_count NUMBER;
2885: l_count1 NUMBER; --Added for bug7149127
2886: l_obj_code_flag VARCHAR2(1);
2887: l_select_id JTF_OBJECTS_B.SELECT_ID%TYPE;
2888: l_select_name JTF_OBJECTS_B.SELECT_NAME%TYPE;
2889: l_select_details JTF_OBJECTS_B.SELECT_DETAILS%TYPE;
2890: l_from_table JTF_OBJECTS_B.FROM_TABLE%TYPE;
2891: l_where_Clause JTF_OBJECTS_B.WHERE_CLAUSE%TYPE;
2892:

Line 2889: l_select_details JTF_OBJECTS_B.SELECT_DETAILS%TYPE;

2885: l_count1 NUMBER; --Added for bug7149127
2886: l_obj_code_flag VARCHAR2(1);
2887: l_select_id JTF_OBJECTS_B.SELECT_ID%TYPE;
2888: l_select_name JTF_OBJECTS_B.SELECT_NAME%TYPE;
2889: l_select_details JTF_OBJECTS_B.SELECT_DETAILS%TYPE;
2890: l_from_table JTF_OBJECTS_B.FROM_TABLE%TYPE;
2891: l_where_Clause JTF_OBJECTS_B.WHERE_CLAUSE%TYPE;
2892:
2893: BEGIN

Line 2890: l_from_table JTF_OBJECTS_B.FROM_TABLE%TYPE;

2886: l_obj_code_flag VARCHAR2(1);
2887: l_select_id JTF_OBJECTS_B.SELECT_ID%TYPE;
2888: l_select_name JTF_OBJECTS_B.SELECT_NAME%TYPE;
2889: l_select_details JTF_OBJECTS_B.SELECT_DETAILS%TYPE;
2890: l_from_table JTF_OBJECTS_B.FROM_TABLE%TYPE;
2891: l_where_Clause JTF_OBJECTS_B.WHERE_CLAUSE%TYPE;
2892:
2893: BEGIN
2894:

Line 2891: l_where_Clause JTF_OBJECTS_B.WHERE_CLAUSE%TYPE;

2887: l_select_id JTF_OBJECTS_B.SELECT_ID%TYPE;
2888: l_select_name JTF_OBJECTS_B.SELECT_NAME%TYPE;
2889: l_select_details JTF_OBJECTS_B.SELECT_DETAILS%TYPE;
2890: l_from_table JTF_OBJECTS_B.FROM_TABLE%TYPE;
2891: l_where_Clause JTF_OBJECTS_B.WHERE_CLAUSE%TYPE;
2892:
2893: BEGIN
2894:
2895: l_obj_code_flag := 'T';

Line 2899: FROM jtf_objects_b

2895: l_obj_code_flag := 'T';
2896: BEGIN
2897: SELECT select_id, select_name, select_details, from_table,where_clause
2898: INTO l_select_id,l_select_name, l_select_details, l_from_table, l_where_clause
2899: FROM jtf_objects_b
2900: WHERE object_code = 'AOMANMODE';
2901: EXCEPTION
2902: WHEN OTHERS THEN
2903: l_count := 0;