APPS.POR_LOAD_LOC_TEMP_TABLE dependencies on POR_LOCATION_LOADER_VALUES

Line 33: UPDATE POR_LOCATION_LOADER_VALUES

29:
30:
31: IF (get_location_exists(x_location_code)) THEN
32:
33: UPDATE POR_LOCATION_LOADER_VALUES
34: SET
35: location_code = x_location_code,
36: business_group = x_business_grp_name,
37: effective_date = x_effective_date,

Line 64: INSERT INTO POR_LOCATION_LOADER_VALUES (

60: location_code = x_location_code;
61:
62: ELSE
63:
64: INSERT INTO POR_LOCATION_LOADER_VALUES (
65: location_code,
66: business_group,
67: effective_date,
68: description,

Line 137: SELECT 1 INTO l_exists FROM por_location_loader_values

133: l_exists NUMBER;
134:
135: BEGIN
136:
137: SELECT 1 INTO l_exists FROM por_location_loader_values
138: WHERE location_code = p_location_code;
139:
140: RETURN true;
141: