APPS.JAI_MTL_TRXS_PKG dependencies on USER_PROCEDURES

Line 2869: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type ,

2865: SELECT * from jai_mtl_Trxs
2866: WHERE transaction_Temp_id = cp_Trx_temp_id;
2867:
2868:
2869: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type ,
2870: cp_procedure_name user_procedures.procedure_name%type) IS
2871:
2872: SELECT 1
2873: FROM user_procedures

Line 2870: cp_procedure_name user_procedures.procedure_name%type) IS

2866: WHERE transaction_Temp_id = cp_Trx_temp_id;
2867:
2868:
2869: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type ,
2870: cp_procedure_name user_procedures.procedure_name%type) IS
2871:
2872: SELECT 1
2873: FROM user_procedures
2874: WHERE object_name = cp_object_name

Line 2873: FROM user_procedures

2869: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type ,
2870: cp_procedure_name user_procedures.procedure_name%type) IS
2871:
2872: SELECT 1
2873: FROM user_procedures
2874: WHERE object_name = cp_object_name
2875: AND procedure_name = cp_procedure_name ;
2876:
2877: /*rchandan for bug#6487489..start*/

Line 2916: lv_object_name user_procedures.object_name%type ;

2912: ln_non_modvat_amt NUMBER;
2913: ln_oth_modvat_amt NUMBER;
2914: lv_process_msg VARCHAR2(2000);
2915: lv_process_status VARCHAR2(20);
2916: lv_object_name user_procedures.object_name%type ;
2917: lv_procedure_name user_procedures.procedure_name%type ;
2918: ln_exists NUMBER := 0 ;
2919: lv_sqlstmt VARCHAR2(2000) ;
2920: ln_retval NUMBER;

Line 2917: lv_procedure_name user_procedures.procedure_name%type ;

2913: ln_oth_modvat_amt NUMBER;
2914: lv_process_msg VARCHAR2(2000);
2915: lv_process_status VARCHAR2(20);
2916: lv_object_name user_procedures.object_name%type ;
2917: lv_procedure_name user_procedures.procedure_name%type ;
2918: ln_exists NUMBER := 0 ;
2919: lv_sqlstmt VARCHAR2(2000) ;
2920: ln_retval NUMBER;
2921: lv_return_status VARCHAR2(10);