DBA Data[Home] [Help]

APPS.JTF_EC_PUB dependencies on FND_API

Line 60: esc_name jtf_tasks_tl.task_name%TYPE := FND_API.G_MISS_CHAR,

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,

Line 61: esc_description jtf_tasks_tl.description%TYPE := FND_API.G_MISS_CHAR,

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,

Line 62: status_name jtf_task_statuses_tl.name%TYPE := FND_API.G_MISS_CHAR,

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,

Line 63: status_id jtf_task_statuses_b.task_status_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

Line 64: esc_open_date jtf_tasks_b.actual_start_date%TYPE := FND_API.G_MISS_DATE,

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,

Line 65: -- esc_close_date jtf_tasks_b.actual_end_date%TYPE := FND_API.G_MISS_DATE,

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,

Line 66: esc_owner_id jtf_tasks_b.owner_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,

Line 68: esc_owner_type_code jtf_tasks_b.owner_type_code%TYPE := FND_API.G_MISS_CHAR,

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,

Line 69: -- esc_territory_id jtf_tasks_b.owner_territory_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,

Line 70: customer_id jtf_tasks_b.customer_id%TYPE := FND_API.G_MISS_NUM,

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,

Line 71: customer_number hz_parties.party_number%TYPE := FND_API.G_MISS_CHAR,

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,

Line 72: cust_account_id jtf_tasks_b.cust_account_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,

Line 73: cust_account_number hz_cust_accounts.account_number%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,
77: reason_code jtf_tasks_b.reason_code%TYPE := FND_API.G_MISS_CHAR,

Line 74: cust_address_id jtf_tasks_b.address_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,
78: escalation_level jtf_tasks_b.escalation_level%TYPE := FND_API.G_MISS_CHAR,

Line 75: cust_address_number hz_party_sites.party_site_number%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,

Line 76: esc_target_date jtf_tasks_b.planned_end_date%TYPE := FND_API.G_MISS_DATE,

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,

Line 77: reason_code jtf_tasks_b.reason_code%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,

Line 78: escalation_level jtf_tasks_b.escalation_level%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,

Line 79: attribute1 jtf_tasks_b.attribute1%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,

Line 80: attribute2 jtf_tasks_b.attribute2%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,

Line 81: attribute3 jtf_tasks_b.attribute3%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,

Line 82: attribute4 jtf_tasks_b.attribute4%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,

Line 83: attribute5 jtf_tasks_b.attribute5%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,

Line 84: attribute6 jtf_tasks_b.attribute6%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,

Line 85: attribute7 jtf_tasks_b.attribute7%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,

Line 86: attribute8 jtf_tasks_b.attribute8%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,

Line 87: attribute9 jtf_tasks_b.attribute9%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,

Line 88: attribute10 jtf_tasks_b.attribute10%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,

Line 89: attribute11 jtf_tasks_b.attribute11%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,

Line 90: attribute12 jtf_tasks_b.attribute12%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

Line 91: attribute13 jtf_tasks_b.attribute13%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: );

Line 92: attribute14 jtf_tasks_b.attribute14%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: );
96:

Line 93: attribute15 jtf_tasks_b.attribute15%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:
97: --------------------------------------------------------------------------------------------

Line 94: attribute_category jtf_tasks_b.attribute_category%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: --------------------------------------------------------------------------------------------
98: -- Start of comments

Line 126: reference_id jtf_task_references_b.task_reference_id%TYPE := FND_API.G_MISS_NUM,

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,

Line 127: object_type_code jtf_task_references_b.object_type_code%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,

Line 128: object_name jtf_task_references_b.object_name%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,

Line 129: object_id jtf_task_references_b.object_id%TYPE := FND_API.G_MISS_NUM,

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,

Line 130: -- object_details jtf_task_references_b.object_details%TYPE := FND_API.G_MISS_CHAR,

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),

Line 131: -- usage jtf_task_references_tl.usage%TYPE := FND_API.G_MISS_CHAR,

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,

Line 132: reference_code jtf_task_references_b.reference_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,
136: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 133: object_version_number jtf_task_references_b.object_version_number%TYPE := FND_API.G_MISS_NUM,

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,

