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,
717: -- p_Terr_Id NUMBER
718: --
719: -- Optional
720: -- Parameter Name Data Type Default
721: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
722: -- p_Commit VARCHAR2 FND_API.G_FALSE
723: --
724: -- OUT NOCOPY :
725: -- Parameter Name Data Type
718: --
719: -- Optional
720: -- Parameter Name Data Type Default
721: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
722: -- p_Commit VARCHAR2 FND_API.G_FALSE
723: --
724: -- OUT NOCOPY :
725: -- Parameter Name Data Type
726: -- x_Return_Status VARCHAR2(1)
734: -- End of Comments
735: --
736: PROCEDURE Deactivate_Territory
737: (p_api_version_number IN NUMBER,
738: p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
739: p_commit IN VARCHAR2 := FND_API.G_FALSE,
740: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
741: x_return_status OUT NOCOPY VARCHAR2,
742: x_msg_count OUT NOCOPY NUMBER,
735: --
736: PROCEDURE Deactivate_Territory
737: (p_api_version_number IN NUMBER,
738: p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
739: p_commit IN VARCHAR2 := FND_API.G_FALSE,
740: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
741: x_return_status OUT NOCOPY VARCHAR2,
742: x_msg_count OUT NOCOPY NUMBER,
743: x_msg_data OUT NOCOPY VARCHAR2,
736: PROCEDURE Deactivate_Territory
737: (p_api_version_number IN NUMBER,
738: p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
739: p_commit IN VARCHAR2 := FND_API.G_FALSE,
740: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
741: x_return_status OUT NOCOPY VARCHAR2,
742: x_msg_count OUT NOCOPY NUMBER,
743: x_msg_data OUT NOCOPY VARCHAR2,
744: P_terr_id IN NUMBER);
763: -- P_Terr_QualTypeUsgs_Tbl Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl
764: --
765: -- Optional
766: -- Parameter Name Data Type Default
767: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
768: -- P_Commit VARCHAR2 := FND_API.G_FALSE
769: --
770: -- OUT NOCOPY :
771: -- Parameter Name Data Type
764: --
765: -- Optional
766: -- Parameter Name Data Type Default
767: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
768: -- P_Commit VARCHAR2 := FND_API.G_FALSE
769: --
770: -- OUT NOCOPY :
771: -- Parameter Name Data Type
772: -- X_Return_Status VARCHAR2(1)
783: -- End of Comments
784: --
785: PROCEDURE Create_Territory_Header
786: (P_Api_Version_Number IN NUMBER,
787: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
788: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
791: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
784: --
785: PROCEDURE Create_Territory_Header
786: (P_Api_Version_Number IN NUMBER,
787: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
788: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
791: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
792: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
785: PROCEDURE Create_Territory_Header
786: (P_Api_Version_Number IN NUMBER,
787: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
788: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
791: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
792: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
793: X_Return_Status OUT NOCOPY VARCHAR2,
798: X_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type);
799:
800: PROCEDURE Create_Territory_Record
801: ( P_Api_Version_Number IN NUMBER,
802: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
803: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
804: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
805: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
806: X_Return_Status OUT NOCOPY VARCHAR2,
799:
800: PROCEDURE Create_Territory_Record
801: ( P_Api_Version_Number IN NUMBER,
802: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
803: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
804: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
805: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
806: X_Return_Status OUT NOCOPY VARCHAR2,
807: X_Msg_Count OUT NOCOPY NUMBER,
800: PROCEDURE Create_Territory_Record
801: ( P_Api_Version_Number IN NUMBER,
802: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
803: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
804: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
805: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
806: X_Return_Status OUT NOCOPY VARCHAR2,
807: X_Msg_Count OUT NOCOPY NUMBER,
808: X_Msg_Data OUT NOCOPY VARCHAR2,
812:
813:
814: PROCEDURE Create_Territory_Usages
815: ( P_Api_Version_Number IN NUMBER,
816: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
817: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
819: P_Terr_Id IN NUMBER,
820: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
813:
814: PROCEDURE Create_Territory_Usages
815: ( P_Api_Version_Number IN NUMBER,
816: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
817: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
819: P_Terr_Id IN NUMBER,
820: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
821: X_Return_Status OUT NOCOPY VARCHAR2,
814: PROCEDURE Create_Territory_Usages
815: ( P_Api_Version_Number IN NUMBER,
816: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
817: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
819: P_Terr_Id IN NUMBER,
820: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
821: X_Return_Status OUT NOCOPY VARCHAR2,
822: X_Msg_Count OUT NOCOPY NUMBER,
826:
827:
828: PROCEDURE Create_Terr_QualType_Usage
829: (P_Api_Version_Number IN NUMBER,
830: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
831: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
833: P_Terr_Id IN NUMBER,
834: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
827:
828: PROCEDURE Create_Terr_QualType_Usage
829: (P_Api_Version_Number IN NUMBER,
830: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
831: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
833: P_Terr_Id IN NUMBER,
834: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
835: X_Return_Status OUT NOCOPY VARCHAR2,
828: PROCEDURE Create_Terr_QualType_Usage
829: (P_Api_Version_Number IN NUMBER,
830: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
831: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
833: P_Terr_Id IN NUMBER,
834: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
835: X_Return_Status OUT NOCOPY VARCHAR2,
836: X_Msg_Count OUT NOCOPY NUMBER,
840:
841:
842: PROCEDURE Create_Terr_QualType_Usage
843: (P_Api_Version_Number IN NUMBER,
844: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
845: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
846: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
847: P_Terr_Id IN NUMBER,
848: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
841:
842: PROCEDURE Create_Terr_QualType_Usage
843: (P_Api_Version_Number IN NUMBER,
844: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
845: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
846: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
847: P_Terr_Id IN NUMBER,
848: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
849: X_Return_Status OUT NOCOPY VARCHAR2,
842: PROCEDURE Create_Terr_QualType_Usage
843: (P_Api_Version_Number IN NUMBER,
844: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
845: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
846: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
847: P_Terr_Id IN NUMBER,
848: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
849: X_Return_Status OUT NOCOPY VARCHAR2,
850: X_Msg_Count OUT NOCOPY NUMBER,
853:
854:
855: PROCEDURE Create_Terr_Qualifier
856: (P_Api_Version_Number IN NUMBER,
857: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
858: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
859: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
860: P_Terr_Id IN NUMBER,
861: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
854:
855: PROCEDURE Create_Terr_Qualifier
856: (P_Api_Version_Number IN NUMBER,
857: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
858: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
859: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
860: P_Terr_Id IN NUMBER,
861: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
862: X_Return_Status OUT NOCOPY VARCHAR2,
855: PROCEDURE Create_Terr_Qualifier
856: (P_Api_Version_Number IN NUMBER,
857: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
858: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
859: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
860: P_Terr_Id IN NUMBER,
861: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
862: X_Return_Status OUT NOCOPY VARCHAR2,
863: X_Msg_Count OUT NOCOPY NUMBER,
868:
869:
870: PROCEDURE Create_Terr_Qualifier
871: (P_Api_Version_Number IN NUMBER,
872: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
873: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
874: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
875: P_Terr_Id IN NUMBER,
876: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
869:
870: PROCEDURE Create_Terr_Qualifier
871: (P_Api_Version_Number IN NUMBER,
872: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
873: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
874: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
875: P_Terr_Id IN NUMBER,
876: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
877: X_Return_Status OUT NOCOPY VARCHAR2,
870: PROCEDURE Create_Terr_Qualifier
871: (P_Api_Version_Number IN NUMBER,
872: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
873: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
874: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
875: P_Terr_Id IN NUMBER,
876: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
877: X_Return_Status OUT NOCOPY VARCHAR2,
878: X_Msg_Count OUT NOCOPY NUMBER,
880: X_Terr_Qual_Out_Tbl OUT NOCOPY Terr_Qual_Out_Tbl_Type);
881:
882: PROCEDURE Create_Terr_Value
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: P_Terr_Id IN NUMBER,
888: p_terr_qual_id IN NUMBER,
881:
882: PROCEDURE Create_Terr_Value
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: P_Terr_Id IN NUMBER,
888: p_terr_qual_id IN NUMBER,
889: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
882: PROCEDURE Create_Terr_Value
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: P_Terr_Id IN NUMBER,
888: p_terr_qual_id IN NUMBER,
889: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
890: X_Return_Status OUT NOCOPY VARCHAR2,
895:
896:
897: PROCEDURE Create_Terr_Value
898: (P_Api_Version_Number IN NUMBER,
899: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
900: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
901: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
902: P_Terr_Id IN NUMBER,
903: p_terr_qual_id IN NUMBER,
896:
897: PROCEDURE Create_Terr_Value
898: (P_Api_Version_Number IN NUMBER,
899: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
900: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
901: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
902: P_Terr_Id IN NUMBER,
903: p_terr_qual_id IN NUMBER,
904: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
897: PROCEDURE Create_Terr_Value
898: (P_Api_Version_Number IN NUMBER,
899: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
900: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
901: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
902: P_Terr_Id IN NUMBER,
903: p_terr_qual_id IN NUMBER,
904: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
905: X_Return_Status OUT NOCOPY VARCHAR2,
909:
910:
911: PROCEDURE Update_Territory_Record
912: ( P_Api_Version_Number IN NUMBER,
913: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
914: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
915: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
916: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
917: X_Return_Status OUT NOCOPY VARCHAR2,
910:
911: PROCEDURE Update_Territory_Record
912: ( P_Api_Version_Number IN NUMBER,
913: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
914: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
915: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
916: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
917: X_Return_Status OUT NOCOPY VARCHAR2,
918: X_Msg_Count OUT NOCOPY NUMBER,
911: PROCEDURE Update_Territory_Record
912: ( P_Api_Version_Number IN NUMBER,
913: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
914: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
915: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
916: P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
917: X_Return_Status OUT NOCOPY VARCHAR2,
918: X_Msg_Count OUT NOCOPY NUMBER,
919: X_Msg_Data OUT NOCOPY VARCHAR2,
921: );
922:
923: PROCEDURE Update_Territory_Usages
924: ( P_Api_Version_Number IN NUMBER,
925: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
926: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
927: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
928: P_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
929: X_Return_Status OUT NOCOPY VARCHAR2,
922:
923: PROCEDURE Update_Territory_Usages
924: ( P_Api_Version_Number IN NUMBER,
925: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
926: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
927: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
928: P_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
929: X_Return_Status OUT NOCOPY VARCHAR2,
930: X_Msg_Count OUT NOCOPY NUMBER,
923: PROCEDURE Update_Territory_Usages
924: ( P_Api_Version_Number IN NUMBER,
925: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
926: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
927: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
928: P_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
929: X_Return_Status OUT NOCOPY VARCHAR2,
930: X_Msg_Count OUT NOCOPY NUMBER,
931: X_Msg_Data OUT NOCOPY VARCHAR2,
932: X_Terr_Usgs_Out_Rec OUT NOCOPY Terr_Usgs_Out_Rec_Type);
933:
934: PROCEDURE Update_Territory_Usages
935: ( P_Api_Version_Number IN NUMBER,
936: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
937: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
940: X_Return_Status OUT NOCOPY VARCHAR2,
933:
934: PROCEDURE Update_Territory_Usages
935: ( P_Api_Version_Number IN NUMBER,
936: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
937: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
940: X_Return_Status OUT NOCOPY VARCHAR2,
941: X_Msg_Count OUT NOCOPY NUMBER,
934: PROCEDURE Update_Territory_Usages
935: ( P_Api_Version_Number IN NUMBER,
936: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
937: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
940: X_Return_Status OUT NOCOPY VARCHAR2,
941: X_Msg_Count OUT NOCOPY NUMBER,
942: X_Msg_Data OUT NOCOPY VARCHAR2,
944: );
945:
946: PROCEDURE Update_Terr_QualType_Usage
947: ( P_Api_Version_Number IN NUMBER,
948: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
949: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
950: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
951: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
952: X_Return_Status OUT NOCOPY VARCHAR2,
945:
946: PROCEDURE Update_Terr_QualType_Usage
947: ( P_Api_Version_Number IN NUMBER,
948: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
949: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
950: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
951: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
952: X_Return_Status OUT NOCOPY VARCHAR2,
953: X_Msg_Count OUT NOCOPY NUMBER,
946: PROCEDURE Update_Terr_QualType_Usage
947: ( P_Api_Version_Number IN NUMBER,
948: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
949: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
950: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
951: P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
952: X_Return_Status OUT NOCOPY VARCHAR2,
953: X_Msg_Count OUT NOCOPY NUMBER,
954: X_Msg_Data OUT NOCOPY VARCHAR2,
956: );
957:
958: PROCEDURE Update_Terr_QualType_Usage
959: ( P_Api_Version_Number IN NUMBER,
960: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
961: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
964: X_Return_Status OUT NOCOPY VARCHAR2,
957:
958: PROCEDURE Update_Terr_QualType_Usage
959: ( P_Api_Version_Number IN NUMBER,
960: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
961: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
964: X_Return_Status OUT NOCOPY VARCHAR2,
965: X_Msg_Count OUT NOCOPY NUMBER,
958: PROCEDURE Update_Terr_QualType_Usage
959: ( P_Api_Version_Number IN NUMBER,
960: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
961: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
964: X_Return_Status OUT NOCOPY VARCHAR2,
965: X_Msg_Count OUT NOCOPY NUMBER,
966: X_Msg_Data OUT NOCOPY VARCHAR2,
968: );
969:
970: PROCEDURE Update_Terr_Qualifier
971: ( P_Api_Version_Number IN NUMBER,
972: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
973: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
974: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
975: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
976: X_Return_Status OUT NOCOPY VARCHAR2,
969:
970: PROCEDURE Update_Terr_Qualifier
971: ( P_Api_Version_Number IN NUMBER,
972: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
973: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
974: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
975: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
976: X_Return_Status OUT NOCOPY VARCHAR2,
977: X_Msg_Count OUT NOCOPY NUMBER,
970: PROCEDURE Update_Terr_Qualifier
971: ( P_Api_Version_Number IN NUMBER,
972: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
973: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
974: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
975: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
976: X_Return_Status OUT NOCOPY VARCHAR2,
977: X_Msg_Count OUT NOCOPY NUMBER,
978: X_Msg_Data OUT NOCOPY VARCHAR2,
980: );
981:
982: PROCEDURE Update_Terr_Qualifier
983: ( P_Api_Version_Number IN NUMBER,
984: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
985: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
988: X_Return_Status OUT NOCOPY VARCHAR2,
981:
982: PROCEDURE Update_Terr_Qualifier
983: ( P_Api_Version_Number IN NUMBER,
984: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
985: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
988: X_Return_Status OUT NOCOPY VARCHAR2,
989: X_Msg_Count OUT NOCOPY NUMBER,
982: PROCEDURE Update_Terr_Qualifier
983: ( P_Api_Version_Number IN NUMBER,
984: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
985: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
988: X_Return_Status OUT NOCOPY VARCHAR2,
989: X_Msg_Count OUT NOCOPY NUMBER,
990: X_Msg_Data OUT NOCOPY VARCHAR2,
992: );
993:
994: PROCEDURE Update_Terr_Value
995: ( P_Api_Version_Number IN NUMBER,
996: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
997: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
998: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
999: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
1000: X_Return_Status OUT NOCOPY VARCHAR2,
993:
994: PROCEDURE Update_Terr_Value
995: ( P_Api_Version_Number IN NUMBER,
996: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
997: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
998: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
999: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
1000: X_Return_Status OUT NOCOPY VARCHAR2,
1001: X_Msg_Count OUT NOCOPY NUMBER,
994: PROCEDURE Update_Terr_Value
995: ( P_Api_Version_Number IN NUMBER,
996: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
997: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
998: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
999: P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
1000: X_Return_Status OUT NOCOPY VARCHAR2,
1001: X_Msg_Count OUT NOCOPY NUMBER,
1002: X_Msg_Data OUT NOCOPY VARCHAR2,
1006:
1007: --Overloaded to take table type input parameter
1008: PROCEDURE Update_Terr_Value
1009: ( P_Api_Version_Number IN NUMBER,
1010: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1011: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1012: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1013: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1014: X_Return_Status OUT NOCOPY VARCHAR2,
1007: --Overloaded to take table type input parameter
1008: PROCEDURE Update_Terr_Value
1009: ( P_Api_Version_Number IN NUMBER,
1010: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1011: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1012: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1013: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1014: X_Return_Status OUT NOCOPY VARCHAR2,
1015: X_Msg_Count OUT NOCOPY NUMBER,
1008: PROCEDURE Update_Terr_Value
1009: ( P_Api_Version_Number IN NUMBER,
1010: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1011: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1012: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1013: P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1014: X_Return_Status OUT NOCOPY VARCHAR2,
1015: X_Msg_Count OUT NOCOPY NUMBER,
1016: X_Msg_Data OUT NOCOPY VARCHAR2,
1019:
1020:
1021: PROCEDURE Delete_territory_Record
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_Terr_Id IN NUMBER,
1026: X_Return_Status OUT NOCOPY VARCHAR2,
1027: X_Msg_Count OUT NOCOPY VARCHAR2,
1020:
1021: PROCEDURE Delete_territory_Record
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_Terr_Id IN NUMBER,
1026: X_Return_Status OUT NOCOPY VARCHAR2,
1027: X_Msg_Count OUT NOCOPY VARCHAR2,
1028: X_Msg_Data OUT NOCOPY VARCHAR2);
1028: X_Msg_Data OUT NOCOPY VARCHAR2);
1029:
1030: PROCEDURE Delete_Territory_Usages
1031: (P_Api_Version_Number IN NUMBER,
1032: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1033: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1034: P_Terr_usg_Id IN NUMBER,
1035: X_Return_Status OUT NOCOPY VARCHAR2,
1036: X_Msg_Count OUT NOCOPY VARCHAR2,
1029:
1030: PROCEDURE Delete_Territory_Usages
1031: (P_Api_Version_Number IN NUMBER,
1032: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1033: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1034: P_Terr_usg_Id IN NUMBER,
1035: X_Return_Status OUT NOCOPY VARCHAR2,
1036: X_Msg_Count OUT NOCOPY VARCHAR2,
1037: X_Msg_Data OUT NOCOPY VARCHAR2);
1037: X_Msg_Data OUT NOCOPY VARCHAR2);
1038:
1039: PROCEDURE Delete_Terr_QualType_Usage
1040: (P_Api_Version_Number IN NUMBER,
1041: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1042: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1043: P_Terr_Qual_Type_Usg_Id IN NUMBER,
1044: X_Return_Status OUT NOCOPY VARCHAR2,
1045: X_Msg_Count OUT NOCOPY VARCHAR2,
1038:
1039: PROCEDURE Delete_Terr_QualType_Usage
1040: (P_Api_Version_Number IN NUMBER,
1041: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1042: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1043: P_Terr_Qual_Type_Usg_Id IN NUMBER,
1044: X_Return_Status OUT NOCOPY VARCHAR2,
1045: X_Msg_Count OUT NOCOPY VARCHAR2,
1046: X_Msg_Data OUT NOCOPY VARCHAR2);
1046: X_Msg_Data OUT NOCOPY VARCHAR2);
1047:
1048: PROCEDURE Delete_Terr_Qualifier
1049: (P_Api_Version_Number IN NUMBER,
1050: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1051: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1052: P_Terr_Qual_Id IN NUMBER,
1053: X_Return_Status OUT NOCOPY VARCHAR2,
1054: X_Msg_Count OUT NOCOPY VARCHAR2,
1047:
1048: PROCEDURE Delete_Terr_Qualifier
1049: (P_Api_Version_Number IN NUMBER,
1050: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1051: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1052: P_Terr_Qual_Id IN NUMBER,
1053: X_Return_Status OUT NOCOPY VARCHAR2,
1054: X_Msg_Count OUT NOCOPY VARCHAR2,
1055: X_Msg_Data OUT NOCOPY VARCHAR2);
1056:
1057:
1058: PROCEDURE Delete_Terr_Value
1059: (P_Api_Version_Number IN NUMBER,
1060: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1061: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1062: P_Terr_Value_Id IN NUMBER,
1063: X_Return_Status OUT NOCOPY VARCHAR2,
1064: X_Msg_Count OUT NOCOPY VARCHAR2,
1057:
1058: PROCEDURE Delete_Terr_Value
1059: (P_Api_Version_Number IN NUMBER,
1060: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1061: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1062: P_Terr_Value_Id IN NUMBER,
1063: X_Return_Status OUT NOCOPY VARCHAR2,
1064: X_Msg_Count OUT NOCOPY VARCHAR2,
1065: X_Msg_Data OUT NOCOPY VARCHAR2);
1067: -- A generic routine to validate foreign keys
1068: ----------------------------------------------------------------------
1069: PROCEDURE Validate_Foreign_Key
1070: (p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1071: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1072: x_Return_Status OUT NOCOPY VARCHAR2,
1073: x_msg_count OUT NOCOPY NUMBER,
1074: x_msg_data OUT NOCOPY VARCHAR2 );
1075:
1079: ----------------------------------------------------------------------
1080: PROCEDURE Validate_Qualifier
1081: (p_Terr_Id IN NUMBER,
1082: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
1083: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1084: x_Return_Status OUT NOCOPY VARCHAR2,
1085: x_msg_count OUT NOCOPY NUMBER,
1086: x_msg_data OUT NOCOPY VARCHAR2 );
1087:
1093: -- Validate to make sure the territory name is specified
1094: -- Validate end date
1095: ---------------------------------------------------------------------
1096: PROCEDURE Validate_Territory_Record
1097: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1098: x_Return_Status OUT NOCOPY VARCHAR2,
1099: x_msg_count OUT NOCOPY NUMBER,
1100: x_msg_data OUT NOCOPY VARCHAR2,
1101: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec);
1108: -- Make sure the Territory Id is valid
1109: -- Make sure the territory usage Id is Valid
1110: ---------------------------------------------------------------------
1111: PROCEDURE Validate_Territory_Usage
1112: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1113: x_Return_Status OUT NOCOPY VARCHAR2,
1114: x_msg_count OUT NOCOPY NUMBER,
1115: x_msg_data OUT NOCOPY VARCHAR2,
1116: p_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_Terr_Usgs_Rec,
1125: -- Make sure the Territory Id is valid
1126: -- Make sure the QUAL_TYPE_USG_ID is valid
1127: ---------------------------------------------------------------------
1128: PROCEDURE Validate_Terr_Qtype_Usage
1129: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1130: x_Return_Status OUT NOCOPY VARCHAR2,
1131: x_msg_count OUT NOCOPY NUMBER,
1132: x_msg_data OUT NOCOPY VARCHAR2,
1133: p_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
1146: --
1147: --
1148: ---------------------------------------------------------------------
1149: PROCEDURE Validate_terr_Value_Rec
1150: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1151: x_Return_Status OUT NOCOPY VARCHAR2,
1152: x_msg_count OUT NOCOPY NUMBER,
1153: x_msg_data OUT NOCOPY VARCHAR2,
1154: p_terr_qual_id IN NUMBER,
1179: -- generated from this template and not updated manually will be deleted
1180: -- first.
1181: PROCEDURE Gen_Template_Territories (
1182: p_Api_Version_Number IN NUMBER,
1183: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1184: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1186: p_Template_Terr_Id IN NUMBER,
1187: x_Return_Status OUT NOCOPY VARCHAR2,
1180: -- first.
1181: PROCEDURE Gen_Template_Territories (
1182: p_Api_Version_Number IN NUMBER,
1183: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1184: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1186: p_Template_Terr_Id IN NUMBER,
1187: x_Return_Status OUT NOCOPY VARCHAR2,
1188: x_Msg_Count OUT NOCOPY NUMBER,
1181: PROCEDURE Gen_Template_Territories (
1182: p_Api_Version_Number IN NUMBER,
1183: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1184: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1186: p_Template_Terr_Id IN NUMBER,
1187: x_Return_Status OUT NOCOPY VARCHAR2,
1188: x_Msg_Count OUT NOCOPY NUMBER,
1189: x_Msg_Data OUT NOCOPY VARCHAR2,
1205: -- p_first_terr_node_flag - indicates whether this is the first node to be copied
1206:
1207: PROCEDURE Copy_Territory (
1208: p_Api_Version_Number IN NUMBER,
1209: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1210: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1212: p_copy_source_terr_Id IN NUMBER,
1213: p_new_terr_rec IN Terr_All_Rec_Type,
1206:
1207: PROCEDURE Copy_Territory (
1208: p_Api_Version_Number IN NUMBER,
1209: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1210: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1212: p_copy_source_terr_Id IN NUMBER,
1213: p_new_terr_rec IN Terr_All_Rec_Type,
1214: p_copy_rsc_flag IN VARCHAR2 := 'N',
1207: PROCEDURE Copy_Territory (
1208: p_Api_Version_Number IN NUMBER,
1209: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1210: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1212: p_copy_source_terr_Id IN NUMBER,
1213: p_new_terr_rec IN Terr_All_Rec_Type,
1214: p_copy_rsc_flag IN VARCHAR2 := 'N',
1215: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1240: -- check for Unique Key constraint violation on JTF_TERR_USGS table
1241: PROCEDURE validate_terr_usgs_UK(
1242: p_Terr_Id IN NUMBER,
1243: p_Source_Id IN NUMBER,
1244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1245: x_Return_Status OUT NOCOPY VARCHAR2,
1246: x_msg_count OUT NOCOPY NUMBER,
1247: x_msg_data OUT NOCOPY VARCHAR2 );
1248:
1250: -- check for Unique Key constraint violation on JTF_TERR_QTYPE_USGS table
1251: PROCEDURE validate_terr_qtype_usgs_UK(
1252: p_Terr_Id IN NUMBER,
1253: p_Qual_Type_Usg_Id IN NUMBER,
1254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1255: x_Return_Status OUT NOCOPY VARCHAR2,
1256: x_msg_count OUT NOCOPY NUMBER,
1257: x_msg_data OUT NOCOPY VARCHAR2 );
1258:
1259: -- jdochert 10/04
1260: -- check that Number of Winners is valid for this territory
1261: PROCEDURE validate_num_winners(
1262: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1264: x_Return_Status OUT NOCOPY VARCHAR2,
1265: x_msg_count OUT NOCOPY NUMBER,
1266: x_msg_data OUT NOCOPY VARCHAR2,
1267: x_reason OUT NOCOPY VARCHAR2 );
1270: -- check that parent is not already a
1271: -- child of this territory: circular reference check
1272: PROCEDURE validate_parent(
1273: p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1274: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1275: x_Return_Status OUT NOCOPY VARCHAR2,
1276: x_msg_count OUT NOCOPY NUMBER,
1277: x_msg_data OUT NOCOPY VARCHAR2 );
1278:
1291: errbuf OUT NOCOPY VARCHAR2,
1292: retcode OUT NOCOPY VARCHAR2,
1293: p_copy_source_terr_Id IN NUMBER,
1294: p_name IN VARCHAR2,
1295: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1296: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1297: p_start_date IN DATE,
1298: p_end_date IN DATE := FND_API.G_MISS_DATE,
1299: p_copy_rsc_flag IN VARCHAR2 := 'N',
1292: retcode OUT NOCOPY VARCHAR2,
1293: p_copy_source_terr_Id IN NUMBER,
1294: p_name IN VARCHAR2,
1295: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1296: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1297: p_start_date IN DATE,
1298: p_end_date IN DATE := FND_API.G_MISS_DATE,
1299: p_copy_rsc_flag IN VARCHAR2 := 'N',
1300: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1294: p_name IN VARCHAR2,
1295: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1296: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1297: p_start_date IN DATE,
1298: p_end_date IN DATE := FND_API.G_MISS_DATE,
1299: p_copy_rsc_flag IN VARCHAR2 := 'N',
1300: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1301: p_first_terr_node_flag IN VARCHAR2 := 'N',
1302: p_debug_flag IN VARCHAR2 := 'N',
1306:
1307: FUNCTION conc_req_copy_terr (
1308: p_copy_source_terr_Id IN NUMBER,
1309: p_name IN VARCHAR2,
1310: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1311: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1312: p_start_date IN DATE,
1313: p_end_date IN DATE := FND_API.G_MISS_DATE,
1314: p_copy_rsc_flag IN VARCHAR2 := 'N',
1307: FUNCTION conc_req_copy_terr (
1308: p_copy_source_terr_Id IN NUMBER,
1309: p_name IN VARCHAR2,
1310: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1311: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1312: p_start_date IN DATE,
1313: p_end_date IN DATE := FND_API.G_MISS_DATE,
1314: p_copy_rsc_flag IN VARCHAR2 := 'N',
1315: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1309: p_name IN VARCHAR2,
1310: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1311: p_rank IN NUMBER := FND_API.G_MISS_NUM,
1312: p_start_date IN DATE,
1313: p_end_date IN DATE := FND_API.G_MISS_DATE,
1314: p_copy_rsc_flag IN VARCHAR2 := 'N',
1315: p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1316: p_first_terr_node_flag IN VARCHAR2 := 'N'
1317: )
1322: */
1323: FUNCTION get_terr_value_desc (
1324: p_convert_to_id_flag VARCHAR2
1325: , p_display_type VARCHAR2
1326: , p_column_count NUMBER := FND_API.G_MISS_NUM
1327: , p_display_sql VARCHAR2 := FND_API.G_MISS_CHAR
1328: , p_terr_value1 VARCHAR2
1329: , p_terr_value2 VARCHAR2 := FND_API.G_MISS_CHAR
1330: )
1323: FUNCTION get_terr_value_desc (
1324: p_convert_to_id_flag VARCHAR2
1325: , p_display_type VARCHAR2
1326: , p_column_count NUMBER := FND_API.G_MISS_NUM
1327: , p_display_sql VARCHAR2 := FND_API.G_MISS_CHAR
1328: , p_terr_value1 VARCHAR2
1329: , p_terr_value2 VARCHAR2 := FND_API.G_MISS_CHAR
1330: )
1331: RETURN VARCHAR2;
1325: , p_display_type VARCHAR2
1326: , p_column_count NUMBER := FND_API.G_MISS_NUM
1327: , p_display_sql VARCHAR2 := FND_API.G_MISS_CHAR
1328: , p_terr_value1 VARCHAR2
1329: , p_terr_value2 VARCHAR2 := FND_API.G_MISS_CHAR
1330: )
1331: RETURN VARCHAR2;
1332:
1333: