56: -- attribute_category VARCHAR2 optional Category column for descriptive flexfield support
57: --------------------------------------------------------------------------------------------
58:
59: TYPE Esc_Rec_Type IS RECORD (
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,
57: --------------------------------------------------------------------------------------------
58:
59: TYPE Esc_Rec_Type IS RECORD (
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,
58:
59: TYPE Esc_Rec_Type IS RECORD (
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,
59: TYPE Esc_Rec_Type IS RECORD (
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
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,
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,
75: cust_address_number hz_party_sites.party_site_number%TYPE := FND_API.G_MISS_CHAR,
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,
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,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,
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,
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,
79: attribute1 jtf_tasks_b.attribute1%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
122: -- attribute_category VARCHAR2 optional Category column for descriptive flexfield support
123: -------------------------------------------------------------------------------------------------------
124:
125: TYPE Esc_Ref_Docs_Rec_Type IS RECORD (
126: reference_id jtf_task_references_b.task_reference_id%TYPE := FND_API.G_MISS_NUM,
127: object_type_code jtf_task_references_b.object_type_code%TYPE := FND_API.G_MISS_CHAR,
128: object_name jtf_task_references_b.object_name%TYPE := FND_API.G_MISS_CHAR,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
123: -------------------------------------------------------------------------------------------------------
124:
125: TYPE Esc_Ref_Docs_Rec_Type IS RECORD (
126: reference_id jtf_task_references_b.task_reference_id%TYPE := FND_API.G_MISS_NUM,
127: object_type_code jtf_task_references_b.object_type_code%TYPE := FND_API.G_MISS_CHAR,
128: object_name jtf_task_references_b.object_name%TYPE := FND_API.G_MISS_CHAR,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
131: -- usage jtf_task_references_tl.usage%TYPE := FND_API.G_MISS_CHAR,
124:
125: TYPE Esc_Ref_Docs_Rec_Type IS RECORD (
126: reference_id jtf_task_references_b.task_reference_id%TYPE := FND_API.G_MISS_NUM,
127: object_type_code jtf_task_references_b.object_type_code%TYPE := FND_API.G_MISS_CHAR,
128: object_name jtf_task_references_b.object_name%TYPE := FND_API.G_MISS_CHAR,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
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,
125: TYPE Esc_Ref_Docs_Rec_Type IS RECORD (
126: reference_id jtf_task_references_b.task_reference_id%TYPE := FND_API.G_MISS_NUM,
127: object_type_code jtf_task_references_b.object_type_code%TYPE := FND_API.G_MISS_CHAR,
128: object_name jtf_task_references_b.object_name%TYPE := FND_API.G_MISS_CHAR,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
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,
126: reference_id jtf_task_references_b.task_reference_id%TYPE := FND_API.G_MISS_NUM,
127: object_type_code jtf_task_references_b.object_type_code%TYPE := FND_API.G_MISS_CHAR,
128: object_name jtf_task_references_b.object_name%TYPE := FND_API.G_MISS_CHAR,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
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),
127: object_type_code jtf_task_references_b.object_type_code%TYPE := FND_API.G_MISS_CHAR,
128: object_name jtf_task_references_b.object_name%TYPE := FND_API.G_MISS_CHAR,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
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,
128: object_name jtf_task_references_b.object_name%TYPE := FND_API.G_MISS_CHAR,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
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,
129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,
130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,
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,
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:
180: -- attribute_category VARCHAR2 optional Category column for descriptive flexfield support
181: --------------------------------------------------------------------------------------------
182:
183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
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,
181: --------------------------------------------------------------------------------------------
182:
183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
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,
182:
183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
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),
183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
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,
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
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,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
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,
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:
232: -- attribute_category VARCHAR2 optional Category column for descriptive flexfield support
233: --------------------------------------------------------------------------------------------
234:
235: TYPE Esc_Cont_Points_Rec_Type IS RECORD (
236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
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,
233: --------------------------------------------------------------------------------------------
234:
235: TYPE Esc_Cont_Points_Rec_Type IS RECORD (
236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
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),
234:
235: TYPE Esc_Cont_Points_Rec_Type IS RECORD (
236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
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,
235: TYPE Esc_Cont_Points_Rec_Type IS RECORD (
236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
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,
236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
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,
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:
283: --------------------------------------------------------------------------------------------
284:
285: TYPE Notes_Rec_Type IS RECORD (
286: action_code varchar2(1),
287: note_id NUMBER := FND_API.G_MISS_NUM,
288: note VARCHAR2(2000) := FND_API.G_MISS_CHAR,
289: note_detail VARCHAR2(32767) := FND_API.G_MISS_CHAR,
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
284:
285: TYPE Notes_Rec_Type IS RECORD (
286: action_code varchar2(1),
287: note_id NUMBER := FND_API.G_MISS_NUM,
288: note VARCHAR2(2000) := FND_API.G_MISS_CHAR,
289: note_detail VARCHAR2(32767) := FND_API.G_MISS_CHAR,
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
285: TYPE Notes_Rec_Type IS RECORD (
286: action_code varchar2(1),
287: note_id NUMBER := FND_API.G_MISS_NUM,
288: note VARCHAR2(2000) := FND_API.G_MISS_CHAR,
289: note_detail VARCHAR2(32767) := FND_API.G_MISS_CHAR,
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
286: action_code varchar2(1),
287: note_id NUMBER := FND_API.G_MISS_NUM,
288: note VARCHAR2(2000) := FND_API.G_MISS_CHAR,
289: note_detail VARCHAR2(32767) := FND_API.G_MISS_CHAR,
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
287: note_id NUMBER := FND_API.G_MISS_NUM,
288: note VARCHAR2(2000) := FND_API.G_MISS_CHAR,
289: note_detail VARCHAR2(32767) := FND_API.G_MISS_CHAR,
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,
288: note VARCHAR2(2000) := FND_API.G_MISS_CHAR,
289: note_detail VARCHAR2(32767) := FND_API.G_MISS_CHAR,
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,
296: note_context_type_03 VARCHAR2(240) := FND_API.G_MISS_CHAR,
289: note_detail VARCHAR2(32767) := FND_API.G_MISS_CHAR,
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,
296: note_context_type_03 VARCHAR2(240) := FND_API.G_MISS_CHAR,
297: note_context_type_id_03 NUMBER := FND_API.G_MISS_NUM
290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,
296: note_context_type_03 VARCHAR2(240) := FND_API.G_MISS_CHAR,
297: note_context_type_id_03 NUMBER := FND_API.G_MISS_NUM
298: );
291: note_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,
296: note_context_type_03 VARCHAR2(240) := FND_API.G_MISS_CHAR,
297: note_context_type_id_03 NUMBER := FND_API.G_MISS_NUM
298: );
299:
292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,
296: note_context_type_03 VARCHAR2(240) := FND_API.G_MISS_CHAR,
297: note_context_type_id_03 NUMBER := FND_API.G_MISS_NUM
298: );
299:
300: TYPE Notes_Tbl_Type IS TABLE OF Notes_Rec_Type INDEX BY BINARY_INTEGER;
293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,
294: note_context_type_02 VARCHAR2(240) := FND_API.G_MISS_CHAR,
295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,
296: note_context_type_03 VARCHAR2(240) := FND_API.G_MISS_CHAR,
297: note_context_type_id_03 NUMBER := FND_API.G_MISS_NUM
298: );
299:
300: TYPE Notes_Tbl_Type IS TABLE OF Notes_Rec_Type INDEX BY BINARY_INTEGER;
301:
FND_API.G_RET_STS_SUCCESS
316: * the API to commit on their behalf after performing its function.
317: * By default, the commit will not be performed.
318: * @param x_return_status The parameter that returns the result of all the operations performed
319: * by the API and must have one of the following values:
320: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
317: * By default, the commit will not be performed.
318: * @param x_return_status The parameter that returns the result of all the operations performed
319: * by the API and must have one of the following values:
320: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
318: * @param x_return_status The parameter that returns the result of all the operations performed
319: * by the API and must have one of the following values:
320: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
343: * @rep:category BUSINESS_ENTITY CAC_CAL_TASK
344: */
345: PROCEDURE CREATE_ESCALATION (
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
348: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
344: */
345: PROCEDURE CREATE_ESCALATION (
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
348: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,
352: p_resp_appl_id IN NUMBER := NULL,
FND_API.G_RET_STS_SUCCESS
375: * the API to commit on their behalf after performing its function.
376: * By default, the commit will not be performed.
377: * @param x_return_status The parameter that returns the result of all the operations performed
378: * by the API and must have one of the following values:
379: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
376: * By default, the commit will not be performed.
377: * @param x_return_status The parameter that returns the result of all the operations performed
378: * by the API and must have one of the following values:
379: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
377: * @param x_return_status The parameter that returns the result of all the operations performed
378: * by the API and must have one of the following values:
379: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
403: * @rep:category BUSINESS_ENTITY CAC_CAL_TASK
404: */
405: PROCEDURE UPDATE_ESCALATION (
406: p_api_version IN NUMBER,
407: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
408: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,
404: */
405: PROCEDURE UPDATE_ESCALATION (
406: p_api_version IN NUMBER,
407: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
408: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,
412: p_resp_appl_id IN NUMBER := NULL,
FND_API.G_RET_STS_SUCCESS
435: * the API to commit on their behalf after performing its function.
436: * By default, the commit will not be performed.
437: * @param x_return_status The parameter that returns the result of all the operations performed
438: * by the API and must have one of the following values:
439: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
436: * By default, the commit will not be performed.
437: * @param x_return_status The parameter that returns the result of all the operations performed
438: * by the API and must have one of the following values:
439: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
437: * @param x_return_status The parameter that returns the result of all the operations performed
438: * by the API and must have one of the following values:
439: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
454: * @rep:category BUSINESS_ENTITY CAC_CAL_TASK
455: */
456: PROCEDURE DELETE_ESCALATION(
457: p_api_version IN NUMBER,
458: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
459: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
455: */
456: PROCEDURE DELETE_ESCALATION(
457: p_api_version IN NUMBER,
458: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
459: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_user_id IN NUMBER,
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;