eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_RATES_PKG dependencies on FND_LOOKUP_VALUES

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

5: ------------------------------------------------------------------------
6: -- Start of comments
7:
8: -- Procedure Name : UPDATE_LOOKUP_VALUES
9: -- Description : Updating the table: FND_LOOKUP_VALUES for columns:
10: -- Description and Meaning
11: -- Business Rules :
12: -- Parameters : IN LOOKUP_TYPE,TAX_RATE_CODE,DESCRIPTION, MEANING,
13: -- P_EFFECTIVE_FROM, P_EFFECTIVE_TO

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

28:
29: BEGIN
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: -- updating the description field in fnd_lookup values
33: UPDATE fnd_lookup_values
34: SET description = P_TAX_RATE_CODE,
35: meaning = P_TAX_RATE_CODE,
36: -- end_date_active = P_EFFECTIVE_TO, -- commenting for bug 9705409

Line 33: UPDATE fnd_lookup_values

29: BEGIN
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: -- updating the description field in fnd_lookup values
33: UPDATE fnd_lookup_values
34: SET description = P_TAX_RATE_CODE,
35: meaning = P_TAX_RATE_CODE,
36: -- end_date_active = P_EFFECTIVE_TO, -- commenting for bug 9705409
37: last_update_date = SYSDATE,

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

937: if (sql%notfound) then
938: raise no_data_found;
939: end if;
940:
941: -- Updating the description column in the fnd_lookup_values. For rate code of type:RECOVERY, it will not update.
942: IF (X_RATE_TYPE_CODE <> 'RECOVERY') THEN
943:
944: -- bug 15972190 : no need to update description column in fnd_lookup_values
945: -- logic incorporated into the views to pick description from appropriate tables

Line 944: -- bug 15972190 : no need to update description column in fnd_lookup_values

