eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on DBMS_SQL

Line 2895: l_cursor := dbms_sql.open_cursor;

2891: ------------------------------------------
2892: -- Dynamic Call
2893: ------------------------------------------
2894: -- Create the SQL statement
2895: l_cursor := dbms_sql.open_cursor;
2896: l_sqlstmt := 'BEGIN :Curr_BaL := ' ||
2897: 'ap_utilities_pkg.get_auto_offsets_segments (:l_code_combination_id); END;';
2898:
2899: -- Parse the SQL statement

Line 2900: dbms_sql.parse (l_cursor, l_sqlstmt, dbms_sql.native);

2896: l_sqlstmt := 'BEGIN :Curr_BaL := ' ||
2897: 'ap_utilities_pkg.get_auto_offsets_segments (:l_code_combination_id); END;';
2898:
2899: -- Parse the SQL statement
2900: dbms_sql.parse (l_cursor, l_sqlstmt, dbms_sql.native);
2901:
2902: -- Define the variables
2903: dbms_sql.bind_variable (l_cursor, 'Curr_BaL', Curr_BaL,200);
2904: dbms_sql.bind_variable (l_cursor, 'l_code_combination_id', P_ccid);

Line 2903: dbms_sql.bind_variable (l_cursor, 'Curr_BaL', Curr_BaL,200);

2899: -- Parse the SQL statement
2900: dbms_sql.parse (l_cursor, l_sqlstmt, dbms_sql.native);
2901:
2902: -- Define the variables
2903: dbms_sql.bind_variable (l_cursor, 'Curr_BaL', Curr_BaL,200);
2904: dbms_sql.bind_variable (l_cursor, 'l_code_combination_id', P_ccid);
2905:
2906: -- Execute the SQL statement
2907: l_ignore := dbms_sql.execute (l_cursor);

Line 2904: dbms_sql.bind_variable (l_cursor, 'l_code_combination_id', P_ccid);

2900: dbms_sql.parse (l_cursor, l_sqlstmt, dbms_sql.native);
2901:
2902: -- Define the variables
2903: dbms_sql.bind_variable (l_cursor, 'Curr_BaL', Curr_BaL,200);
2904: dbms_sql.bind_variable (l_cursor, 'l_code_combination_id', P_ccid);
2905:
2906: -- Execute the SQL statement
2907: l_ignore := dbms_sql.execute (l_cursor);
2908:

Line 2907: l_ignore := dbms_sql.execute (l_cursor);

2903: dbms_sql.bind_variable (l_cursor, 'Curr_BaL', Curr_BaL,200);
2904: dbms_sql.bind_variable (l_cursor, 'l_code_combination_id', P_ccid);
2905:
2906: -- Execute the SQL statement
2907: l_ignore := dbms_sql.execute (l_cursor);
2908:
2909: -- Get the return value (success)
2910: dbms_sql.variable_value (l_cursor, 'Curr_BaL', Curr_BaL);
2911:

Line 2910: dbms_sql.variable_value (l_cursor, 'Curr_BaL', Curr_BaL);

2906: -- Execute the SQL statement
2907: l_ignore := dbms_sql.execute (l_cursor);
2908:
2909: -- Get the return value (success)
2910: dbms_sql.variable_value (l_cursor, 'Curr_BaL', Curr_BaL);
2911:
2912: -- Close the cursor
2913: dbms_sql.close_cursor (l_cursor);
2914:

Line 2913: dbms_sql.close_cursor (l_cursor);

2909: -- Get the return value (success)
2910: dbms_sql.variable_value (l_cursor, 'Curr_BaL', Curr_BaL);
2911:
2912: -- Close the cursor
2913: dbms_sql.close_cursor (l_cursor);
2914:
2915: -- Function Return Values
2916: return (Curr_Bal);
2917:

Line 2920: IF (dbms_sql.is_open(l_cursor)) THEN

2916: return (Curr_Bal);
2917:
2918: EXCEPTION
2919: WHEN others THEN
2920: IF (dbms_sql.is_open(l_cursor)) THEN
2921: dbms_sql.close_cursor(l_cursor);
2922: END IF;
2923: return (Curr_Bal);
2924: END Dynamic_Call_Get_BalSeg;

Line 2921: dbms_sql.close_cursor(l_cursor);

2917:
2918: EXCEPTION
2919: WHEN others THEN
2920: IF (dbms_sql.is_open(l_cursor)) THEN
2921: dbms_sql.close_cursor(l_cursor);
2922: END IF;
2923: return (Curr_Bal);
2924: END Dynamic_Call_Get_BalSeg;
2925: