APPS.PA_SCHEDULE_PVT dependencies on PA_LOOKUPS

Line 8619: FROM pa_lookups

8615: l_current_value := v_c2.status_code;
8616: IF (l_previous_value <> l_current_value) THEN
8617: SELECT meaning
8618: INTO l_old_value_text
8619: FROM pa_lookups
8620: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8621: AND lookup_code = 'PA_MULTIPLE';
8622: l_multiple := 'T';
8623: END IF;

Line 8642: FROM pa_lookups

8638: l_current_value := v_c2_current.status_code;
8639: IF (l_previous_value <> l_current_value) THEN
8640: SELECT meaning
8641: INTO l_old_value_text
8642: FROM pa_lookups
8643: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8644: AND lookup_code = 'PA_MULTIPLE';
8645: l_multiple := 'T';
8646: END IF;

Line 8672: FROM pa_lookups

8668: v_c2.thu_hours||','||v_c2.fri_hours||','||v_c2.sat_hours||','||v_c2.sun_hours;
8669: IF (l_previous_value <> l_current_value) THEN
8670: SELECT meaning
8671: INTO l_old_value_text
8672: FROM pa_lookups
8673: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8674: AND lookup_code = 'PA_MULTIPLE';
8675: l_multiple := 'T';
8676: END IF;

Line 8696: FROM pa_lookups

8692: v_c2_current.sun_hours;
8693: IF (l_previous_value <> l_current_value) THEN
8694: SELECT meaning
8695: INTO l_old_value_text
8696: FROM pa_lookups
8697: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8698: AND lookup_code = 'PA_MULTIPLE';
8699: l_multiple := 'T';
8700: END IF;

Line 8713: FROM pa_lookups

8709: ELSIF p_exception_type_code = 'CHANGE_HOURS' THEN
8710: IF ( p_end_date - p_start_date > 7) THEN
8711: SELECT meaning
8712: INTO l_old_value_text
8713: FROM pa_lookups
8714: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8715: AND lookup_code = 'PA_MULTIPLE';
8716:
8717: ELSE

Line 8795: FROM pa_lookups

8791:
8792: FOR i IN 1..total_nonzero-1 LOOP
8793: IF (change_hours_check(i) <>change_hours_check(0)) then
8794: SELECT meaning INTO l_old_value_text
8795: FROM pa_lookups
8796: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8797: AND lookup_code = 'PA_MULTIPLE';
8798: EXIT;
8799: END IF;

Line 9137: FROM pa_lookups

9133:
9134: IF c1%NOTFOUND THEN
9135: SELECT meaning
9136: INTO l_result
9137: FROM pa_lookups
9138: WHERE lookup_type = 'CONFLICT_EXISTS'
9139: AND lookup_code = 'NO';
9140: RETURN(l_result);
9141: ELSE

Line 9144: FROM pa_lookups

9140: RETURN(l_result);
9141: ELSE
9142: SELECT meaning
9143: INTO l_result
9144: FROM pa_lookups
9145: WHERE lookup_type = 'CONFLICT_EXISTS'
9146: AND lookup_code = 'YES';
9147: RETURN(l_result);
9148: END IF;

Line 9190: FROM pa_lookups

9186: RETURN (NULL);
9187: ELSE
9188: SELECT meaning
9189: INTO l_result
9190: FROM pa_lookups
9191: WHERE lookup_type = 'RESOLVE_CONFLICTS_ACTION_CODE'
9192: AND lookup_code = v_c1.resolve_conflicts_action_code;
9193: RETURN (l_result);
9194: END IF;

Line 9293: FROM pa_lookups

9289: l_attribute_label VARCHAR2(30);
9290: BEGIN
9291: SELECT meaning
9292: INTO l_attribute_label
9293: FROM pa_lookups
9294: WHERE lookup_type = p_region_code
9295: AND lookup_code = p_attribute_code;
9296:
9297: RETURN l_attribute_label;