[Home] [Help]
41:
42: TYPE order_by_rec_type IS RECORD
43: (
44: -- Please define your own sort by record here.
45: TERR_ID NUMBER := FND_API.G_MISS_NUM,
46: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
47: );
48: TYPE order_by_Tbl_Type IS TABLE OF order_by_rec_type
49: INDEX BY BINARY_INTEGER;
42: TYPE order_by_rec_type IS RECORD
43: (
44: -- Please define your own sort by record here.
45: TERR_ID NUMBER := FND_API.G_MISS_NUM,
46: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
47: );
48: TYPE order_by_Tbl_Type IS TABLE OF order_by_rec_type
49: INDEX BY BINARY_INTEGER;
50:
73: --
74: -- End of Comments
75: TYPE QualifyingRsc_Out_Rec_Type IS RECORD
76: (
77: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
78: TERR_ID NUMBER := FND_API.G_MISS_NUM,
79: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: -- End of Comments
75: TYPE QualifyingRsc_Out_Rec_Type IS RECORD
76: (
77: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
78: TERR_ID NUMBER := FND_API.G_MISS_NUM,
79: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
75: TYPE QualifyingRsc_Out_Rec_Type IS RECORD
76: (
77: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
78: TERR_ID NUMBER := FND_API.G_MISS_NUM,
79: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
83: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76: (
77: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
78: TERR_ID NUMBER := FND_API.G_MISS_NUM,
79: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
83: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
77: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
78: TERR_ID NUMBER := FND_API.G_MISS_NUM,
79: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
83: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
85: );
78: TERR_ID NUMBER := FND_API.G_MISS_NUM,
79: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
83: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
85: );
86:
79: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
83: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
85: );
86:
87: G_MISS_QUALIFYINGRSC_OUT_REC QualifyingRsc_Out_rec_type;
80: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81: ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
83: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
85: );
86:
87: G_MISS_QUALIFYINGRSC_OUT_REC QualifyingRsc_Out_rec_type;
88:
112: -- Note:
113: --
114: -- End of Comments
115: TYPE Terr_Header_Rec_Type IS RECORD (
116: TERR_ID NUMBER := FND_API.G_MISS_NUM,
117: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
118: TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
113: --
114: -- End of Comments
115: TYPE Terr_Header_Rec_Type IS RECORD (
116: TERR_ID NUMBER := FND_API.G_MISS_NUM,
117: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
118: TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: -- End of Comments
115: TYPE Terr_Header_Rec_Type IS RECORD (
116: TERR_ID NUMBER := FND_API.G_MISS_NUM,
117: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
118: TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: TYPE Terr_Header_Rec_Type IS RECORD (
116: TERR_ID NUMBER := FND_API.G_MISS_NUM,
117: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
118: TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
116: TERR_ID NUMBER := FND_API.G_MISS_NUM,
117: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
118: TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
124: TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
117: TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
118: TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
124: TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
125: );
118: TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
124: TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
125: );
126:
119: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
124: TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
125: );
126:
127: TYPE Terr_Header_Tbl_Type IS TABLE OF Terr_Header_Rec_Type
120: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
123: PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
124: TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
125: );
126:
127: TYPE Terr_Header_Tbl_Type IS TABLE OF Terr_Header_Rec_Type
128: INDEX BY BINARY_INTEGER;
135: -- Territory Record: Terr_Rec_Type
136: ---------------------------------------------------------
137: TYPE Terr_Rec_Type IS RECORD
138: (
139: TERR_ID NUMBER := FND_API.G_MISS_NUM,
140: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
136: ---------------------------------------------------------
137: TYPE Terr_Rec_Type IS RECORD
138: (
139: TERR_ID NUMBER := FND_API.G_MISS_NUM,
140: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
137: TYPE Terr_Rec_Type IS RECORD
138: (
139: TERR_ID NUMBER := FND_API.G_MISS_NUM,
140: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
138: (
139: TERR_ID NUMBER := FND_API.G_MISS_NUM,
140: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
139: TERR_ID NUMBER := FND_API.G_MISS_NUM,
140: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
140: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
142: CREATION_DATE DATE := FND_API.G_MISS_DATE,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
143: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
144: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
145: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
146: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
147: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
148: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
149: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
150: NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
151: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
152: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
155: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
156: TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158: TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: RANK NUMBER := FND_API.G_MISS_NUM,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
175: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
176: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
177: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
178: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
179: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187: , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
180: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187: , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
188: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
181: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187: , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
188: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
189: , TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
182: ORG_ID NUMBER := FND_API.G_MISS_NUM
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187: , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
188: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
189: , TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
190: );
183: , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187: , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
188: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
189: , TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
190: );
191:
184: , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187: , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
188: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
189: , TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
190: );
191:
192:
185: , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186: , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187: , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
188: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
189: , TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
190: );
191:
192:
193:
203: -- Territory Type Record: Terr_Type_Rec_Type
204: ---------------------------------------------------------
205: TYPE TERR_TYPE_REC_TYPE IS RECORD
206: (
207: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
208: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
209: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
204: ---------------------------------------------------------
205: TYPE TERR_TYPE_REC_TYPE IS RECORD
206: (
207: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
208: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
209: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
205: TYPE TERR_TYPE_REC_TYPE IS RECORD
206: (
207: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
208: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
209: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
206: (
207: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
208: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
209: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
207: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
208: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
209: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
208: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
209: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
209: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
211: CREATION_DATE DATE := FND_API.G_MISS_DATE,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
212: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235: ORG_ID NUMBER := FND_API.G_MISS_NUM
228: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235: ORG_ID NUMBER := FND_API.G_MISS_NUM
236: );
229: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235: ORG_ID NUMBER := FND_API.G_MISS_NUM
236: );
237:
230: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235: ORG_ID NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: TYPE Terr_Type_Tbl_Type IS TABLE OF Terr_Type_Rec_Type
231: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235: ORG_ID NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: TYPE Terr_Type_Tbl_Type IS TABLE OF Terr_Type_Rec_Type
239: INDEX BY BINARY_INTEGER;
246: -- Territory Usages Record: Terr_Usgs_Rec_Type
247: ---------------------------------------------------------
248: TYPE Terr_Usgs_Rec_Type IS RECORD
249: (
250: TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
251: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
252: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
247: ---------------------------------------------------------
248: TYPE Terr_Usgs_Rec_Type IS RECORD
249: (
250: TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
251: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
252: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
248: TYPE Terr_Usgs_Rec_Type IS RECORD
249: (
250: TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
251: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
252: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
249: (
250: TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
251: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
252: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
257: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
250: TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
251: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
252: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
257: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
258: ORG_ID NUMBER := FND_API.G_MISS_NUM
251: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
252: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
257: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
258: ORG_ID NUMBER := FND_API.G_MISS_NUM
259: , USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
252: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
257: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
258: ORG_ID NUMBER := FND_API.G_MISS_NUM
259: , USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
260: );
253: CREATION_DATE DATE := FND_API.G_MISS_DATE,
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
257: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
258: ORG_ID NUMBER := FND_API.G_MISS_NUM
259: , USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
260: );
261:
254: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
257: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
258: ORG_ID NUMBER := FND_API.G_MISS_NUM
259: , USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
260: );
261:
262: TYPE Terr_Usgs_Tbl_Type IS TABLE OF Terr_Usgs_Rec_Type
255: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256: TERR_ID NUMBER := FND_API.G_MISS_NUM,
257: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
258: ORG_ID NUMBER := FND_API.G_MISS_NUM
259: , USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
260: );
261:
262: TYPE Terr_Usgs_Tbl_Type IS TABLE OF Terr_Usgs_Rec_Type
263: INDEX BY BINARY_INTEGER;
271: -- Territory Qualifier Type Usages Record: Terr_QType_Usgs_Rec_Type
272: -----------------------------------------------------------------------
273: TYPE Terr_QType_Usgs_Rec_Type IS RECORD
274: (
275: TERR_QTYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
276: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
277: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
272: -----------------------------------------------------------------------
273: TYPE Terr_QType_Usgs_Rec_Type IS RECORD
274: (
275: TERR_QTYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
276: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
277: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
273: TYPE Terr_QType_Usgs_Rec_Type IS RECORD
274: (
275: TERR_QTYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
276: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
277: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
274: (
275: TERR_QTYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
276: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
277: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
275: TERR_QTYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
276: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
277: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
276: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
277: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
277: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
278: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
286: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
279: CREATION_DATE DATE := FND_API.G_MISS_DATE,
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
286: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
287: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
280: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
286: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
287: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
288: );
281: TERR_ID NUMBER := FND_API.G_MISS_NUM,
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
286: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
287: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
288: );
289:
282: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
286: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
287: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
288: );
289:
290: TYPE Terr_QType_Usgs_Tbl_Type IS TABLE OF Terr_QType_Usgs_Rec_Type
283: ORG_ID NUMBER := FND_API.G_MISS_NUM
284: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
286: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
287: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
288: );
289:
290: TYPE Terr_QType_Usgs_Tbl_Type IS TABLE OF Terr_QType_Usgs_Rec_Type
291: INDEX BY BINARY_INTEGER;
299: -- Territory Qualifier Record: Terr_Qual_Rec_Type
300: -----------------------------------------------------------------------
301: TYPE Terr_Qual_Rec_Type IS RECORD
302: (
303: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
304: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
305: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
300: -----------------------------------------------------------------------
301: TYPE Terr_Qual_Rec_Type IS RECORD
302: (
303: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
304: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
305: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
301: TYPE Terr_Qual_Rec_Type IS RECORD
302: (
303: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
304: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
305: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
302: (
303: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
304: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
305: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
303: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
304: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
305: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
304: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
305: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
305: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
306: CREATION_DATE DATE := FND_API.G_MISS_DATE,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
307: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
308: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
309: TERR_ID NUMBER := FND_API.G_MISS_NUM,
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
310: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
311: USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
312: GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
313: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
321: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
314: QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
321: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , QUALIFIER_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
315: ORG_ID NUMBER := FND_API.G_MISS_NUM
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
321: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , QUALIFIER_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
323: );
316: , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
321: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , QUALIFIER_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
323: );
324:
317: , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
321: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , QUALIFIER_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
323: );
324:
325: TYPE Terr_Qual_Tbl_Type IS TABLE OF Terr_Qual_Rec_Type
318: , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319: , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320: , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
321: , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , QUALIFIER_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
323: );
324:
325: TYPE Terr_Qual_Tbl_Type IS TABLE OF Terr_Qual_Rec_Type
326: INDEX BY BINARY_INTEGER;
335: -- Territory Values Record: Terr_Values_Rec_Type
336: -----------------------------------------------------------------------
337: TYPE Terr_Values_Rec_Type IS RECORD
338: (
339: TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
340: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
341: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
336: -----------------------------------------------------------------------
337: TYPE Terr_Values_Rec_Type IS RECORD
338: (
339: TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
340: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
341: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
337: TYPE Terr_Values_Rec_Type IS RECORD
338: (
339: TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
340: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
341: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
338: (
339: TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
340: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
341: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
339: TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
340: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
341: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
340: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
341: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
342: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
343: CREATION_DATE DATE := FND_API.G_MISS_DATE,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
344: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
345: TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
346: INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
347: COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
348: ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
349: LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357: SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
350: LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357: SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
358: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
351: HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357: SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
358: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
359: ORG_ID NUMBER := FND_API.G_MISS_NUM
352: LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357: SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
358: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
359: ORG_ID NUMBER := FND_API.G_MISS_NUM
360: );
353: HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357: SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
358: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
359: ORG_ID NUMBER := FND_API.G_MISS_NUM
360: );
361:
354: VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357: SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
358: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
359: ORG_ID NUMBER := FND_API.G_MISS_NUM
360: );
361:
362: TYPE Terr_Values_Tbl_Type IS TABLE OF Terr_Values_Rec_Type
355: INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356: PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357: SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
358: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
359: ORG_ID NUMBER := FND_API.G_MISS_NUM
360: );
361:
362: TYPE Terr_Values_Tbl_Type IS TABLE OF Terr_Values_Rec_Type
363: INDEX BY BINARY_INTEGER;
371: -- Territory Resources Record: Terr_Resources_Rec_Type
372: -----------------------------------------------------------------------
373: TYPE Terr_Rsc_Rec_Type IS RECORD
374: (
375: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
376: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
377: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
372: -----------------------------------------------------------------------
373: TYPE Terr_Rsc_Rec_Type IS RECORD
374: (
375: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
376: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
377: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
373: TYPE Terr_Rsc_Rec_Type IS RECORD
374: (
375: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
376: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
377: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
374: (
375: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
376: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
377: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
375: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
376: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
377: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
376: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
377: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
377: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
378: CREATION_DATE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
379: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
380: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388: FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
381: TERR_ID NUMBER := FND_API.G_MISS_NUM,
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388: FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
389: ORG_ID NUMBER := FND_API.G_MISS_NUM
382: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388: FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
389: ORG_ID NUMBER := FND_API.G_MISS_NUM
390: , RESOURCE_NAME VARCHAR2(573) := FND_API.G_MISS_CHAR
383: RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388: FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
389: ORG_ID NUMBER := FND_API.G_MISS_NUM
390: , RESOURCE_NAME VARCHAR2(573) := FND_API.G_MISS_CHAR
391: );
384: ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388: FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
389: ORG_ID NUMBER := FND_API.G_MISS_NUM
390: , RESOURCE_NAME VARCHAR2(573) := FND_API.G_MISS_CHAR
391: );
392:
385: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388: FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
389: ORG_ID NUMBER := FND_API.G_MISS_NUM
390: , RESOURCE_NAME VARCHAR2(573) := FND_API.G_MISS_CHAR
391: );
392:
393: TYPE Terr_Rsc_Tbl_Type IS TABLE OF Terr_Rsc_Rec_Type
386: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388: FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
389: ORG_ID NUMBER := FND_API.G_MISS_NUM
390: , RESOURCE_NAME VARCHAR2(573) := FND_API.G_MISS_CHAR
391: );
392:
393: TYPE Terr_Rsc_Tbl_Type IS TABLE OF Terr_Rsc_Rec_Type
394: INDEX BY BINARY_INTEGER;
416: -- p_Api_Version_Number NUMBER
417: --
418: -- Optional
419: -- Parameter Name Data Type Default
420: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
421: -- p_terr_rec Terr_Rec_Type G_MISS_TERR_REC
422: -- p_terr_type_rec Terr_Type_Rec_Type G_MISS_TERR_TYPE_REC
423: -- p_terr_usg_rec Terr_Usgs_Rec_Type G_MISS_TERR_USGS_REC
424: -- p_terr_rsc_rec Terr_Rsc_Rec_Type G_MISS_TERR_RSC_REC
424: -- p_terr_rsc_rec Terr_Rsc_Rec_Type G_MISS_TERR_RSC_REC
425: -- p_terr_qual_tbl Terr_Qual_Tbl_Type G_MISS_TERR_QUAL_TBL
426: -- p_terr_values_tbl Terr_Values_Tbl_Type G_MISS_TERR_VALUES_TBL
427: -- p_order_by_rec order_by_rec_type G_MISS_ORDER_BY_REC
428: -- p_return_all_rec VARCHAR2 FND_API.G_FALSE
429: -- p_num_rec_requested NUMBER 30
430: -- p_start_rec_num NUMBER 1
431: --
432: -- OUT :
446: -- End of Comments
447: --
448: PROCEDURE Get_Territory_Header (
449: p_Api_Version IN NUMBER,
450: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
454: p_terr_rec IN Terr_Rec_Type := G_MISS_TERR_REC,
457: p_terr_rsc_rec IN Terr_Rsc_Rec_Type := G_MISS_TERR_RSC_REC,
458: p_terr_qual_tbl IN Terr_Qual_Tbl_Type := G_MISS_TERR_QUAL_TBL,
459: p_terr_values_tbl IN Terr_Values_Tbl_Type := G_MISS_TERR_VALUES_TBL,
460: p_order_by_rec IN order_by_rec_type := G_MISS_ORDER_BY_REC,
461: p_return_all_rec IN VARCHAR2 := FND_API.G_FALSE,
462: p_num_rec_requested IN NUMBER := 30,
463: p_start_rec_num IN NUMBER := 1,
464: x_terr_header_tbl OUT NOCOPY Terr_Header_Tbl_Type,
465: x_num_rec_returned OUT NOCOPY NUMBER,
482: -- IN :
483: -- Required
484: -- Parameter Name Data Type Default
485: -- p_Api_Version_Number NUMBER
486: -- p_terr_id NUMBER FND_API.G_MISS_NUM
487: --
488: -- Optional
489: -- Parameter Name Data Type Default
490: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
486: -- p_terr_id NUMBER FND_API.G_MISS_NUM
487: --
488: -- Optional
489: -- Parameter Name Data Type Default
490: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
491: --
492: -- OUT :
493: -- Parameter Name Data Type
494: -- x_Return_Status VARCHAR2(1)
510: -- End of Comments
511: --
512: PROCEDURE Get_Territory_Details (
513: p_Api_Version IN NUMBER,
514: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
515: x_return_status OUT NOCOPY VARCHAR2,
516: x_msg_count OUT NOCOPY NUMBER,
517: x_msg_data OUT NOCOPY VARCHAR2,
518: p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
514: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
515: x_return_status OUT NOCOPY VARCHAR2,
516: x_msg_count OUT NOCOPY NUMBER,
517: x_msg_data OUT NOCOPY VARCHAR2,
518: p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
519: x_terr_rec OUT NOCOPY Terr_Rec_Type,
520: x_terr_type_rec OUT NOCOPY Terr_Type_Rec_Type,
521: x_terr_sub_terr_tbl OUT NOCOPY Terr_Tbl_Type,
522: x_terr_usgs_tbl OUT NOCOPY Terr_Usgs_Tbl_Type,
544: -- p_Escalation_Terr_Id NUMBER
545: --
546: -- Optional
547: -- Parameter Name Data Type Default
548: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
549: -- p_Commit VARCHAR2 FND_API.G_FALSE
550: --
551: -- OUT :
552: -- Parameter Name Data Type
545: --
546: -- Optional
547: -- Parameter Name Data Type Default
548: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
549: -- p_Commit VARCHAR2 FND_API.G_FALSE
550: --
551: -- OUT :
552: -- Parameter Name Data Type
553: -- x_Return_Status VARCHAR2(1)
561: -- End of Comments
562: --
563: PROCEDURE Get_Escalation_Territory (
564: p_Api_Version IN NUMBER,
565: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
566: x_return_status OUT NOCOPY VARCHAR2,
567: x_msg_count OUT NOCOPY NUMBER,
568: x_msg_data OUT NOCOPY VARCHAR2,
569: p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
566: x_return_status OUT NOCOPY VARCHAR2,
567: x_msg_count OUT NOCOPY NUMBER,
568: x_msg_data OUT NOCOPY VARCHAR2,
569: p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
570: x_escalation_terr_id OUT NOCOPY NUMBER
571: );
572:
573:
589: -- p_Parent_Terr_Id NUMBER
590: --
591: -- Optional
592: -- Parameter Name Data Type Default
593: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
594: -- p_Commit VARCHAR2 FND_API.G_FALSE
595: --
596: -- OUT :
597: -- Parameter Name Data Type
590: --
591: -- Optional
592: -- Parameter Name Data Type Default
593: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
594: -- p_Commit VARCHAR2 FND_API.G_FALSE
595: --
596: -- OUT :
597: -- Parameter Name Data Type
598: -- x_Return_Status VARCHAR2(1)
606: -- End of Comments
607: --
608: PROCEDURE Get_Parent_Territory (
609: p_Api_Version IN NUMBER,
610: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
611: x_return_status OUT NOCOPY VARCHAR2,
612: x_msg_count OUT NOCOPY NUMBER,
613: x_msg_data OUT NOCOPY VARCHAR2,
614: p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
610: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
611: x_return_status OUT NOCOPY VARCHAR2,
612: x_msg_count OUT NOCOPY NUMBER,
613: x_msg_data OUT NOCOPY VARCHAR2,
614: p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
615: x_parent_terr_id OUT NOCOPY NUMBER
616: );
617:
618:
636: -- p_Terr_Id NUMBER
637: --
638: -- Optional
639: -- Parameter Name Data Type Default
640: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
641: -- p_Commit VARCHAR2 FND_API.G_FALSE
642: --
643: -- OUT :
644: -- Parameter Name Data Type
637: --
638: -- Optional
639: -- Parameter Name Data Type Default
640: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
641: -- p_Commit VARCHAR2 FND_API.G_FALSE
642: --
643: -- OUT :
644: -- Parameter Name Data Type
645: -- x_Return_Status VARCHAR2(1)
653: -- End of Comments
654: --
655: PROCEDURE Get_Escalation_TerrMembers
656: (p_api_version_number IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2 := FND_API.G_FALSE,
659: x_return_status OUT NOCOPY VARCHAR2,
660: x_msg_count OUT NOCOPY NUMBER,
661: x_msg_data OUT NOCOPY VARCHAR2,
654: --
655: PROCEDURE Get_Escalation_TerrMembers
656: (p_api_version_number IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2 := FND_API.G_FALSE,
659: x_return_status OUT NOCOPY VARCHAR2,
660: x_msg_count OUT NOCOPY NUMBER,
661: x_msg_data OUT NOCOPY VARCHAR2,
662: p_terr_id IN NUMBER,