APPS.PV_ENTITY_ATTRIBUTE_PVT dependencies on DBMS_SQL

Line 722: v_cursor := DBMS_SQL.open_cursor;

718: end loop;
719:
720:
721:
722: v_cursor := DBMS_SQL.open_cursor;
723: --since i am making this more generic, I first check for normal sql statements and for procedures
724: --check for nmormal sql text
725:
726: /*begin

Line 727: DBMS_SQL.parse(v_cursor, ''||p_sql_text ,DBMS_SQL.NATIVE);

723: --since i am making this more generic, I first check for normal sql statements and for procedures
724: --check for nmormal sql text
725:
726: /*begin
727: DBMS_SQL.parse(v_cursor, ''||p_sql_text ,DBMS_SQL.NATIVE);
728:
729: exception
730: when others then
731: l_error_code := ''||SQLCODE;

Line 798: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);

794: --forming sql block to parse the procedure and see if procedure is valid one.
795: if(p_sql_text is not null ) then
796: l_exec_sql_text := 'declare l_out jtf_varchar2_table_4000; begin ' || l_package_name || '(1,l_out);end;';
797: --l_exec_sql_text := 'declare l_out varchar2(500); begin ' || l_package_name || '(1,l_out);end;';
798: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);
799: end if;
800:
801: exception
802: when others then

Line 960: v_cursor := DBMS_SQL.open_cursor;

956: l_lov_string := replace(p_lov_string,'?',':1');
957:
958:
959:
960: v_cursor := DBMS_SQL.open_cursor;
961: --for procedures
962:
963:
964: --this check is for testing for number of parameters that are passing to procedure are 2 .

Line 980: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);

976: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
977: Pvx_Utility_Pvt.debug_message('Private API: ' || 'The query:--' || l_exec_sql_text);
978: END IF;
979:
980: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);
981: */
982:
983: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
984: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before opening cursor' );