APPS.ZX_RATES_PKG dependencies on FND_LOOKUP_VALUES

Line 9: -- Description : Updating the table: FND_LOOKUP_VALUES for columns: Description and Meaning

5: ----------------------------------------------------------------------------------------------------------
6: -- Start of comments
7:
8: -- Procedure Name : UPDATE_LOOKUP_VALUES
9: -- Description : Updating the table: FND_LOOKUP_VALUES for columns: Description and Meaning
10: -- Business Rules :
11: -- Parameters : LOOKUP_TYPE,TAX_RATE_CODE,DESCRIPTION, MEANING and one OUT parameter RETURN_STATUS
12: -- Version :
13: -- End of comments

Line 29: -- updating the description field in fnd_lookup values

25:
26: BEGIN
27: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
28:
29: -- updating the description field in fnd_lookup values
30: UPDATE FND_LOOKUP_VALUES
31: SET description=P_DESCRIPTION,
32: meaning = Nvl(P_MEANING, P_TAX_RATE_CODE),
33: last_update_date = SYSDATE,

Line 30: UPDATE FND_LOOKUP_VALUES

26: BEGIN
27: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
28:
29: -- updating the description field in fnd_lookup values
30: UPDATE FND_LOOKUP_VALUES
31: SET description=P_DESCRIPTION,
32: meaning = Nvl(P_MEANING, P_TAX_RATE_CODE),
33: last_update_date = SYSDATE,
34: last_updated_by = FND_GLOBAL.user_id,

Line 793: Updating the description column in the fnd_lookup_values. For rate code of type:RECOVERY, it will not update.

789:
790:
791: --START bug#6992215
792: /*
793: Updating the description column in the fnd_lookup_values. For rate code of type:RECOVERY, it will not update.
794: */
795: IF (X_RATE_TYPE_CODE <> 'RECOVERY') then
796: UPDATE_LOOKUP_VALUES(
797: 'ZX_INPUT_CLASSIFICATIONS' ,

Line 961: MERGE INTO FND_LOOKUP_VALUES

957: begin
958:
959:
960:
961: MERGE INTO FND_LOOKUP_VALUES
962: USING (SELECT INSTALLED_FLAG,LANGUAGE_CODE FROM FND_LANGUAGES where INSTALLED_FLAG in ('I', 'B')) L
963: ON ( LOOKUP_TYPE = X_LOOKUP_TYPE and
964: LOOKUP_CODE = NVL(TAG,X_TAX_RATE_CODE)and
965: VIEW_APPLICATION_ID='0' and