60: esc_name jtf_tasks_tl.task_name%TYPE := FND_API.G_MISS_CHAR,
61: esc_description jtf_tasks_tl.description%TYPE := FND_API.G_MISS_CHAR,
62: status_name jtf_task_statuses_tl.name%TYPE := FND_API.G_MISS_CHAR,
63: status_id jtf_task_statuses_b.task_status_id%TYPE := FND_API.G_MISS_NUM,
64: esc_open_date jtf_tasks_b.actual_start_date%TYPE := FND_API.G_MISS_DATE,
65: -- esc_close_date jtf_tasks_b.actual_end_date%TYPE := FND_API.G_MISS_DATE,
66: esc_owner_id jtf_tasks_b.owner_id%TYPE := FND_API.G_MISS_NUM,
67: --bug 2723761
68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,
61: esc_description jtf_tasks_tl.description%TYPE := FND_API.G_MISS_CHAR,
62: status_name jtf_task_statuses_tl.name%TYPE := FND_API.G_MISS_CHAR,
63: status_id jtf_task_statuses_b.task_status_id%TYPE := FND_API.G_MISS_NUM,
64: esc_open_date jtf_tasks_b.actual_start_date%TYPE := FND_API.G_MISS_DATE,
65: -- esc_close_date jtf_tasks_b.actual_end_date%TYPE := FND_API.G_MISS_DATE,
66: esc_owner_id jtf_tasks_b.owner_id%TYPE := FND_API.G_MISS_NUM,
67: --bug 2723761
68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,
69: -- esc_territory_id jtf_tasks_b.owner_territory_id%TYPE := FND_API.G_MISS_NUM,
62: status_name jtf_task_statuses_tl.name%TYPE := FND_API.G_MISS_CHAR,
63: status_id jtf_task_statuses_b.task_status_id%TYPE := FND_API.G_MISS_NUM,
64: esc_open_date jtf_tasks_b.actual_start_date%TYPE := FND_API.G_MISS_DATE,
65: -- esc_close_date jtf_tasks_b.actual_end_date%TYPE := FND_API.G_MISS_DATE,
66: esc_owner_id jtf_tasks_b.owner_id%TYPE := FND_API.G_MISS_NUM,
67: --bug 2723761
68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,
69: -- esc_territory_id jtf_tasks_b.owner_territory_id%TYPE := FND_API.G_MISS_NUM,
70: customer_id jtf_tasks_b.customer_id%TYPE := FND_API.G_MISS_NUM,
64: esc_open_date jtf_tasks_b.actual_start_date%TYPE := FND_API.G_MISS_DATE,
65: -- esc_close_date jtf_tasks_b.actual_end_date%TYPE := FND_API.G_MISS_DATE,
66: esc_owner_id jtf_tasks_b.owner_id%TYPE := FND_API.G_MISS_NUM,
67: --bug 2723761
68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,
69: -- esc_territory_id jtf_tasks_b.owner_territory_id%TYPE := FND_API.G_MISS_NUM,
70: customer_id jtf_tasks_b.customer_id%TYPE := FND_API.G_MISS_NUM,
71: customer_number hz_parties.party_number%TYPE := FND_API.G_MISS_CHAR,
72: cust_account_id jtf_tasks_b.cust_account_id%TYPE := FND_API.G_MISS_NUM,
65: -- esc_close_date jtf_tasks_b.actual_end_date%TYPE := FND_API.G_MISS_DATE,
66: esc_owner_id jtf_tasks_b.owner_id%TYPE := FND_API.G_MISS_NUM,
67: --bug 2723761
68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,
69: -- esc_territory_id jtf_tasks_b.owner_territory_id%TYPE := FND_API.G_MISS_NUM,
70: customer_id jtf_tasks_b.customer_id%TYPE := FND_API.G_MISS_NUM,
71: customer_number hz_parties.party_number%TYPE := FND_API.G_MISS_CHAR,
72: cust_account_id jtf_tasks_b.cust_account_id%TYPE := FND_API.G_MISS_NUM,
73: cust_account_number hz_cust_accounts.account_number%TYPE := FND_API.G_MISS_CHAR,
66: esc_owner_id jtf_tasks_b.owner_id%TYPE := FND_API.G_MISS_NUM,
67: --bug 2723761
68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,
69: -- esc_territory_id jtf_tasks_b.owner_territory_id%TYPE := FND_API.G_MISS_NUM,
70: customer_id jtf_tasks_b.customer_id%TYPE := FND_API.G_MISS_NUM,
71: customer_number hz_parties.party_number%TYPE := FND_API.G_MISS_CHAR,
72: cust_account_id jtf_tasks_b.cust_account_id%TYPE := FND_API.G_MISS_NUM,
73: cust_account_number hz_cust_accounts.account_number%TYPE := FND_API.G_MISS_CHAR,
74: cust_address_id jtf_tasks_b.address_id%TYPE := FND_API.G_MISS_NUM,
68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,
69: -- esc_territory_id jtf_tasks_b.owner_territory_id%TYPE := FND_API.G_MISS_NUM,
70: customer_id jtf_tasks_b.customer_id%TYPE := FND_API.G_MISS_NUM,
71: customer_number hz_parties.party_number%TYPE := FND_API.G_MISS_CHAR,
72: cust_account_id jtf_tasks_b.cust_account_id%TYPE := FND_API.G_MISS_NUM,
73: cust_account_number hz_cust_accounts.account_number%TYPE := FND_API.G_MISS_CHAR,
74: cust_address_id jtf_tasks_b.address_id%TYPE := FND_API.G_MISS_NUM,
75: cust_address_number hz_party_sites.party_site_number%TYPE := FND_API.G_MISS_CHAR,
76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,
70: customer_id jtf_tasks_b.customer_id%TYPE := FND_API.G_MISS_NUM,
71: customer_number hz_parties.party_number%TYPE := FND_API.G_MISS_CHAR,
72: cust_account_id jtf_tasks_b.cust_account_id%TYPE := FND_API.G_MISS_NUM,
73: cust_account_number hz_cust_accounts.account_number%TYPE := FND_API.G_MISS_CHAR,
74: cust_address_id jtf_tasks_b.address_id%TYPE := FND_API.G_MISS_NUM,
75: cust_address_number hz_party_sites.party_site_number%TYPE := FND_API.G_MISS_CHAR,
76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
72: cust_account_id jtf_tasks_b.cust_account_id%TYPE := FND_API.G_MISS_NUM,
73: cust_account_number hz_cust_accounts.account_number%TYPE := FND_API.G_MISS_CHAR,
74: cust_address_id jtf_tasks_b.address_id%TYPE := FND_API.G_MISS_NUM,
75: cust_address_number hz_party_sites.party_site_number%TYPE := FND_API.G_MISS_CHAR,
76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
73: cust_account_number hz_cust_accounts.account_number%TYPE := FND_API.G_MISS_CHAR,
74: cust_address_id jtf_tasks_b.address_id%TYPE := FND_API.G_MISS_NUM,
75: cust_address_number hz_party_sites.party_site_number%TYPE := FND_API.G_MISS_CHAR,
76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
74: cust_address_id jtf_tasks_b.address_id%TYPE := FND_API.G_MISS_NUM,
75: cust_address_number hz_party_sites.party_site_number%TYPE := FND_API.G_MISS_CHAR,
76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
75: cust_address_number hz_party_sites.party_site_number%TYPE := FND_API.G_MISS_CHAR,
76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
79: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
80: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
81: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
82: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
83: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
84: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
92: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
85: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
92: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
93: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
86: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
92: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
93: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
94: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
87: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
92: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
93: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
94: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
95: );
88: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
92: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
93: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
94: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
95: );
96:
89: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
92: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
93: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
94: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
95: );
96:
97: --------------------------------------------------------------------------------------------
90: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
91: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
92: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
93: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
94: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
95: );
96:
97: --------------------------------------------------------------------------------------------
98: -- Start of comments
131: -- usage jtf_task_references_tl.usage%TYPE := FND_API.G_MISS_CHAR,
132: reference_code jtf_task_references_b.reference_code%TYPE := FND_API.G_MISS_CHAR,
133: object_version_number jtf_task_references_b.object_version_number%TYPE := FND_API.G_MISS_NUM,
134: action_code varchar2(1),
135: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
136: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
137: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
132: reference_code jtf_task_references_b.reference_code%TYPE := FND_API.G_MISS_CHAR,
133: object_version_number jtf_task_references_b.object_version_number%TYPE := FND_API.G_MISS_NUM,
134: action_code varchar2(1),
135: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
136: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
137: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
133: object_version_number jtf_task_references_b.object_version_number%TYPE := FND_API.G_MISS_NUM,
134: action_code varchar2(1),
135: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
136: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
137: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
134: action_code varchar2(1),
135: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
136: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
137: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
135: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
136: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
137: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
136: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
137: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
137: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
138: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
139: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
140: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
148: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
141: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
148: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
149: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
142: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
148: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
149: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
150: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
143: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
148: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
149: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
150: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: );
144: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
148: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
149: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
150: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: );
152:
145: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
148: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
149: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
150: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: );
152:
153: TYPE Esc_Ref_Docs_Tbl_Type is TABLE of Esc_Ref_Docs_Rec_Type INDEX BY BINARY_INTEGER;
146: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
147: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
148: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
149: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
150: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
151: );
152:
153: TYPE Esc_Ref_Docs_Tbl_Type is TABLE of Esc_Ref_Docs_Rec_Type INDEX BY BINARY_INTEGER;
154:
187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,
190: action_code varchar2(1),
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,
190: action_code varchar2(1),
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,
190: action_code varchar2(1),
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
190: action_code varchar2(1),
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
194: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
195: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
196: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
204: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
197: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
204: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
205: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
198: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
204: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
205: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
206: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
199: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
204: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
205: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
206: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
207: );
200: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
204: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
205: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
206: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
207: );
208:
201: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
204: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
205: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
206: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
207: );
208:
209: TYPE Esc_Contacts_Tbl_Type is TABLE of Esc_Contacts_Rec_Type INDEX BY BINARY_INTEGER;
202: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
203: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
204: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
205: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
206: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
207: );
208:
209: TYPE Esc_Contacts_Tbl_Type is TABLE of Esc_Contacts_Rec_Type INDEX BY BINARY_INTEGER;
210:
238: contact_point_id jtf_task_phones.phone_id%TYPE := FND_API.G_MISS_NUM,
239: task_phone_id jtf_task_phones.task_phone_id%TYPE := FND_API.G_MISS_NUM,
240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,
241: action_code varchar2(1),
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
239: task_phone_id jtf_task_phones.task_phone_id%TYPE := FND_API.G_MISS_NUM,
240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,
241: action_code varchar2(1),
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,
241: action_code varchar2(1),
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
241: action_code varchar2(1),
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
245: attribute4 jtf_tasks_b.attribute4%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
246: attribute5 jtf_tasks_b.attribute5%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
247: attribute6 jtf_tasks_b.attribute6%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
255: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
248: attribute7 jtf_tasks_b.attribute7%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
255: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
256: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
249: attribute8 jtf_tasks_b.attribute8%TYPE := FND_API.G_MISS_CHAR,
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
255: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
256: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
257: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
250: attribute9 jtf_tasks_b.attribute9%TYPE := FND_API.G_MISS_CHAR,
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
255: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
256: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
257: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
258: );
251: attribute10 jtf_tasks_b.attribute10%TYPE := FND_API.G_MISS_CHAR,
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
255: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
256: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
257: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
258: );
259:
252: attribute11 jtf_tasks_b.attribute11%TYPE := FND_API.G_MISS_CHAR,
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
255: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
256: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
257: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
258: );
259:
260: TYPE Esc_Cont_Points_Tbl_Type is TABLE of Esc_Cont_Points_Rec_Type INDEX BY BINARY_INTEGER;
253: attribute12 jtf_tasks_b.attribute12%TYPE := FND_API.G_MISS_CHAR,
254: attribute13 jtf_tasks_b.attribute13%TYPE := FND_API.G_MISS_CHAR,
255: attribute14 jtf_tasks_b.attribute14%TYPE := FND_API.G_MISS_CHAR,
256: attribute15 jtf_tasks_b.attribute15%TYPE := FND_API.G_MISS_CHAR,
257: attribute_category jtf_tasks_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
258: );
259:
260: TYPE Esc_Cont_Points_Tbl_Type is TABLE of Esc_Cont_Points_Rec_Type INDEX BY BINARY_INTEGER;
261:
352: p_resp_appl_id IN NUMBER := NULL,
353: p_resp_id IN NUMBER := NULL,
354: p_user_id IN NUMBER := NULL,
355: p_login_id IN NUMBER := NULL,
356: p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
357: -- p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
358: p_esc_record IN Esc_Rec_Type,
359: p_reference_documents IN Esc_Ref_Docs_Tbl_Type DEFAULT g_miss_esc_ref_docs_tbl,
360: p_esc_contacts IN Esc_Contacts_Tbl_Type,
353: p_resp_id IN NUMBER := NULL,
354: p_user_id IN NUMBER := NULL,
355: p_login_id IN NUMBER := NULL,
356: p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
357: -- p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
358: p_esc_record IN Esc_Rec_Type,
359: p_reference_documents IN Esc_Ref_Docs_Tbl_Type DEFAULT g_miss_esc_ref_docs_tbl,
360: p_esc_contacts IN Esc_Contacts_Tbl_Type,
361: p_cont_points IN Esc_Cont_Points_Tbl_Type DEFAULT g_miss_esc_cont_points_tbl,
412: p_resp_appl_id IN NUMBER := NULL,
413: p_resp_id IN NUMBER := NULL,
414: p_user_id IN NUMBER := NULL, -- used for last updated by
415: p_login_id IN NUMBER := NULL,
416: p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
417: p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
418: p_object_version IN NUMBER,
419: p_esc_record IN Esc_Rec_Type,
420: p_reference_documents IN Esc_Ref_Docs_Tbl_Type DEFAULT g_miss_esc_ref_docs_tbl,
413: p_resp_id IN NUMBER := NULL,
414: p_user_id IN NUMBER := NULL, -- used for last updated by
415: p_login_id IN NUMBER := NULL,
416: p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
417: p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
418: p_object_version IN NUMBER,
419: p_esc_record IN Esc_Rec_Type,
420: p_reference_documents IN Esc_Ref_Docs_Tbl_Type DEFAULT g_miss_esc_ref_docs_tbl,
421: p_esc_contacts IN Esc_Contacts_Tbl_Type DEFAULT g_miss_esc_contacts_tbl,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_user_id IN NUMBER,
464: p_login_id IN NUMBER := NULL,
465: p_esc_id IN jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num,
466: p_esc_number IN jtf_tasks_b.task_number%TYPE := fnd_api.g_miss_char,
467: p_object_version IN NUMBER);
468:
469:
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_user_id IN NUMBER,
464: p_login_id IN NUMBER := NULL,
465: p_esc_id IN jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num,
466: p_esc_number IN jtf_tasks_b.task_number%TYPE := fnd_api.g_miss_char,
467: p_object_version IN NUMBER);
468:
469:
470: END JTF_EC_PUB;