DBA Data[Home] [Help]

APPS.PA_FP_ORG_FORECAST_LINES_PKG dependencies on PA_ORG_FORECAST_LINES_S

Line 26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE

22: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE

Line 55: CURSOR C2 IS SELECT pa_org_forecast_lines_s.nextval FROM sys.dual;

51: := FND_API.G_MISS_NUM
52: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
53: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
54: IS
55: CURSOR C2 IS SELECT pa_org_forecast_lines_s.nextval FROM sys.dual;
56: BEGIN
57: IF (px_forecast_line_id IS NULL) OR
58: (px_forecast_line_id = FND_API.G_MISS_NUM) THEN
59: OPEN C2;

Line 142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE

138: ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
141: := FND_API.G_MISS_CHAR
142: ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
143: := FND_API.G_MISS_DATE
144: ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
145: := FND_API.G_MISS_DATE
146: ,p_quantity IN pa_org_forecast_lines.quantity%TYPE