APPS.WSH_CARRIER_SERVICES_PKG dependencies on FND_LOOKUP_VALUES

Line 199: From fnd_lookup_values

195: END IF;
196:
197: Select count(*)
198: into l_smc
199: From fnd_lookup_values
200: Where lookup_type like 'SHIP_METHOD' and
201: lookup_code like p_Carrier_Service_Info.ship_method_code;
202: IF l_debug_on THEN
203: WSH_DEBUG_SV.log(l_module_name,'l_Carrier_Service_Id',

Line 211: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

207:
208: IF (l_smc = 0) then
209: l_position := 10;
210: l_procedure := 'Calling FND_LOOKUP_VALUE_PKG.INSERT_ROW';
211: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
212: X_ROWID => l_rowid,
213: X_LOOKUP_TYPE => 'SHIP_METHOD',
214: X_SECURITY_GROUP_ID => 0,
215: X_VIEW_APPLICATION_ID =>3,

Line 527: FROM FND_LOOKUP_VALUES

523: ATTRIBUTE14,
524: ATTRIBUTE15,
525: MEANING,
526: DESCRIPTION
527: FROM FND_LOOKUP_VALUES
528: where LOOKUP_TYPE = 'SHIP_METHOD'
529: and SECURITY_GROUP_ID = 0
530: and VIEW_APPLICATION_ID = 3
531: and LOOKUP_CODE = p_Carrier_Service_Info.SHIP_METHOD_CODE;

Line 1003: WSH_DEBUG_SV.log(l_module_name,'Before FND_LOOKUP_VALUES_PKG.LOCK_ROW');

999: RETURN;
1000: END IF;
1001: CLOSE C_lookup_row;
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.log(l_module_name,'Before FND_LOOKUP_VALUES_PKG.LOCK_ROW');
1004: END IF;
1005:
1006: FND_LOOKUP_VALUES_PKG.LOCK_ROW(
1007: X_LOOKUP_TYPE => 'SHIP_METHOD',

Line 1006: FND_LOOKUP_VALUES_PKG.LOCK_ROW(

1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.log(l_module_name,'Before FND_LOOKUP_VALUES_PKG.LOCK_ROW');
1004: END IF;
1005:
1006: FND_LOOKUP_VALUES_PKG.LOCK_ROW(
1007: X_LOOKUP_TYPE => 'SHIP_METHOD',
1008: X_SECURITY_GROUP_ID => 0,
1009: X_VIEW_APPLICATION_ID => 3,
1010: X_LOOKUP_CODE => lookupinfo.LOOKUP_CODE,

Line 1114: FROM FND_LOOKUP_VALUES

1110: ATTRIBUTE14,
1111: ATTRIBUTE15,
1112: MEANING,
1113: DESCRIPTION
1114: FROM FND_LOOKUP_VALUES
1115: where LOOKUP_TYPE = 'SHIP_METHOD'
1116: and SECURITY_GROUP_ID = 0
1117: and VIEW_APPLICATION_ID = 3
1118: and LOOKUP_CODE = p_ship_method_code;

Line 1250: l_procedure := 'Updating FND_LOOKUP_VALUES';

1246:
1247: CLOSE C_lookup_row;
1248:
1249: l_position := 30;
1250: l_procedure := 'Updating FND_LOOKUP_VALUES';
1251:
1252: -----------------------------------------------------
1253: -- Bug 2361153 : Ship_Method_Meaning is passed to the
1254: -- X_DESCRIPTION parameter.

Line 1257: FND_LOOKUP_VALUES_PKG.UPDATE_ROW

1253: -- Bug 2361153 : Ship_Method_Meaning is passed to the
1254: -- X_DESCRIPTION parameter.
1255: -----------------------------------------------------
1256:
1257: FND_LOOKUP_VALUES_PKG.UPDATE_ROW
1258: (
1259: X_LOOKUP_TYPE => 'SHIP_METHOD',
1260: X_SECURITY_GROUP_ID => 0,
1261: X_VIEW_APPLICATION_ID => 3,