940:
941: -- Updating the description column in the fnd_lookup_values. For rate code of type:RECOVERY, it will not update.
942: IF (X_RATE_TYPE_CODE <> 'RECOVERY') THEN
943:
944: -- bug 15972190 : no need to update description column in fnd_lookup_values
945: -- logic incorporated into the views to pick description from appropriate tables
946: /***
947: UPDATE_LOOKUP_VALUES_PVT(
948: 'ZX_INPUT_CLASSIFICATIONS' ,

Line 1117: CURSOR cur_fnd_lookup_values (cp_lookup_type IN VARCHAR2

1113: X_TAX_RATE_NAME IN VARCHAR2 DEFAULT NULL --bug#7274382 added default
1114: -- end bug#6992215
1115: ) is
1116:
1117: CURSOR cur_fnd_lookup_values (cp_lookup_type IN VARCHAR2
1118: ,cp_tax_rate_code IN VARCHAR2
1119: ) IS
1120: SELECT *
1121: FROM fnd_lookup_values

Line 1121: FROM fnd_lookup_values

1117: CURSOR cur_fnd_lookup_values (cp_lookup_type IN VARCHAR2
1118: ,cp_tax_rate_code IN VARCHAR2
1119: ) IS
1120: SELECT *
1121: FROM fnd_lookup_values
1122: WHERE lookup_type = cp_lookup_type
1123: AND lookup_code = NVL(TAG,cp_tax_rate_code)
1124: AND view_application_id = 0
1125: AND security_group_id = 0

Line 1128: l_fnd_lookup_values_rec fnd_lookup_values%ROWTYPE;

1124: AND view_application_id = 0
1125: AND security_group_id = 0
1126: AND ROWNUM = 1;
1127:
1128: l_fnd_lookup_values_rec fnd_lookup_values%ROWTYPE;
1129: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1130: l_tag fnd_lookup_values.lookup_code%TYPE;
1131: l_rowid VARCHAR2(200);
1132:

Line 1129: l_lookup_code fnd_lookup_values.lookup_code%TYPE;

1125: AND security_group_id = 0
1126: AND ROWNUM = 1;
1127:
1128: l_fnd_lookup_values_rec fnd_lookup_values%ROWTYPE;
1129: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1130: l_tag fnd_lookup_values.lookup_code%TYPE;
1131: l_rowid VARCHAR2(200);
1132:
1133: BEGIN

Line 1130: l_tag fnd_lookup_values.lookup_code%TYPE;

1126: AND ROWNUM = 1;
1127:
1128: l_fnd_lookup_values_rec fnd_lookup_values%ROWTYPE;
1129: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1130: l_tag fnd_lookup_values.lookup_code%TYPE;
1131: l_rowid VARCHAR2(200);
1132:
1133: BEGIN
1134:

Line 1135: OPEN cur_fnd_lookup_values (cp_lookup_type => X_LOOKUP_TYPE

1131: l_rowid VARCHAR2(200);
1132:
1133: BEGIN
1134:
1135: OPEN cur_fnd_lookup_values (cp_lookup_type => X_LOOKUP_TYPE
1136: ,cp_tax_rate_code => X_TAX_RATE_CODE
1137: );
1138: FETCH cur_fnd_lookup_values INTO l_fnd_lookup_values_rec;
1139: IF cur_fnd_lookup_values%FOUND THEN

Line 1138: FETCH cur_fnd_lookup_values INTO l_fnd_lookup_values_rec;

1134:
1135: OPEN cur_fnd_lookup_values (cp_lookup_type => X_LOOKUP_TYPE
1136: ,cp_tax_rate_code => X_TAX_RATE_CODE
1137: );
1138: FETCH cur_fnd_lookup_values INTO l_fnd_lookup_values_rec;
1139: IF cur_fnd_lookup_values%FOUND THEN
1140: CLOSE cur_fnd_lookup_values;
1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type

Line 1139: IF cur_fnd_lookup_values%FOUND THEN

1135: OPEN cur_fnd_lookup_values (cp_lookup_type => X_LOOKUP_TYPE
1136: ,cp_tax_rate_code => X_TAX_RATE_CODE
1137: );
1138: FETCH cur_fnd_lookup_values INTO l_fnd_lookup_values_rec;
1139: IF cur_fnd_lookup_values%FOUND THEN
1140: CLOSE cur_fnd_lookup_values;
1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id

Line 1140: CLOSE cur_fnd_lookup_values;

1136: ,cp_tax_rate_code => X_TAX_RATE_CODE
1137: );
1138: FETCH cur_fnd_lookup_values INTO l_fnd_lookup_values_rec;
1139: IF cur_fnd_lookup_values%FOUND THEN
1140: CLOSE cur_fnd_lookup_values;
1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id

Line 1141: fnd_lookup_values_pkg.update_row (

1137: );
1138: FETCH cur_fnd_lookup_values INTO l_fnd_lookup_values_rec;
1139: IF cur_fnd_lookup_values%FOUND THEN
1140: CLOSE cur_fnd_lookup_values;
1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code

Line 1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type

1138: FETCH cur_fnd_lookup_values INTO l_fnd_lookup_values_rec;
1139: IF cur_fnd_lookup_values%FOUND THEN
1140: CLOSE cur_fnd_lookup_values;
1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag

Line 1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id

1139: IF cur_fnd_lookup_values%FOUND THEN
1140: CLOSE cur_fnd_lookup_values;
1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category

Line 1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id

1140: CLOSE cur_fnd_lookup_values;
1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1

Line 1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code

1141: fnd_lookup_values_pkg.update_row (
1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2

Line 1146: ,x_tag => l_fnd_lookup_values_rec.tag

1142: x_lookup_type => l_fnd_lookup_values_rec.lookup_type
1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3

Line 1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category

1143: ,x_security_group_id => l_fnd_lookup_values_rec.security_group_id
1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3
1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4

Line 1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1

1144: ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3
1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4
1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag

Line 1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2

1145: ,x_lookup_code => l_fnd_lookup_values_rec.lookup_code
1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3
1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4
1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag
1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active

Line 1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3

1146: ,x_tag => l_fnd_lookup_values_rec.tag
1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3
1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4
1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag
1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active
1154: ,x_end_date_active => NULL

Line 1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4

1147: ,x_attribute_category => l_fnd_lookup_values_rec.attribute_category
1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3
1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4
1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag
1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active
1154: ,x_end_date_active => NULL
1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code

Line 1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag

1148: ,x_attribute1 => l_fnd_lookup_values_rec.attribute1
1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3
1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4
1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag
1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active
1154: ,x_end_date_active => NULL
1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code
1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5

Line 1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active

1149: ,x_attribute2 => l_fnd_lookup_values_rec.attribute2
1150: ,x_attribute3 => l_fnd_lookup_values_rec.attribute3
1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4
1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag
1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active
1154: ,x_end_date_active => NULL
1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code
1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5
1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6

Line 1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code

1151: ,x_attribute4 => l_fnd_lookup_values_rec.attribute4
1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag
1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active
1154: ,x_end_date_active => NULL
1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code
1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5
1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6
1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8

Line 1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5

1152: ,x_enabled_flag => l_fnd_lookup_values_rec.enabled_flag
1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active
1154: ,x_end_date_active => NULL
1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code
1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5
1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6
1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9

Line 1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6

1153: ,x_start_date_active => l_fnd_lookup_values_rec.start_date_active
1154: ,x_end_date_active => NULL
1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code
1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5
1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6
1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10

Line 1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7

1154: ,x_end_date_active => NULL
1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code
1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5
1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6
1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11

Line 1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8

1155: ,x_territory_code => l_fnd_lookup_values_rec.territory_code
1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5
1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6
1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12

Line 1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9

1156: ,x_attribute5 => l_fnd_lookup_values_rec.attribute5
1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6
1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13

Line 1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10

1157: ,x_attribute6 => l_fnd_lookup_values_rec.attribute6
1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14

Line 1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11

1158: ,x_attribute7 => l_fnd_lookup_values_rec.attribute7
1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14
1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15

Line 1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12

1159: ,x_attribute8 => l_fnd_lookup_values_rec.attribute8
1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14
1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15
1167: ,x_meaning => l_fnd_lookup_values_rec.meaning

Line 1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13

1160: ,x_attribute9 => l_fnd_lookup_values_rec.attribute9
1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14
1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15
1167: ,x_meaning => l_fnd_lookup_values_rec.meaning
1168: ,x_description => l_fnd_lookup_values_rec.description

Line 1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14

1161: ,x_attribute10 => l_fnd_lookup_values_rec.attribute10
1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14
1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15
1167: ,x_meaning => l_fnd_lookup_values_rec.meaning
1168: ,x_description => l_fnd_lookup_values_rec.description
1169: ,x_last_update_date => SYSDATE

Line 1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15

1162: ,x_attribute11 => l_fnd_lookup_values_rec.attribute11
1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14
1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15
1167: ,x_meaning => l_fnd_lookup_values_rec.meaning
1168: ,x_description => l_fnd_lookup_values_rec.description
1169: ,x_last_update_date => SYSDATE
1170: ,x_last_updated_by => FND_GLOBAL.user_id

Line 1167: ,x_meaning => l_fnd_lookup_values_rec.meaning

1163: ,x_attribute12 => l_fnd_lookup_values_rec.attribute12
1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14
1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15
1167: ,x_meaning => l_fnd_lookup_values_rec.meaning
1168: ,x_description => l_fnd_lookup_values_rec.description
1169: ,x_last_update_date => SYSDATE
1170: ,x_last_updated_by => FND_GLOBAL.user_id
1171: ,x_last_update_login => FND_GLOBAL.login_id

Line 1168: ,x_description => l_fnd_lookup_values_rec.description

1164: ,x_attribute13 => l_fnd_lookup_values_rec.attribute13
1165: ,x_attribute14 => l_fnd_lookup_values_rec.attribute14
1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15
1167: ,x_meaning => l_fnd_lookup_values_rec.meaning
1168: ,x_description => l_fnd_lookup_values_rec.description
1169: ,x_last_update_date => SYSDATE
1170: ,x_last_updated_by => FND_GLOBAL.user_id
1171: ,x_last_update_login => FND_GLOBAL.login_id
1172: );

Line 1174: CLOSE cur_fnd_lookup_values;

1170: ,x_last_updated_by => FND_GLOBAL.user_id
1171: ,x_last_update_login => FND_GLOBAL.login_id
1172: );
1173: ELSE
1174: CLOSE cur_fnd_lookup_values;
1175: IF LENGTHB(X_TAX_RATE_CODE) > 30 THEN
1176: l_lookup_code := SUBSTRB(X_TAX_RATE_CODE, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S');
1177: l_tag := x_tax_rate_code;
1178: ELSE

Line 1182: fnd_lookup_values_pkg.insert_row (

1178: ELSE
1179: l_lookup_code := x_tax_rate_code;
1180: l_tag := NULL;
1181: END IF;
1182: fnd_lookup_values_pkg.insert_row (
1183: x_rowid => l_rowid
1184: ,x_lookup_type => x_lookup_type
1185: ,x_security_group_id => 0
1186: ,x_view_application_id => 0

Line 1222: IF cur_fnd_lookup_values%ISOPEN THEN

1218: END IF;
1219:
1220: EXCEPTION
1221: WHEN OTHERS THEN
1222: IF cur_fnd_lookup_values%ISOPEN THEN
1223: CLOSE cur_fnd_lookup_values;
1224: END IF;
1225: RAISE;
1226:

Line 1223: CLOSE cur_fnd_lookup_values;

1219:
1220: EXCEPTION
1221: WHEN OTHERS THEN
1222: IF cur_fnd_lookup_values%ISOPEN THEN
1223: CLOSE cur_fnd_lookup_values;
1224: END IF;
1225: RAISE;
1226:
1227: end INSERT_LOOKUP_VALUES;