Line 135: attribute1 jtf_tasks_b.attribute1%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,

Line 136: attribute2 jtf_tasks_b.attribute2%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,

Line 137: attribute3 jtf_tasks_b.attribute3%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,

Line 138: attribute4 jtf_tasks_b.attribute4%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,

Line 139: attribute5 jtf_tasks_b.attribute5%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,

Line 140: attribute6 jtf_tasks_b.attribute6%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,

Line 141: attribute7 jtf_tasks_b.attribute7%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,

Line 142: attribute8 jtf_tasks_b.attribute8%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,

Line 143: attribute9 jtf_tasks_b.attribute9%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,

Line 144: attribute10 jtf_tasks_b.attribute10%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,

Line 145: attribute11 jtf_tasks_b.attribute11%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,

Line 146: attribute12 jtf_tasks_b.attribute12%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

Line 147: attribute13 jtf_tasks_b.attribute13%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: );

Line 148: attribute14 jtf_tasks_b.attribute14%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: );
152:

Line 149: attribute15 jtf_tasks_b.attribute15%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:
153: TYPE Esc_Ref_Docs_Tbl_Type is TABLE of Esc_Ref_Docs_Rec_Type INDEX BY BINARY_INTEGER;

Line 150: attribute_category jtf_tasks_b.attribute_category%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;
154:

Line 184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,

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,

Line 185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,

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,

Line 186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,

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),

Line 187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,

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,

Line 188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%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,

Line 189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%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,

Line 191: attribute1 jtf_tasks_b.attribute1%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,

Line 192: attribute2 jtf_tasks_b.attribute2%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,

Line 193: attribute3 jtf_tasks_b.attribute3%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,

Line 194: attribute4 jtf_tasks_b.attribute4%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,

Line 195: attribute5 jtf_tasks_b.attribute5%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,

Line 196: attribute6 jtf_tasks_b.attribute6%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,

Line 197: attribute7 jtf_tasks_b.attribute7%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,

Line 198: attribute8 jtf_tasks_b.attribute8%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,

Line 199: attribute9 jtf_tasks_b.attribute9%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,

Line 200: attribute10 jtf_tasks_b.attribute10%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,

Line 201: attribute11 jtf_tasks_b.attribute11%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,

Line 202: attribute12 jtf_tasks_b.attribute12%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

Line 203: attribute13 jtf_tasks_b.attribute13%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: );

Line 204: attribute14 jtf_tasks_b.attribute14%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: );
208:

Line 205: attribute15 jtf_tasks_b.attribute15%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:
209: TYPE Esc_Contacts_Tbl_Type is TABLE of Esc_Contacts_Rec_Type INDEX BY BINARY_INTEGER;

Line 206: attribute_category jtf_tasks_b.attribute_category%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;
210:

Line 236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,

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,

Line 237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,

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),

Line 238: contact_point_id jtf_task_phones.phone_id%TYPE := FND_API.G_MISS_NUM,

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,

Line 239: task_phone_id jtf_task_phones.task_phone_id%TYPE := FND_API.G_MISS_NUM,

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,

Line 240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,

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,

Line 242: attribute1 jtf_tasks_b.attribute1%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,

Line 243: attribute2 jtf_tasks_b.attribute2%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,

Line 244: attribute3 jtf_tasks_b.attribute3%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,

Line 245: attribute4 jtf_tasks_b.attribute4%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,

Line 246: attribute5 jtf_tasks_b.attribute5%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,

Line 247: attribute6 jtf_tasks_b.attribute6%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,

Line 248: attribute7 jtf_tasks_b.attribute7%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,

Line 249: attribute8 jtf_tasks_b.attribute8%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,

Line 250: attribute9 jtf_tasks_b.attribute9%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,

Line 251: attribute10 jtf_tasks_b.attribute10%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,

Line 252: attribute11 jtf_tasks_b.attribute11%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,

Line 253: attribute12 jtf_tasks_b.attribute12%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

Line 254: attribute13 jtf_tasks_b.attribute13%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: );

Line 255: attribute14 jtf_tasks_b.attribute14%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: );
259:

Line 256: attribute15 jtf_tasks_b.attribute15%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:
260: TYPE Esc_Cont_Points_Tbl_Type is TABLE of Esc_Cont_Points_Rec_Type INDEX BY BINARY_INTEGER;

Line 257: attribute_category jtf_tasks_b.attribute_category%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;
261:

Line 287: note_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 288: note VARCHAR2(2000) := 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,

Line 289: note_detail VARCHAR2(32767) := 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,

Line 290: note_type VARCHAR2(240) := FND_API.G_MISS_CHAR,

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,

Line 291: note_status VARCHAR2(1) := 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,

Line 292: note_context_type_01 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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,

Line 293: note_context_type_id_01 NUMBER := FND_API.G_MISS_NUM,

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

Line 294: note_context_type_02 VARCHAR2(240) := 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
298: );

Line 295: note_context_type_id_02 NUMBER := FND_API.G_MISS_NUM,

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:

Line 296: note_context_type_03 VARCHAR2(240) := 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:
300: TYPE Notes_Tbl_Type IS TABLE OF Notes_Rec_Type INDEX BY BINARY_INTEGER;

Line 297: note_context_type_id_03 NUMBER := FND_API.G_MISS_NUM

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:

Line 320: *
  • 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
    321: *
  • FND_API.G_RET_STS_ERROR
    322: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    323: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    324: * @param x_msg_data The parameter that returns the FND message in encoded format.

    Line 321: *
  • 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
    321: *
  • FND_API.G_RET_STS_ERROR
    322: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    323: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    324: * @param x_msg_data The parameter that returns the FND message in encoded format.
    325: * @param p_resp_appl_id The application id used to get profile value for a specific user/resp/appl combo.

    Line 322: *
  • 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
    321: *
  • FND_API.G_RET_STS_ERROR
    322: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    323: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    324: * @param x_msg_data The parameter that returns the FND message in encoded format.
    325: * @param p_resp_appl_id The application id used to get profile value for a specific user/resp/appl combo.
    326: * @param p_resp_id The responsibility id used to get profile value for a specific user/resp/appl combo.

    Line 347: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 348: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 379: *
  • 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
    380: *
  • FND_API.G_RET_STS_ERROR
    381: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    382: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    383: * @param x_msg_data The parameter that returns the FND Message in encoded format.

    Line 380: *
  • 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
    380: *
  • FND_API.G_RET_STS_ERROR
    381: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    382: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    383: * @param x_msg_data The parameter that returns the FND Message in encoded format.
    384: * @param p_resp_appl_id The application id used to get profile value for a specific user/resp/appl combo.

    Line 381: *
  • 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
    380: *
  • FND_API.G_RET_STS_ERROR
    381: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    382: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    383: * @param x_msg_data The parameter that returns the FND Message in encoded format.
    384: * @param p_resp_appl_id The application id used to get profile value for a specific user/resp/appl combo.
    385: * @param p_resp_id The responsibility id used to get profile value for a specific user/resp/appl combo.

    Line 407: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 408: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 439: *
  • 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
    440: *
  • FND_API.G_RET_STS_ERROR
    441: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    442: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    443: * @param x_msg_data The parameter that returns the FND Message in encoded format.

    Line 440: *
  • 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
    440: *
  • FND_API.G_RET_STS_ERROR
    441: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    442: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    443: * @param x_msg_data The parameter that returns the FND Message in encoded format.
    444: * @param p_user_id The user id to validate the user.

    Line 441: *
  • 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
    440: *
  • FND_API.G_RET_STS_ERROR
    441: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    442: * @param x_msg_count The parameter that returns the number of messages in the FND message list.
    443: * @param x_msg_data The parameter that returns the FND Message in encoded format.
    444: * @param p_user_id The user id to validate the user.
    445: * @param p_login_id The login id for record delete tracking.

    Line 458: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 459: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 465: p_esc_id IN jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num,

    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:

    Line 466: p_esc_number IN jtf_tasks_b.task_number%TYPE := fnd_api.g_miss_char,

    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;