APPS.FTE_VALIDATION_PKG dependencies on FTE_PRC_PARAMETER_DEFAULTS

Line 793: FROM FTE_PRC_PARAMETER_DEFAULTS

789: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_NAME';
790:
791: CURSOR GET_PARAMETER_ID1 (p_type IN VARCHAR2, p_subtype IN VARCHAR2, p_name IN VARCHAR2, p_lane_function IN VARCHAR2) IS
792: SELECT PARAMETER_ID
793: FROM FTE_PRC_PARAMETER_DEFAULTS
794: WHERE parameter_type = p_type
795: AND parameter_sub_type = p_subtype
796: AND parameter_name = p_name
797: AND lane_function in ('NONE', p_lane_function);

Line 801: FROM FTE_PRC_PARAMETER_DEFAULTS

797: AND lane_function in ('NONE', p_lane_function);
798:
799: CURSOR GET_PARAMETER_ID2 (p_type IN VARCHAR2, p_subtype IN VARCHAR2, p_name IN VARCHAR2, p_lane_function IN VARCHAR2) IS
800: SELECT PARAMETER_ID
801: FROM FTE_PRC_PARAMETER_DEFAULTS
802: WHERE parameter_type = p_type
803: AND parameter_sub_type = p_subtype
804: AND parameter_name = p_name
805: AND lane_function = p_lane_function;

Line 3608: FROM FTE_PRC_PARAMETER_DEFAULTS

3604: AND parameter_id = p_parameter_id;
3605:
3606: CURSOR GET_PARAMETER_DATATYPE (p_parameter_id IN NUMBER) IS
3607: SELECT parameter_datatype
3608: FROM FTE_PRC_PARAMETER_DEFAULTS
3609: WHERE parameter_id = p_parameter_id;
3610:
3611: CURSOR GET_FUNCTION(p_lane_id IN NUMBER, p_parameter_id NUMBER) IS
3612: SELECT value_from