DBA Data[Home] [Help]

APPS.PA_RESOURCE_PVT dependencies on FND_API

Line 52: ( person_id pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM,

48:
49:
50: TYPE Resource_Denorm_Rec_Type
51: IS RECORD
52: ( person_id pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM,
53: resource_name pa_resources_denorm.resource_name%TYPE := FND_API.G_MISS_CHAR,
54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,
55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,

Line 53: resource_name pa_resources_denorm.resource_name%TYPE := FND_API.G_MISS_CHAR,

49:
50: TYPE Resource_Denorm_Rec_Type
51: IS RECORD
52: ( person_id pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM,
53: resource_name pa_resources_denorm.resource_name%TYPE := FND_API.G_MISS_CHAR,
54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,
55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,

Line 54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,

50: TYPE Resource_Denorm_Rec_Type
51: IS RECORD
52: ( person_id pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM,
53: resource_name pa_resources_denorm.resource_name%TYPE := FND_API.G_MISS_CHAR,
54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,
55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,

Line 55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,

51: IS RECORD
52: ( person_id pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM,
53: resource_name pa_resources_denorm.resource_name%TYPE := FND_API.G_MISS_CHAR,
54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,
55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,

Line 56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,

52: ( person_id pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM,
53: resource_name pa_resources_denorm.resource_name%TYPE := FND_API.G_MISS_CHAR,
54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,
55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,

Line 57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,

53: resource_name pa_resources_denorm.resource_name%TYPE := FND_API.G_MISS_CHAR,
54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,
55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,

Line 58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,

54: resource_type pa_resources_denorm.resource_type%TYPE := FND_API.G_MISS_CHAR,
55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,

Line 59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,

55: resource_organization_id pa_resources_denorm.resource_organization_id%TYPE := FND_API.G_MISS_NUM,
56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,

Line 60: job_id NUMBER := FND_API.G_MISS_NUM,

56: resource_country_code pa_resources_denorm.resource_country_code%TYPE := FND_API.G_MISS_CHAR,
57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,

Line 61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,

57: resource_country pa_resources_denorm.resource_country%TYPE := FND_API.G_MISS_CHAR,
58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,

Line 62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,

58: resource_region pa_resources_denorm.resource_region%TYPE := FND_API.G_MISS_CHAR,
59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,

Line 63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,

59: resource_city pa_resources_denorm.resource_city%TYPE := FND_API.G_MISS_CHAR,
60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,

Line 64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,

60: job_id NUMBER := FND_API.G_MISS_NUM,
61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,
68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,

Line 65: manager_id NUMBER := FND_API.G_MISS_NUM,

61: resource_job_level pa_resources_denorm.resource_job_level%TYPE := FND_API.G_MISS_NUM,
62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,
68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,
69: schedulable_flag pa_resources_denorm.schedulable_flag%TYPE := FND_API.G_MISS_CHAR,

Line 66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,

62: resource_effective_start_date pa_resources_denorm.resource_effective_start_date%TYPE := FND_API.G_MISS_DATE,
63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,
68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,
69: schedulable_flag pa_resources_denorm.schedulable_flag%TYPE := FND_API.G_MISS_CHAR,
70: resource_org_id pa_resources_denorm.resource_org_id%TYPE := FND_API.G_MISS_NUM);

Line 67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,

63: resource_effective_end_date pa_resources_denorm.resource_effective_end_date%TYPE := FND_API.G_MISS_DATE,
64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,
68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,
69: schedulable_flag pa_resources_denorm.schedulable_flag%TYPE := FND_API.G_MISS_CHAR,
70: resource_org_id pa_resources_denorm.resource_org_id%TYPE := FND_API.G_MISS_NUM);
71:

Line 68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,

64: employee_flag pa_resources_denorm.employee_flag%TYPE := FND_API.G_MISS_CHAR,
65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,
68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,
69: schedulable_flag pa_resources_denorm.schedulable_flag%TYPE := FND_API.G_MISS_CHAR,
70: resource_org_id pa_resources_denorm.resource_org_id%TYPE := FND_API.G_MISS_NUM);
71:
72: Procedure Insert_resource_denorm

Line 69: schedulable_flag pa_resources_denorm.schedulable_flag%TYPE := FND_API.G_MISS_CHAR,

65: manager_id NUMBER := FND_API.G_MISS_NUM,
66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,
68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,
69: schedulable_flag pa_resources_denorm.schedulable_flag%TYPE := FND_API.G_MISS_CHAR,
70: resource_org_id pa_resources_denorm.resource_org_id%TYPE := FND_API.G_MISS_NUM);
71:
72: Procedure Insert_resource_denorm
73: ( p_resource_denorm_rec IN Resource_denorm_Rec_type,

Line 70: resource_org_id pa_resources_denorm.resource_org_id%TYPE := FND_API.G_MISS_NUM);

66: manager_name pa_resources_denorm.manager_name%TYPE := FND_API.G_MISS_CHAR,
67: billable_flag pa_resources_denorm.billable_flag%TYPE := FND_API.G_MISS_CHAR,
68: utilization_flag pa_resources_denorm.utilization_flag%TYPE := FND_API.G_MISS_CHAR,
69: schedulable_flag pa_resources_denorm.schedulable_flag%TYPE := FND_API.G_MISS_CHAR,
70: resource_org_id pa_resources_denorm.resource_org_id%TYPE := FND_API.G_MISS_NUM);
71:
72: Procedure Insert_resource_denorm
73: ( p_resource_denorm_rec IN Resource_denorm_Rec_type,
74: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895