APPS.GMF_GLSYNCH dependencies on OP_FOBC_MST

Line 362: exists in op_fobc_mst table */

358: END IF;
359: END; /* Validate_Shipper_Code */
360:
361: /* This function validates that the FOB Codes
362: exists in op_fobc_mst table */
363:
364: PROCEDURE Validate_FOB_Code(
365: pi_table_name in varchar2,
366: pi_key_name in varchar2,

Line 373: FROM op_fobc_mst

369: pi_field_value in out NOCOPY varchar2) IS
370: CURSOR C_Val_FOB_Code (v_of_fob_code in varchar2,
371: v_fob_code out varchar2) IS
372: SELECT fob_code
373: FROM op_fobc_mst
374: WHERE of_fob_code = v_of_fob_code;
375: v_temp_fob_code op_fobc_mst.fob_code%TYPE;
376: BEGIN
377: IF pi_field_value IS NOT NULL THEN

Line 375: v_temp_fob_code op_fobc_mst.fob_code%TYPE;

371: v_fob_code out varchar2) IS
372: SELECT fob_code
373: FROM op_fobc_mst
374: WHERE of_fob_code = v_of_fob_code;
375: v_temp_fob_code op_fobc_mst.fob_code%TYPE;
376: BEGIN
377: IF pi_field_value IS NOT NULL THEN
378: IF C_Val_FOB_Code%ISOPEN THEN
379: CLOSE C_Val_FOB_Code;

Line 925: FROM op_fobc_mst

921:
922: FUNCTION Validate_FOB_Code(pi_field_value varchar2) return boolean IS
923: CURSOR C_Val_FOB_Code (v_of_fob_code in varchar2) IS
924: SELECT 1
925: FROM op_fobc_mst
926: WHERE of_fob_code = v_of_fob_code;
927: BEGIN
928: IF pi_field_value IS NOT NULL THEN
929: IF C_Val_FOB_Code%ISOPEN THEN