APPS.GMF_GLSYNCH dependencies on OP_FRGT_MTH

Line 401: exists in op_frgt_mth table */

397: END IF;
398: END; /* Validate_FOB_Code */
399:
400: /* This function validates that the Frtbill Method
401: exists in op_frgt_mth table */
402:
403: PROCEDURE Validate_Frtbill_Mthd(
404: pi_table_name in varchar2,
405: pi_key_name in varchar2,

Line 412: FROM op_frgt_mth

408: pi_field_value in out NOCOPY varchar2) IS
409: CURSOR C_Val_Frtbill_Mthd (v_of_Frtbill_Mthd in varchar2,
410: v_Frtbill_Mthd out varchar2) IS
411: SELECT Frtbill_Mthd
412: FROM op_frgt_mth
413: WHERE of_Frtbill_Mthd = v_of_Frtbill_Mthd;
414: v_temp_Frtbill_Mthd op_frgt_mth.Frtbill_Mthd%TYPE;
415: BEGIN
416: IF pi_field_value IS NOT NULL THEN

Line 414: v_temp_Frtbill_Mthd op_frgt_mth.Frtbill_Mthd%TYPE;

410: v_Frtbill_Mthd out varchar2) IS
411: SELECT Frtbill_Mthd
412: FROM op_frgt_mth
413: WHERE of_Frtbill_Mthd = v_of_Frtbill_Mthd;
414: v_temp_Frtbill_Mthd op_frgt_mth.Frtbill_Mthd%TYPE;
415: BEGIN
416: IF pi_field_value IS NOT NULL THEN
417: IF C_Val_Frtbill_Mthd%ISOPEN THEN
418: CLOSE C_Val_Frtbill_Mthd;