APPS.WIP_VALIDATE dependencies on STANDARD

Line 501: FND_API.g_attr_tbl(I).name := 'standard_rate';

497: FND_API.g_attr_tbl(I).name := 'resource_seq_num';
498: I := I + 1;
499: FND_API.g_attr_tbl(I).name := 'resource_type';
500: I := I + 1;
501: FND_API.g_attr_tbl(I).name := 'standard_rate';
502: I := I + 1;
503: FND_API.g_attr_tbl(I).name := 'task_number';
504: I := I + 1;
505: FND_API.g_attr_tbl(I).name := 'transaction';

Line 8305: FUNCTION Standard_Rate ( p_standard_rate_flag IN NUMBER )

8301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8302:
8303: END Resource_Type;
8304:
8305: FUNCTION Standard_Rate ( p_standard_rate_flag IN NUMBER )
8306: RETURN BOOLEAN
8307: IS
8308: l_dummy VARCHAR2(10);
8309: BEGIN

Line 8311: IF p_standard_rate_flag IS NULL OR

8307: IS
8308: l_dummy VARCHAR2(10);
8309: BEGIN
8310:
8311: IF p_standard_rate_flag IS NULL OR
8312: p_standard_rate_flag = FND_API.G_MISS_NUM
8313: THEN
8314: RETURN TRUE;
8315: END IF;

Line 8312: p_standard_rate_flag = FND_API.G_MISS_NUM

8308: l_dummy VARCHAR2(10);
8309: BEGIN
8310:
8311: IF p_standard_rate_flag IS NULL OR
8312: p_standard_rate_flag = FND_API.G_MISS_NUM
8313: THEN
8314: RETURN TRUE;
8315: END IF;
8316:

Line 8321: AND lookup_code = p_standard_rate_flag;

8317: SELECT 'VALID'
8318: INTO l_dummy
8319: FROM MFG_LOOKUPS
8320: WHERE lookup_type = 'SYS_YES_NO'
8321: AND lookup_code = p_standard_rate_flag;
8322:
8323: RETURN TRUE;
8324:
8325: EXCEPTION

Line 8333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','standard_rate');

8329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8330: THEN
8331:
8332: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
8333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','standard_rate');
8334: FND_MSG_PUB.Add;
8335:
8336: END IF;
8337:

Line 8346: , 'Standard_Rate'

8342: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8343: THEN
8344: FND_MSG_PUB.Add_Exc_Msg
8345: ( G_PKG_NAME
8346: , 'Standard_Rate'
8347: );
8348: END IF;
8349:
8350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8352: END Standard_Rate;

8348: END IF;
8349:
8350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8351:
8352: END Standard_Rate;
8353:
8354: FUNCTION Task_Number ( p_task_number IN VARCHAR2 )
8355: RETURN BOOLEAN
8356: IS

Line 8665: FROM bom_standard_operations

8661:
8662:
8663: SELECT 'VALID'
8664: INTO l_dummy
8665: FROM bom_standard_operations
8666: WHERE operation_code = p_operation_code;
8667:
8668: RETURN TRUE;
8669:

Line 9109: FROM bom_standard_operations

9105: END IF;
9106:
9107: SELECT 'VALID'
9108: INTO l_dummy
9109: FROM bom_standard_operations
9110: WHERE operation_code = p_to_operation_code;
9111:
9112: RETURN TRUE;
9113: