22: l_P_SET_DEF_REC CSK_SETUP_UTILITY_PKG.Soln_rec_type;
23: l_P_ELE_DEF_TBL CSK_SETUP_UTILITY_PKG.Stmt_tbl_type;
24: l_P_CAT_DEF_TBL CSK_SETUP_UTILITY_PKG.Cat_tbl_type;
25: BEGIN
26: FND_GLOBAL.APPS_initialize(1000667,21782,170,null,null);
27: CSK_SETUP_UTILITY_PKG.validate_seeded_setups(p_api_version => 1.0,
28: x_return_status => l_return_status,
29: x_msg_count => l_msg_count,
30: x_msg_data => l_msg_data);
185: sqltxt VARCHAR2(2000);
186: dummy_num NUMBER;
187: BEGIN
188: -- If you want to display the output of a Simple SQL query it can be achieved as follows:
189: sqltxt := ' select fnd_global.user_id, fnd_global.USER_NAME '||
190: ' , fnd_global.APPLICATION_SHORT_NAME '||
191: ' , fnd_global.APPLICATION_NAME '||
192: ' , fnd_global.RESP_NAME '||
193: ' from dual ';
186: dummy_num NUMBER;
187: BEGIN
188: -- If you want to display the output of a Simple SQL query it can be achieved as follows:
189: sqltxt := ' select fnd_global.user_id, fnd_global.USER_NAME '||
190: ' , fnd_global.APPLICATION_SHORT_NAME '||
191: ' , fnd_global.APPLICATION_NAME '||
192: ' , fnd_global.RESP_NAME '||
193: ' from dual ';
194: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Current User Information');
187: BEGIN
188: -- If you want to display the output of a Simple SQL query it can be achieved as follows:
189: sqltxt := ' select fnd_global.user_id, fnd_global.USER_NAME '||
190: ' , fnd_global.APPLICATION_SHORT_NAME '||
191: ' , fnd_global.APPLICATION_NAME '||
192: ' , fnd_global.RESP_NAME '||
193: ' from dual ';
194: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Current User Information');
195: END currentUser;
188: -- If you want to display the output of a Simple SQL query it can be achieved as follows:
189: sqltxt := ' select fnd_global.user_id, fnd_global.USER_NAME '||
190: ' , fnd_global.APPLICATION_SHORT_NAME '||
191: ' , fnd_global.APPLICATION_NAME '||
192: ' , fnd_global.RESP_NAME '||
193: ' from dual ';
194: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Current User Information');
195: END currentUser;
196: ------------------