DBA Data[Home] [Help]

APPS.PA_PROJECT_ASSIGNMENTS_PKG dependencies on PA_ASSIGNMENT_NUMBER_S

Line 598: --DECODE(l_assignment_type(i), 'OPEN_ASSIGNMENT', pa_assignment_number_s.NEXTVAL, NULL),

594: DECODE(l_extension_possible(i), FND_API.G_MISS_CHAR, NULL, l_extension_possible(i)),
595: DECODE(l_source_assignment_id(i), FND_API.G_MISS_NUM, NULL, l_source_assignment_id(i)),
596: DECODE(l_min_resource_job_level(i), FND_API.G_MISS_NUM, NULL, l_min_resource_job_level(i)),
597: DECODE(l_max_resource_job_level(i), FND_API.G_MISS_NUM, NULL, l_max_resource_job_level(i)),
598: --DECODE(l_assignment_type(i), 'OPEN_ASSIGNMENT', pa_assignment_number_s.NEXTVAL, NULL),
599: pa_assignment_number_s.NEXTVAL,
600: DECODE(l_additional_information(i), FND_API.G_MISS_CHAR, NULL, l_additional_information(i)),
601: DECODE(l_work_type_id(i), FND_API.G_MISS_NUM, NULL, l_work_type_id(i)),
602: DECODE(l_revenue_currency_code(i), FND_API.G_MISS_CHAR, NULL, l_revenue_currency_code(i)),

Line 599: pa_assignment_number_s.NEXTVAL,

595: DECODE(l_source_assignment_id(i), FND_API.G_MISS_NUM, NULL, l_source_assignment_id(i)),
596: DECODE(l_min_resource_job_level(i), FND_API.G_MISS_NUM, NULL, l_min_resource_job_level(i)),
597: DECODE(l_max_resource_job_level(i), FND_API.G_MISS_NUM, NULL, l_max_resource_job_level(i)),
598: --DECODE(l_assignment_type(i), 'OPEN_ASSIGNMENT', pa_assignment_number_s.NEXTVAL, NULL),
599: pa_assignment_number_s.NEXTVAL,
600: DECODE(l_additional_information(i), FND_API.G_MISS_CHAR, NULL, l_additional_information(i)),
601: DECODE(l_work_type_id(i), FND_API.G_MISS_NUM, NULL, l_work_type_id(i)),
602: DECODE(l_revenue_currency_code(i), FND_API.G_MISS_CHAR, NULL, l_revenue_currency_code(i)),
603: DECODE(l_revenue_bill_rate(i), FND_API.G_MISS_NUM, NULL, l_revenue_bill_rate(i)),