APPS.FV_CGAC_CRT_TAS dependencies on DBMS_SQL

Line 1011: l_bud_dtl_cursor := DBMS_SQL.OPEN_CURSOR ;

1007: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_update_query);
1008: END IF;
1009:
1010: BEGIN
1011: l_bud_dtl_cursor := DBMS_SQL.OPEN_CURSOR ;
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: errbuf := sqlerrm || ' Budget Detail - Open Cursor ' ;
1015: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.open_l_bud_dtl_cursor', errbuf) ;

Line 1022: dbms_sql.parse(l_bud_dtl_cursor, l_update_query, DBMS_SQL.V7) ;

1018: RETURN;
1019: END ;
1020:
1021: BEGIN
1022: dbms_sql.parse(l_bud_dtl_cursor, l_update_query, DBMS_SQL.V7) ;
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: errbuf := sqlerrm || ' Budget Detail - Parse ' ;
1026: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.parsel_bud_dtl_cursor', errbuf) ;

Line 1033: l_exec_ret := dbms_sql.execute(l_bud_dtl_cursor);

1029: RETURN;
1030: END ;
1031:
1032: BEGIN
1033: l_exec_ret := dbms_sql.execute(l_bud_dtl_cursor);
1034: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.execute_bud_dtl_cursor', 'update statement executed') ;
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: errbuf := sqlerrm || ' Budget Detail - Execute Cursor ' ;

Line 1045: dbms_sql.Close_Cursor(l_bud_dtl_cursor);

1041: RETURN;
1042: END ;
1043:
1044: BEGIN
1045: dbms_sql.Close_Cursor(l_bud_dtl_cursor);
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: errbuf := sqlerrm ;
1049: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.close_bud_dtl_cursor',errbuf) ;