59: -- End of Comments
60:
61: TYPE WinningTerr_rec_type IS RECORD
62: (
63: TERR_ID NUMBER := FND_API.G_MISS_NUM,
64: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ORG_ID NUMBER := FND_API.G_MISS_NUM,
66: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
67: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
60:
61: TYPE WinningTerr_rec_type IS RECORD
62: (
63: TERR_ID NUMBER := FND_API.G_MISS_NUM,
64: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ORG_ID NUMBER := FND_API.G_MISS_NUM,
66: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
67: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
68: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM
61: TYPE WinningTerr_rec_type IS RECORD
62: (
63: TERR_ID NUMBER := FND_API.G_MISS_NUM,
64: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ORG_ID NUMBER := FND_API.G_MISS_NUM,
66: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
67: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
68: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM
69: );
62: (
63: TERR_ID NUMBER := FND_API.G_MISS_NUM,
64: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ORG_ID NUMBER := FND_API.G_MISS_NUM,
66: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
67: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
68: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM
69: );
70:
63: TERR_ID NUMBER := FND_API.G_MISS_NUM,
64: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ORG_ID NUMBER := FND_API.G_MISS_NUM,
66: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
67: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
68: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM
69: );
70:
71: G_MISS_WINNINGTERR_REC WinningTerr_rec_type;
64: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: ORG_ID NUMBER := FND_API.G_MISS_NUM,
66: PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
67: TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
68: ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM
69: );
70:
71: G_MISS_WINNINGTERR_REC WinningTerr_rec_type;
72:
134: --
135: -- End of Comments
136: --
137: TYPE Terr_All_Rec_Type IS RECORD
138: (TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
139: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
140: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
135: -- End of Comments
136: --
137: TYPE Terr_All_Rec_Type IS RECORD
138: (TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
139: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
140: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
136: --
137: TYPE Terr_All_Rec_Type IS RECORD
138: (TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
139: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
140: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
137: TYPE Terr_All_Rec_Type IS RECORD
138: (TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
139: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
140: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
138: (TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
139: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
140: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
139: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
140: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
140: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
141: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
142: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
143: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
144: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
145: NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
146: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
147: REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
148: PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
149: PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
150: PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
151: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
152: RANK NUMBER , -- := FND_API.G_MISS_NUM,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
153: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
154: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
155: UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
156: AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157: PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
158: TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
159: PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
160: TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
161: TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
162: ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
163: ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
164: OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
165: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
166: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
180: ATTRIBUTE15 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR
173: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
180: ATTRIBUTE15 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR
181: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
174: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
180: ATTRIBUTE15 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR
181: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182: NUM_WINNERS NUMBER,
175: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
180: ATTRIBUTE15 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR
181: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182: NUM_WINNERS NUMBER,
183: NUM_QUAL NUMBER := 0,
176: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
180: ATTRIBUTE15 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR
181: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182: NUM_WINNERS NUMBER,
183: NUM_QUAL NUMBER := 0,
184: TERR_CREATION_FLAG VARCHAR2(1) := NULL,
177: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
180: ATTRIBUTE15 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR
181: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182: NUM_WINNERS NUMBER,
183: NUM_QUAL NUMBER := 0,
184: TERR_CREATION_FLAG VARCHAR2(1) := NULL,
185: TERRITORY_GROUP_ID NUMBER :=NULL
215: --
216: -- End of Comments
217: --
218: TYPE Terr_Qual_Rec_Type IS RECORD
219: ( Rowid VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
220: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
216: -- End of Comments
217: --
218: TYPE Terr_Qual_Rec_Type IS RECORD
219: ( Rowid VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
220: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
217: --
218: TYPE Terr_Qual_Rec_Type IS RECORD
219: ( Rowid VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
220: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
218: TYPE Terr_Qual_Rec_Type IS RECORD
219: ( Rowid VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
220: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
219: ( Rowid VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
220: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
220: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
231: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
231: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
231: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
233: );
226: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
231: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
233: );
234:
227: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
231: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
233: );
234:
235: TYPE Terr_Qual_Tbl_Type IS TABLE OF Terr_Qual_Rec_Type
228: USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229: GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
231: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
233: );
234:
235: TYPE Terr_Qual_Tbl_Type IS TABLE OF Terr_Qual_Rec_Type
236: INDEX BY BINARY_INTEGER;
271: --
272: -- End of Comments
273: --
274: TYPE Terr_Values_Rec_Type IS RECORD
275: (TERR_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
276: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
277: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
272: -- End of Comments
273: --
274: TYPE Terr_Values_Rec_Type IS RECORD
275: (TERR_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
276: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
277: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
273: --
274: TYPE Terr_Values_Rec_Type IS RECORD
275: (TERR_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
276: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
277: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
274: TYPE Terr_Values_Rec_Type IS RECORD
275: (TERR_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
276: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
277: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
275: (TERR_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
276: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
277: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
276: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
277: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
277: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
278: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
279: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
280: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
281: TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
282: INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
283: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
284: LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
285: HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
286: LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294: LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
287: HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294: LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: QUALIFIER_TBL_INDEX NUMBER , -- := FND_API.G_MISS_NUM,
288: VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294: LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: QUALIFIER_TBL_INDEX NUMBER , -- := FND_API.G_MISS_NUM,
296: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM
289: INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294: LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: QUALIFIER_TBL_INDEX NUMBER , -- := FND_API.G_MISS_NUM,
296: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM
297: CNR_GROUP_ID NUMBER ,
290: PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294: LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: QUALIFIER_TBL_INDEX NUMBER , -- := FND_API.G_MISS_NUM,
296: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM
297: CNR_GROUP_ID NUMBER ,
298: VALUE1_ID NUMBER ,
291: SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294: LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: QUALIFIER_TBL_INDEX NUMBER , -- := FND_API.G_MISS_NUM,
296: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM
297: CNR_GROUP_ID NUMBER ,
298: VALUE1_ID NUMBER ,
299: VALUE2_ID NUMBER ,
292: CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293: ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294: LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: QUALIFIER_TBL_INDEX NUMBER , -- := FND_API.G_MISS_NUM,
296: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM
297: CNR_GROUP_ID NUMBER ,
298: VALUE1_ID NUMBER ,
299: VALUE2_ID NUMBER ,
300: VALUE3_ID NUMBER ,
332: -- End of Comments
333:
334: TYPE terr_usgs_rec_type IS RECORD
335: (
336: TERR_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
337: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
338: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
333:
334: TYPE terr_usgs_rec_type IS RECORD
335: (
336: TERR_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
337: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
338: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
334: TYPE terr_usgs_rec_type IS RECORD
335: (
336: TERR_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
337: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
338: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
335: (
336: TERR_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
337: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
338: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
343: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
336: TERR_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
337: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
338: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
343: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
344: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
337: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
338: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
343: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
344: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
345:
338: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
343: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
344: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
345:
346: );
339: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
343: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
344: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
345:
346: );
347:
340: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
343: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
344: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
345:
346: );
347:
348: G_MISS_TERR_USGS_REC terr_usgs_rec_type;
376: -- End of Comments
377:
378: TYPE terr_qualtypeusgs_rec_type IS RECORD
379: (
380: TERR_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
382: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
377:
378: TYPE terr_qualtypeusgs_rec_type IS RECORD
379: (
380: TERR_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
382: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
378: TYPE terr_qualtypeusgs_rec_type IS RECORD
379: (
380: TERR_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
382: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
379: (
380: TERR_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
382: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
387: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
380: TERR_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
381: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
382: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
387: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
388: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
381: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
382: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
387: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
388: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
389: );
382: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
387: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
388: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
389: );
390:
383: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
387: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
388: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
389: );
390:
391: G_MISS_TERR_QUALTYPEUSGS_REC terr_qualtypeusgs_rec_type;
384: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
387: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
388: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
389: );
390:
391: G_MISS_TERR_QUALTYPEUSGS_REC terr_qualtypeusgs_rec_type;
392:
410: -- End of Comments
411:
412: TYPE terr_all_out_rec_type IS RECORD
413: (
414: TERR_ID NUMBER ,--:= FND_API.G_MISS_NUM,
415: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
416: );
417:
418: G_MISS_TERR_ALL_OUT_REC terr_all_out_rec_type;
411:
412: TYPE terr_all_out_rec_type IS RECORD
413: (
414: TERR_ID NUMBER ,--:= FND_API.G_MISS_NUM,
415: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
416: );
417:
418: G_MISS_TERR_ALL_OUT_REC terr_all_out_rec_type;
419:
438: -- End of Comments
439:
440: TYPE Terr_Usgs_out_rec_type IS RECORD
441: (
442: TERR_USG_ID NUMBER ,--:= FND_API.G_MISS_NUM,
443: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
444: );
445:
446: G_MISS_TERR_USGS_OUT_REC terr_usgs_out_rec_type;
439:
440: TYPE Terr_Usgs_out_rec_type IS RECORD
441: (
442: TERR_USG_ID NUMBER ,--:= FND_API.G_MISS_NUM,
443: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
444: );
445:
446: G_MISS_TERR_USGS_OUT_REC terr_usgs_out_rec_type;
447:
464: -- End of Comments
465:
466: TYPE terr_QualTypeUsgs_out_rec_type IS RECORD
467: (
468: TERR_QUAL_TYPE_USG_ID NUMBER ,--:= FND_API.G_MISS_NUM,
469: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
470: );
471:
472: G_MISS_TERRQUALTYPUSGS_OUT_REC terr_QualTypeUsgs_out_rec_type;
465:
466: TYPE terr_QualTypeUsgs_out_rec_type IS RECORD
467: (
468: TERR_QUAL_TYPE_USG_ID NUMBER ,--:= FND_API.G_MISS_NUM,
469: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
470: );
471:
472: G_MISS_TERRQUALTYPUSGS_OUT_REC terr_QualTypeUsgs_out_rec_type;
473:
489: -- End of Comments
490:
491: TYPE Terr_Qual_out_rec_type IS RECORD
492: (
493: TERR_QUAL_ID NUMBER ,--:= FND_API.G_MISS_NUM,
494: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
495: );
496:
497: G_MISS_TERR_QUAL_OUT_REC Terr_Qual_out_rec_type;
490:
491: TYPE Terr_Qual_out_rec_type IS RECORD
492: (
493: TERR_QUAL_ID NUMBER ,--:= FND_API.G_MISS_NUM,
494: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
495: );
496:
497: G_MISS_TERR_QUAL_OUT_REC Terr_Qual_out_rec_type;
498:
515: -- End of Comments
516:
517: TYPE Terr_Values_out_rec_type IS RECORD
518: (
519: TERR_VALUE_ID NUMBER ,-- := FND_API.G_MISS_NUM,
520: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
521: );
522:
523: G_MISS_TERR_VALUES_OUT_REC terr_values_out_rec_type;
516:
517: TYPE Terr_Values_out_rec_type IS RECORD
518: (
519: TERR_VALUE_ID NUMBER ,-- := FND_API.G_MISS_NUM,
520: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
521: );
522:
523: G_MISS_TERR_VALUES_OUT_REC terr_values_out_rec_type;
524:
550: -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
551: --
552: -- Optional
553: -- Parameter Name Data Type Default
554: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
555: -- p_Commit VARCHAR2 := FND_API.G_FALSE
556: --
557: -- OUT NOCOPY :
558: -- Parameter Name Data Type
551: --
552: -- Optional
553: -- Parameter Name Data Type Default
554: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
555: -- p_Commit VARCHAR2 := FND_API.G_FALSE
556: --
557: -- OUT NOCOPY :
558: -- Parameter Name Data Type
559: -- x_Return_Status VARCHAR2(1)
572: -- End of Comments
573: --
574: PROCEDURE Create_Territory
575: (p_Api_Version_Number IN NUMBER,
576: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
577: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579: x_Return_Status OUT NOCOPY VARCHAR2,
580: x_Msg_Count OUT NOCOPY NUMBER,
573: --
574: PROCEDURE Create_Territory
575: (p_Api_Version_Number IN NUMBER,
576: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
577: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579: x_Return_Status OUT NOCOPY VARCHAR2,
580: x_Msg_Count OUT NOCOPY NUMBER,
581: x_Msg_Data OUT NOCOPY VARCHAR2,
574: PROCEDURE Create_Territory
575: (p_Api_Version_Number IN NUMBER,
576: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
577: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579: x_Return_Status OUT NOCOPY VARCHAR2,
580: x_Msg_Count OUT NOCOPY NUMBER,
581: x_Msg_Data OUT NOCOPY VARCHAR2,
582: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
610: -- p_Terr_Id NUMBER
611: --
612: -- Optional
613: -- Parameter Name Data Type Default
614: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
615: -- p_Commit VARCHAR2 FND_API.G_FALSE
616: --
617: -- OUT NOCOPY :
618: -- Parameter Name Data Type
611: --
612: -- Optional
613: -- Parameter Name Data Type Default
614: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
615: -- p_Commit VARCHAR2 FND_API.G_FALSE
616: --
617: -- OUT NOCOPY :
618: -- Parameter Name Data Type
619: -- X_Return_Status VARCHAR2(1)
627: -- End of Comments
628: --
629: PROCEDURE Delete_Territory
630: (p_Api_Version_Number IN NUMBER,
631: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
632: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
633: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
634: X_Return_Status OUT NOCOPY VARCHAR2,
635: X_Msg_Count OUT NOCOPY NUMBER,
628: --
629: PROCEDURE Delete_Territory
630: (p_Api_Version_Number IN NUMBER,
631: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
632: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
633: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
634: X_Return_Status OUT NOCOPY VARCHAR2,
635: X_Msg_Count OUT NOCOPY NUMBER,
636: X_Msg_Data OUT NOCOPY VARCHAR2,
629: PROCEDURE Delete_Territory
630: (p_Api_Version_Number IN NUMBER,
631: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
632: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
633: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
634: X_Return_Status OUT NOCOPY VARCHAR2,
635: X_Msg_Count OUT NOCOPY NUMBER,
636: X_Msg_Data OUT NOCOPY VARCHAR2,
637: p_Terr_Id IN NUMBER);
658: -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
659: --
660: -- Optional
661: -- Parameter Name Data Type Default
662: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
663: -- p_Commit VARCHAR2 := FND_API.G_FALSE
664: --
665: -- OUT NOCOPY :
666: -- Parameter Name Data Type
659: --
660: -- Optional
661: -- Parameter Name Data Type Default
662: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
663: -- p_Commit VARCHAR2 := FND_API.G_FALSE
664: --
665: -- OUT NOCOPY :
666: -- Parameter Name Data Type
667: -- X_Return_Status VARCHAR2(1)
680: -- End of Comments
681: --
682: PROCEDURE Update_Territory
683: (p_Api_Version_Number IN NUMBER,
684: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
685: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687: X_Return_Status OUT NOCOPY VARCHAR2,
688: X_Msg_Count OUT NOCOPY NUMBER,
681: --
682: PROCEDURE Update_Territory
683: (p_Api_Version_Number IN NUMBER,
684: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
685: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687: X_Return_Status OUT NOCOPY VARCHAR2,
688: X_Msg_Count OUT NOCOPY NUMBER,
689: X_Msg_Data OUT NOCOPY VARCHAR2,
682: PROCEDURE Update_Territory
683: (p_Api_Version_Number IN NUMBER,
684: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
685: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687: X_Return_Status OUT NOCOPY VARCHAR2,
688: X_Msg_Count OUT NOCOPY NUMBER,
689: X_Msg_Data OUT NOCOPY VARCHAR2,
690: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
718: -- p_Terr_Id NUMBER
719: --
720: -- Optional
721: -- Parameter Name Data Type Default
722: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
723: -- p_Commit VARCHAR2 FND_API.G_FALSE
724: --
725: -- OUT NOCOPY :
726: -- Parameter Name Data Type
719: --
720: -- Optional
721: -- Parameter Name Data Type Default
722: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
723: -- p_Commit VARCHAR2 FND_API.G_FALSE
724: --
725: -- OUT NOCOPY :
726: -- Parameter Name Data Type
727: -- x_Return_Status VARCHAR2(1)
735: -- End of Comments
736: --
737: PROCEDURE Deactivate_Territory
738: (p_api_version_number IN NUMBER,
739: p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
740: p_commit IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
736: --
737: PROCEDURE Deactivate_Territory
738: (p_api_version_number IN NUMBER,
739: p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
740: p_commit IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
737: PROCEDURE Deactivate_Territory
738: (p_api_version_number IN NUMBER,
739: p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
740: p_commit IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: P_terr_id IN NUMBER);
764: -- P_Terr_QualTypeUsgs_Tbl Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl
765: --
766: -- Optional
767: -- Parameter Name Data Type Default
768: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
769: -- P_Commit VARCHAR2 := FND_API.G_FALSE
770: --
771: -- OUT NOCOPY :
772: -- Parameter Name Data Type
765: --
766: -- Optional
767: -- Parameter Name Data Type Default
768: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
769: -- P_Commit VARCHAR2 := FND_API.G_FALSE
770: --
771: -- OUT NOCOPY :
772: -- Parameter Name Data Type
773: -- X_Return_Status VARCHAR2(1)
784: -- End of Comments
785: --
786: PROCEDURE Create_Territory_Header
787: (P_Api_Version_Number IN NUMBER,
788: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
789: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
790: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
791: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
792: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
785: --
786: PROCEDURE Create_Territory_Header
787: (P_Api_Version_Number IN NUMBER,
788: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
789: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
790: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
791: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
792: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
793: -- P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
786: PROCEDURE Create_Territory_Header
787: (P_Api_Version_Number IN NUMBER,
788: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
789: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
790: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
791: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
792: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
793: -- P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
794: X_Return_Status OUT NOCOPY VARCHAR2,
799: X_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type);
800:
801: PROCEDURE Create_Territory_Record
802: ( P_Api_Version_Number IN NUMBER,
803: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
804: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
806: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
807: X_Return_Status OUT NOCOPY VARCHAR2,
800:
801: PROCEDURE Create_Territory_Record
802: ( P_Api_Version_Number IN NUMBER,
803: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
804: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
806: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
807: X_Return_Status OUT NOCOPY VARCHAR2,
808: X_Msg_Count OUT NOCOPY NUMBER,
801: PROCEDURE Create_Territory_Record
802: ( P_Api_Version_Number IN NUMBER,
803: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
804: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
806: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
807: X_Return_Status OUT NOCOPY VARCHAR2,
808: X_Msg_Count OUT NOCOPY NUMBER,
809: X_Msg_Data OUT NOCOPY VARCHAR2,
813:
814:
815: PROCEDURE Create_Territory_Usages
816: ( P_Api_Version_Number IN NUMBER,
817: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
818: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
819: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
820: P_Terr_Id IN NUMBER,
821: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
814:
815: PROCEDURE Create_Territory_Usages
816: ( P_Api_Version_Number IN NUMBER,
817: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
818: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
819: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
820: P_Terr_Id IN NUMBER,
821: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
822: X_Return_Status OUT NOCOPY VARCHAR2,
815: PROCEDURE Create_Territory_Usages
816: ( P_Api_Version_Number IN NUMBER,
817: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
818: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
819: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
820: P_Terr_Id IN NUMBER,
821: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
822: X_Return_Status OUT NOCOPY VARCHAR2,
823: X_Msg_Count OUT NOCOPY NUMBER,
827:
828:
829: PROCEDURE Create_Terr_QualType_Usage
830: (P_Api_Version_Number IN NUMBER,
831: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
832: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: P_Terr_Id IN NUMBER,
835: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
828:
829: PROCEDURE Create_Terr_QualType_Usage
830: (P_Api_Version_Number IN NUMBER,
831: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
832: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: P_Terr_Id IN NUMBER,
835: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
836: X_Return_Status OUT NOCOPY VARCHAR2,
829: PROCEDURE Create_Terr_QualType_Usage
830: (P_Api_Version_Number IN NUMBER,
831: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
832: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: P_Terr_Id IN NUMBER,
835: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
836: X_Return_Status OUT NOCOPY VARCHAR2,
837: X_Msg_Count OUT NOCOPY NUMBER,
841:
842:
843: PROCEDURE Create_Terr_QualType_Usage
844: (P_Api_Version_Number IN NUMBER,
845: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
846: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848: P_Terr_Id IN NUMBER,
849: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
842:
843: PROCEDURE Create_Terr_QualType_Usage
844: (P_Api_Version_Number IN NUMBER,
845: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
846: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848: P_Terr_Id IN NUMBER,
849: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
850: X_Return_Status OUT NOCOPY VARCHAR2,
843: PROCEDURE Create_Terr_QualType_Usage
844: (P_Api_Version_Number IN NUMBER,
845: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
846: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848: P_Terr_Id IN NUMBER,
849: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
850: X_Return_Status OUT NOCOPY VARCHAR2,
851: X_Msg_Count OUT NOCOPY NUMBER,
854:
855:
856: PROCEDURE Create_Terr_Qualifier
857: (P_Api_Version_Number IN NUMBER,
858: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
859: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
861: P_Terr_Id IN NUMBER,
862: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
855:
856: PROCEDURE Create_Terr_Qualifier
857: (P_Api_Version_Number IN NUMBER,
858: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
859: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
861: P_Terr_Id IN NUMBER,
862: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
863: X_Return_Status OUT NOCOPY VARCHAR2,
856: PROCEDURE Create_Terr_Qualifier
857: (P_Api_Version_Number IN NUMBER,
858: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
859: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
861: P_Terr_Id IN NUMBER,
862: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
863: X_Return_Status OUT NOCOPY VARCHAR2,
864: X_Msg_Count OUT NOCOPY NUMBER,
867: X_Terr_Qual_Out_Rec OUT NOCOPY Terr_Qual_Out_Rec_Type);
868:
869: PROCEDURE Create_Terr_Qualifier
870: (P_Api_Version_Number IN NUMBER,
871: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
872: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
873: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
874: P_Terr_Id IN NUMBER,
875: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
868:
869: PROCEDURE Create_Terr_Qualifier
870: (P_Api_Version_Number IN NUMBER,
871: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
872: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
873: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
874: P_Terr_Id IN NUMBER,
875: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
876: X_Return_Status OUT NOCOPY VARCHAR2,
869: PROCEDURE Create_Terr_Qualifier
870: (P_Api_Version_Number IN NUMBER,
871: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
872: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
873: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
874: P_Terr_Id IN NUMBER,
875: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
876: X_Return_Status OUT NOCOPY VARCHAR2,
877: X_Msg_Count OUT NOCOPY NUMBER,
880:
881: PROCEDURE Create_Terr_qualifier
882: (
883: p_Api_Version_Number IN NUMBER,
884: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
885: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887: x_Return_Status OUT NOCOPY VARCHAR2,
888: x_Msg_Count OUT NOCOPY NUMBER,
881: PROCEDURE Create_Terr_qualifier
882: (
883: p_Api_Version_Number IN NUMBER,
884: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
885: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887: x_Return_Status OUT NOCOPY VARCHAR2,
888: x_Msg_Count OUT NOCOPY NUMBER,
889: x_Msg_Data OUT NOCOPY VARCHAR2,
882: (
883: p_Api_Version_Number IN NUMBER,
884: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
885: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887: x_Return_Status OUT NOCOPY VARCHAR2,
888: x_Msg_Count OUT NOCOPY NUMBER,
889: x_Msg_Data OUT NOCOPY VARCHAR2,
890: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
893: x_Terr_Values_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type );
894:
895: PROCEDURE Create_Terr_Value
896: (P_Api_Version_Number IN NUMBER,
897: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
898: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
899: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
900: P_Terr_Id IN NUMBER,
901: p_terr_qual_id IN NUMBER,
894:
895: PROCEDURE Create_Terr_Value
896: (P_Api_Version_Number IN NUMBER,
897: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
898: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
899: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
900: P_Terr_Id IN NUMBER,
901: p_terr_qual_id IN NUMBER,
902: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
895: PROCEDURE Create_Terr_Value
896: (P_Api_Version_Number IN NUMBER,
897: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
898: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
899: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
900: P_Terr_Id IN NUMBER,
901: p_terr_qual_id IN NUMBER,
902: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
903: X_Return_Status OUT NOCOPY VARCHAR2,
908:
909:
910: PROCEDURE Create_Terr_Value
911: (P_Api_Version_Number IN NUMBER,
912: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
913: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
914: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
915: P_Terr_Id IN NUMBER,
916: p_terr_qual_id IN NUMBER,
909:
910: PROCEDURE Create_Terr_Value
911: (P_Api_Version_Number IN NUMBER,
912: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
913: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
914: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
915: P_Terr_Id IN NUMBER,
916: p_terr_qual_id IN NUMBER,
917: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
910: PROCEDURE Create_Terr_Value
911: (P_Api_Version_Number IN NUMBER,
912: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
913: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
914: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
915: P_Terr_Id IN NUMBER,
916: p_terr_qual_id IN NUMBER,
917: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
918: X_Return_Status OUT NOCOPY VARCHAR2,
922:
923:
924: PROCEDURE Update_Territory_Record
925: ( P_Api_Version_Number IN NUMBER,
926: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
927: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
928: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
929: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
930: X_Return_Status OUT NOCOPY VARCHAR2,
923:
924: PROCEDURE Update_Territory_Record
925: ( P_Api_Version_Number IN NUMBER,
926: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
927: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
928: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
929: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
930: X_Return_Status OUT NOCOPY VARCHAR2,
931: X_Msg_Count OUT NOCOPY NUMBER,
924: PROCEDURE Update_Territory_Record
925: ( P_Api_Version_Number IN NUMBER,
926: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
927: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
928: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
929: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
930: X_Return_Status OUT NOCOPY VARCHAR2,
931: X_Msg_Count OUT NOCOPY NUMBER,
932: X_Msg_Data OUT NOCOPY VARCHAR2,
934: );
935:
936: PROCEDURE Update_Territory_Usages
937: ( P_Api_Version_Number IN NUMBER,
938: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
939: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
940: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
941: P_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
942: X_Return_Status OUT NOCOPY VARCHAR2,
935:
936: PROCEDURE Update_Territory_Usages
937: ( P_Api_Version_Number IN NUMBER,
938: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
939: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
940: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
941: P_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
942: X_Return_Status OUT NOCOPY VARCHAR2,
943: X_Msg_Count OUT NOCOPY NUMBER,
936: PROCEDURE Update_Territory_Usages
937: ( P_Api_Version_Number IN NUMBER,
938: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
939: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
940: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
941: P_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
942: X_Return_Status OUT NOCOPY VARCHAR2,
943: X_Msg_Count OUT NOCOPY NUMBER,
944: X_Msg_Data OUT NOCOPY VARCHAR2,
945: X_Terr_Usgs_Out_Rec OUT NOCOPY Terr_Usgs_Out_Rec_Type);
946:
947: PROCEDURE Update_Territory_Usages
948: ( P_Api_Version_Number IN NUMBER,
949: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
950: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
951: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
952: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
953: X_Return_Status OUT NOCOPY VARCHAR2,
946:
947: PROCEDURE Update_Territory_Usages
948: ( P_Api_Version_Number IN NUMBER,
949: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
950: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
951: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
952: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
953: X_Return_Status OUT NOCOPY VARCHAR2,
954: X_Msg_Count OUT NOCOPY NUMBER,
947: PROCEDURE Update_Territory_Usages
948: ( P_Api_Version_Number IN NUMBER,
949: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
950: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
951: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
952: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
953: X_Return_Status OUT NOCOPY VARCHAR2,
954: X_Msg_Count OUT NOCOPY NUMBER,
955: X_Msg_Data OUT NOCOPY VARCHAR2,
957: );
958:
959: PROCEDURE Update_Terr_QualType_Usage
960: ( P_Api_Version_Number IN NUMBER,
961: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
962: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
964: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
965: X_Return_Status OUT NOCOPY VARCHAR2,
958:
959: PROCEDURE Update_Terr_QualType_Usage
960: ( P_Api_Version_Number IN NUMBER,
961: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
962: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
964: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
965: X_Return_Status OUT NOCOPY VARCHAR2,
966: X_Msg_Count OUT NOCOPY NUMBER,
959: PROCEDURE Update_Terr_QualType_Usage
960: ( P_Api_Version_Number IN NUMBER,
961: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
962: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
964: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
965: X_Return_Status OUT NOCOPY VARCHAR2,
966: X_Msg_Count OUT NOCOPY NUMBER,
967: X_Msg_Data OUT NOCOPY VARCHAR2,
969: );
970:
971: PROCEDURE Update_Terr_QualType_Usage
972: ( P_Api_Version_Number IN NUMBER,
973: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
974: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
977: X_Return_Status OUT NOCOPY VARCHAR2,
970:
971: PROCEDURE Update_Terr_QualType_Usage
972: ( P_Api_Version_Number IN NUMBER,
973: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
974: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
977: X_Return_Status OUT NOCOPY VARCHAR2,
978: X_Msg_Count OUT NOCOPY NUMBER,
971: PROCEDURE Update_Terr_QualType_Usage
972: ( P_Api_Version_Number IN NUMBER,
973: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
974: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
977: X_Return_Status OUT NOCOPY VARCHAR2,
978: X_Msg_Count OUT NOCOPY NUMBER,
979: X_Msg_Data OUT NOCOPY VARCHAR2,
981: );
982:
983: PROCEDURE Update_Terr_Qualifier
984: ( P_Api_Version_Number IN NUMBER,
985: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
986: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
988: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
989: X_Return_Status OUT NOCOPY VARCHAR2,
982:
983: PROCEDURE Update_Terr_Qualifier
984: ( P_Api_Version_Number IN NUMBER,
985: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
986: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
988: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
989: X_Return_Status OUT NOCOPY VARCHAR2,
990: X_Msg_Count OUT NOCOPY NUMBER,
983: PROCEDURE Update_Terr_Qualifier
984: ( P_Api_Version_Number IN NUMBER,
985: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
986: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
988: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
989: X_Return_Status OUT NOCOPY VARCHAR2,
990: X_Msg_Count OUT NOCOPY NUMBER,
991: X_Msg_Data OUT NOCOPY VARCHAR2,
993: );
994:
995: PROCEDURE Update_Terr_Qualifier
996: ( P_Api_Version_Number IN NUMBER,
997: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
998: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
999: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1000: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
1001: X_Return_Status OUT NOCOPY VARCHAR2,
994:
995: PROCEDURE Update_Terr_Qualifier
996: ( P_Api_Version_Number IN NUMBER,
997: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
998: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
999: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1000: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
1001: X_Return_Status OUT NOCOPY VARCHAR2,
1002: X_Msg_Count OUT NOCOPY NUMBER,
995: PROCEDURE Update_Terr_Qualifier
996: ( P_Api_Version_Number IN NUMBER,
997: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
998: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
999: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1000: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
1001: X_Return_Status OUT NOCOPY VARCHAR2,
1002: X_Msg_Count OUT NOCOPY NUMBER,
1003: X_Msg_Data OUT NOCOPY VARCHAR2,
1005: );
1006:
1007: PROCEDURE Update_Terr_Value
1008: ( P_Api_Version_Number IN NUMBER,
1009: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1010: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1011: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1012: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
1013: X_Return_Status OUT NOCOPY VARCHAR2,
1006:
1007: PROCEDURE Update_Terr_Value
1008: ( P_Api_Version_Number IN NUMBER,
1009: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1010: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1011: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1012: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
1013: X_Return_Status OUT NOCOPY VARCHAR2,
1014: X_Msg_Count OUT NOCOPY NUMBER,
1007: PROCEDURE Update_Terr_Value
1008: ( P_Api_Version_Number IN NUMBER,
1009: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1010: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1011: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1012: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
1013: X_Return_Status OUT NOCOPY VARCHAR2,
1014: X_Msg_Count OUT NOCOPY NUMBER,
1015: X_Msg_Data OUT NOCOPY VARCHAR2,
1019:
1020: --Overloaded to take table type input parameter
1021: PROCEDURE Update_Terr_Value
1022: ( P_Api_Version_Number IN NUMBER,
1023: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1024: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1025: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1026: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1027: X_Return_Status OUT NOCOPY VARCHAR2,
1020: --Overloaded to take table type input parameter
1021: PROCEDURE Update_Terr_Value
1022: ( P_Api_Version_Number IN NUMBER,
1023: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1024: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1025: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1026: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1027: X_Return_Status OUT NOCOPY VARCHAR2,
1028: X_Msg_Count OUT NOCOPY NUMBER,
1021: PROCEDURE Update_Terr_Value
1022: ( P_Api_Version_Number IN NUMBER,
1023: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1024: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1025: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1026: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1027: X_Return_Status OUT NOCOPY VARCHAR2,
1028: X_Msg_Count OUT NOCOPY NUMBER,
1029: X_Msg_Data OUT NOCOPY VARCHAR2,
1032:
1033:
1034: PROCEDURE Delete_territory_Record
1035: (P_Api_Version_Number IN NUMBER,
1036: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1037: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1038: P_Terr_Id IN NUMBER,
1039: X_Return_Status OUT NOCOPY VARCHAR2,
1040: X_Msg_Count OUT NOCOPY VARCHAR2,
1033:
1034: PROCEDURE Delete_territory_Record
1035: (P_Api_Version_Number IN NUMBER,
1036: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1037: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1038: P_Terr_Id IN NUMBER,
1039: X_Return_Status OUT NOCOPY VARCHAR2,
1040: X_Msg_Count OUT NOCOPY VARCHAR2,
1041: X_Msg_Data OUT NOCOPY VARCHAR2);
1041: X_Msg_Data OUT NOCOPY VARCHAR2);
1042:
1043: PROCEDURE Delete_Territory_Usages
1044: (P_Api_Version_Number IN NUMBER,
1045: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1046: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1047: P_Terr_usg_Id IN NUMBER,
1048: X_Return_Status OUT NOCOPY VARCHAR2,
1049: X_Msg_Count OUT NOCOPY VARCHAR2,
1042:
1043: PROCEDURE Delete_Territory_Usages
1044: (P_Api_Version_Number IN NUMBER,
1045: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1046: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1047: P_Terr_usg_Id IN NUMBER,
1048: X_Return_Status OUT NOCOPY VARCHAR2,
1049: X_Msg_Count OUT NOCOPY VARCHAR2,
1050: X_Msg_Data OUT NOCOPY VARCHAR2);
1050: X_Msg_Data OUT NOCOPY VARCHAR2);
1051:
1052: PROCEDURE Delete_Terr_QualType_Usage
1053: (P_Api_Version_Number IN NUMBER,
1054: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1055: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1056: P_Terr_Qual_Type_Usg_Id IN NUMBER,
1057: X_Return_Status OUT NOCOPY VARCHAR2,
1058: X_Msg_Count OUT NOCOPY VARCHAR2,
1051:
1052: PROCEDURE Delete_Terr_QualType_Usage
1053: (P_Api_Version_Number IN NUMBER,
1054: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1055: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1056: P_Terr_Qual_Type_Usg_Id IN NUMBER,
1057: X_Return_Status OUT NOCOPY VARCHAR2,
1058: X_Msg_Count OUT NOCOPY VARCHAR2,
1059: X_Msg_Data OUT NOCOPY VARCHAR2);
1059: X_Msg_Data OUT NOCOPY VARCHAR2);
1060:
1061: PROCEDURE Delete_Terr_Qualifier
1062: (P_Api_Version_Number IN NUMBER,
1063: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1064: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1065: P_Terr_Qual_Id IN NUMBER,
1066: X_Return_Status OUT NOCOPY VARCHAR2,
1067: X_Msg_Count OUT NOCOPY VARCHAR2,
1060:
1061: PROCEDURE Delete_Terr_Qualifier
1062: (P_Api_Version_Number IN NUMBER,
1063: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1064: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1065: P_Terr_Qual_Id IN NUMBER,
1066: X_Return_Status OUT NOCOPY VARCHAR2,
1067: X_Msg_Count OUT NOCOPY VARCHAR2,
1068: X_Msg_Data OUT NOCOPY VARCHAR2);
1069:
1070:
1071: PROCEDURE Delete_Terr_Value
1072: (P_Api_Version_Number IN NUMBER,
1073: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1074: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1075: P_Terr_Value_Id IN NUMBER,
1076: X_Return_Status OUT NOCOPY VARCHAR2,
1077: X_Msg_Count OUT NOCOPY VARCHAR2,
1070:
1071: PROCEDURE Delete_Terr_Value
1072: (P_Api_Version_Number IN NUMBER,
1073: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1074: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1075: P_Terr_Value_Id IN NUMBER,
1076: X_Return_Status OUT NOCOPY VARCHAR2,
1077: X_Msg_Count OUT NOCOPY VARCHAR2,
1078: X_Msg_Data OUT NOCOPY VARCHAR2);
1080: -- A generic routine to validate foreign keys
1081: ----------------------------------------------------------------------
1082: PROCEDURE Validate_Foreign_Key
1083: (p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1084: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1085: x_Return_Status OUT NOCOPY VARCHAR2,
1086: x_msg_count OUT NOCOPY NUMBER,
1087: x_msg_data OUT NOCOPY VARCHAR2 );
1088:
1092: ----------------------------------------------------------------------
1093: PROCEDURE Validate_Qualifier
1094: (p_Terr_Id IN NUMBER,
1095: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
1096: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1097: x_Return_Status OUT NOCOPY VARCHAR2,
1098: x_msg_count OUT NOCOPY NUMBER,
1099: x_msg_data OUT NOCOPY VARCHAR2 );
1100:
1106: -- Validate to make sure the territory name is specified and is not duplicate
1107: -- Validate start date , end date , org_id , parent terr_id and Rank.
1108: ---------------------------------------------------------------------
1109: PROCEDURE Validate_Territory_Record
1110: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1111: x_Return_Status OUT NOCOPY VARCHAR2,
1112: x_msg_count OUT NOCOPY NUMBER,
1113: x_msg_data OUT NOCOPY VARCHAR2,
1114: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec);
1121: -- Validate to make sure the territory name is specified and is not duplicate
1122: -- Validate start date and end date
1123: ---------------------------------------------------------------------
1124: PROCEDURE Validate_TerrRec_Update
1125: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1126: x_Return_Status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec);
1137: -- Make sure the Territory Id is valid
1138: -- Make sure the territory usage Id is Valid
1139: ---------------------------------------------------------------------
1140: PROCEDURE Validate_Territory_Usage
1141: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1142: x_Return_Status OUT NOCOPY VARCHAR2,
1143: x_msg_count OUT NOCOPY NUMBER,
1144: x_msg_data OUT NOCOPY VARCHAR2,
1145: p_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_Terr_Usgs_Rec,
1154: -- Make sure the Territory Id is valid
1155: -- Make sure the QUAL_TYPE_USG_ID is valid
1156: ---------------------------------------------------------------------
1157: PROCEDURE Validate_Terr_Qtype_Usage
1158: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1159: x_Return_Status OUT NOCOPY VARCHAR2,
1160: x_msg_count OUT NOCOPY NUMBER,
1161: x_msg_data OUT NOCOPY VARCHAR2,
1162: p_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
1175: --
1176: --
1177: ---------------------------------------------------------------------
1178: PROCEDURE Validate_terr_Value_Rec
1179: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1180: x_Return_Status OUT NOCOPY VARCHAR2,
1181: x_msg_count OUT NOCOPY NUMBER,
1182: x_msg_data OUT NOCOPY VARCHAR2,
1183: p_terr_qual_id IN NUMBER,
1187:
1188: -- CHECK FOR DUPLICATES VALUES
1189: --
1190: PROCEDURE Check_duplicate_Value
1191: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1192: x_Return_Status OUT NOCOPY VARCHAR2,
1193: x_msg_count OUT NOCOPY NUMBER,
1194: x_msg_data OUT NOCOPY VARCHAR2,
1195: p_Terr_Qual_Id IN NUMBER,
1197:
1198: -- CHECK FOR DUPLICATES VALUES
1199: --
1200: PROCEDURE Check_duplicate_Value_update
1201: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202: x_Return_Status OUT NOCOPY VARCHAR2,
1203: x_msg_count OUT NOCOPY NUMBER,
1204: x_msg_data OUT NOCOPY VARCHAR2,
1205: p_Terr_Qual_Id IN NUMBER,
1229: -- generated from this template and not updated manually will be deleted
1230: -- first.
1231: PROCEDURE Gen_Template_Territories (
1232: p_Api_Version_Number IN NUMBER,
1233: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1234: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: p_Template_Terr_Id IN NUMBER,
1237: x_Return_Status OUT NOCOPY VARCHAR2,
1230: -- first.
1231: PROCEDURE Gen_Template_Territories (
1232: p_Api_Version_Number IN NUMBER,
1233: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1234: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: p_Template_Terr_Id IN NUMBER,
1237: x_Return_Status OUT NOCOPY VARCHAR2,
1238: x_Msg_Count OUT NOCOPY NUMBER,
1231: PROCEDURE Gen_Template_Territories (
1232: p_Api_Version_Number IN NUMBER,
1233: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1234: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: p_Template_Terr_Id IN NUMBER,
1237: x_Return_Status OUT NOCOPY VARCHAR2,
1238: x_Msg_Count OUT NOCOPY NUMBER,
1239: x_Msg_Data OUT NOCOPY VARCHAR2,
1255: -- p_first_terr_node_flag - indicates whether this is the first node to be copied
1256:
1257: PROCEDURE Copy_Territory (
1258: p_Api_Version_Number IN NUMBER,
1259: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1260: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1262: p_copy_source_terr_Id IN NUMBER,
1263: p_new_terr_rec IN Terr_All_Rec_Type,
1256:
1257: PROCEDURE Copy_Territory (
1258: p_Api_Version_Number IN NUMBER,
1259: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1260: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1262: p_copy_source_terr_Id IN NUMBER,
1263: p_new_terr_rec IN Terr_All_Rec_Type,
1264: p_copy_rsc_flag IN VARCHAR2 := 'N',
1257: PROCEDURE Copy_Territory (
1258: p_Api_Version_Number IN NUMBER,
1259: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1260: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1262: p_copy_source_terr_Id IN NUMBER,
1263: p_new_terr_rec IN Terr_All_Rec_Type,
1264: p_copy_rsc_flag IN VARCHAR2 := 'N',
1265: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1290: -- check for Unique Key constraint violation on JTF_TERR_USGS table
1291: PROCEDURE validate_terr_usgs_UK(
1292: p_Terr_Id IN NUMBER,
1293: p_Source_Id IN NUMBER,
1294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1295: x_Return_Status OUT NOCOPY VARCHAR2,
1296: x_msg_count OUT NOCOPY NUMBER,
1297: x_msg_data OUT NOCOPY VARCHAR2 );
1298:
1300: -- check for Unique Key constraint violation on JTF_TERR_QTYPE_USGS table
1301: PROCEDURE validate_terr_qtype_usgs_UK(
1302: p_Terr_Id IN NUMBER,
1303: p_Qual_Type_Usg_Id IN NUMBER,
1304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1305: x_Return_Status OUT NOCOPY VARCHAR2,
1306: x_msg_count OUT NOCOPY NUMBER,
1307: x_msg_data OUT NOCOPY VARCHAR2 );
1308:
1309: -- jdochert 10/04
1310: -- check that Number of Winners is valid for this territory
1311: PROCEDURE validate_num_winners(
1312: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1314: x_Return_Status OUT NOCOPY VARCHAR2,
1315: x_msg_count OUT NOCOPY NUMBER,
1316: x_msg_data OUT NOCOPY VARCHAR2,
1317: x_reason OUT NOCOPY VARCHAR2 );
1320: -- check that parent is not already a
1321: -- child of this territory: circular reference check
1322: PROCEDURE validate_parent(
1323: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1325: x_Return_Status OUT NOCOPY VARCHAR2,
1326: x_msg_count OUT NOCOPY NUMBER,
1327: x_msg_data OUT NOCOPY VARCHAR2 );
1328:
1341: errbuf OUT NOCOPY VARCHAR2,
1342: retcode OUT NOCOPY VARCHAR2,
1343: p_copy_source_terr_Id IN NUMBER,
1344: p_name IN VARCHAR2,
1345: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1346: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1347: p_start_date IN DATE,
1348: p_end_date IN DATE := FND_API.G_MISS_DATE,
1349: p_copy_rsc_flag IN VARCHAR2 := 'N',
1342: retcode OUT NOCOPY VARCHAR2,
1343: p_copy_source_terr_Id IN NUMBER,
1344: p_name IN VARCHAR2,
1345: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1346: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1347: p_start_date IN DATE,
1348: p_end_date IN DATE := FND_API.G_MISS_DATE,
1349: p_copy_rsc_flag IN VARCHAR2 := 'N',
1350: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1344: p_name IN VARCHAR2,
1345: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1346: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1347: p_start_date IN DATE,
1348: p_end_date IN DATE := FND_API.G_MISS_DATE,
1349: p_copy_rsc_flag IN VARCHAR2 := 'N',
1350: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1351: p_first_terr_node_flag IN VARCHAR2 := 'N',
1352: p_debug_flag IN VARCHAR2 := 'N',
1356:
1357: FUNCTION conc_req_copy_terr (
1358: p_copy_source_terr_Id IN NUMBER,
1359: p_name IN VARCHAR2,
1360: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1361: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1362: p_start_date IN DATE,
1363: p_end_date IN DATE := FND_API.G_MISS_DATE,
1364: p_copy_rsc_flag IN VARCHAR2 := 'N',
1357: FUNCTION conc_req_copy_terr (
1358: p_copy_source_terr_Id IN NUMBER,
1359: p_name IN VARCHAR2,
1360: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1361: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1362: p_start_date IN DATE,
1363: p_end_date IN DATE := FND_API.G_MISS_DATE,
1364: p_copy_rsc_flag IN VARCHAR2 := 'N',
1365: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1359: p_name IN VARCHAR2,
1360: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1361: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1362: p_start_date IN DATE,
1363: p_end_date IN DATE := FND_API.G_MISS_DATE,
1364: p_copy_rsc_flag IN VARCHAR2 := 'N',
1365: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1366: p_first_terr_node_flag IN VARCHAR2 := 'N'
1367: )
1372: */
1373: FUNCTION get_terr_value_desc (
1374: p_convert_to_id_flag VARCHAR2
1375: , p_display_type VARCHAR2
1376: , p_column_count NUMBER := FND_API.G_MISS_NUM
1377: , p_display_sql VARCHAR2 := FND_API.G_MISS_CHAR
1378: , p_terr_value1 VARCHAR2
1379: , p_terr_value2 VARCHAR2 := FND_API.G_MISS_CHAR
1380: )
1373: FUNCTION get_terr_value_desc (
1374: p_convert_to_id_flag VARCHAR2
1375: , p_display_type VARCHAR2
1376: , p_column_count NUMBER := FND_API.G_MISS_NUM
1377: , p_display_sql VARCHAR2 := FND_API.G_MISS_CHAR
1378: , p_terr_value1 VARCHAR2
1379: , p_terr_value2 VARCHAR2 := FND_API.G_MISS_CHAR
1380: )
1381: RETURN VARCHAR2;
1375: , p_display_type VARCHAR2
1376: , p_column_count NUMBER := FND_API.G_MISS_NUM
1377: , p_display_sql VARCHAR2 := FND_API.G_MISS_CHAR
1378: , p_terr_value1 VARCHAR2
1379: , p_terr_value2 VARCHAR2 := FND_API.G_MISS_CHAR
1380: )
1381: RETURN VARCHAR2;
1382:
1383: --Function for Getting the Qualifier Values.