eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on FND_API

Line 80: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,

76: -- End of Comments
77:
78: TYPE TerrResource_rec_type IS RECORD
79: (
80: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
81: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

Line 81: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,

77:
78: TYPE TerrResource_rec_type IS RECORD
79: (
80: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
81: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

Line 82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

78: TYPE TerrResource_rec_type IS RECORD
79: (
80: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
81: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,

Line 83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,

79: (
80: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
81: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,

Line 84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

80: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
81: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

Line 85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

81: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

Line 86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,

82: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

Line 87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,

83: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,

Line 88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

84: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

Line 89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

85: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE

Line 90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

86: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
94: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,

Line 91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,

87: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
94: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
95: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,

Line 92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

88: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
94: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
95: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
96: PERSON_ID NUMBER,

Line 93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE

89: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
94: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
95: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
96: PERSON_ID NUMBER,
97: -- Adding the attribute columns as fix for bug 7168485.

Line 94: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,

90: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
94: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
95: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
96: PERSON_ID NUMBER,
97: -- Adding the attribute columns as fix for bug 7168485.
98: ATTRIBUTE_CATEGORY VARCHAR2(30),

Line 95: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,

91: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
92: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
93: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
94: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
95: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
96: PERSON_ID NUMBER,
97: -- Adding the attribute columns as fix for bug 7168485.
98: ATTRIBUTE_CATEGORY VARCHAR2(30),
99: ATTRIBUTE1 VARCHAR2(150),

Line 119: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,

115: );
116:
117: TYPE TerrResource_rec_type_wflex IS RECORD
118: (
119: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
120: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

Line 120: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,

116:
117: TYPE TerrResource_rec_type_wflex IS RECORD
118: (
119: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
120: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

Line 121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

117: TYPE TerrResource_rec_type_wflex IS RECORD
118: (
119: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
120: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,

Line 122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,

118: (
119: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
120: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,

Line 123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

119: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
120: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

Line 124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

120: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

Line 125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,

121: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

Line 126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,

122: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,

Line 127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

123: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

Line 128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

124: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE

Line 129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

125: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
133: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,

Line 130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,

126: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
133: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
134: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,

Line 131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

127: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
133: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
134: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
135: PERSON_ID NUMBER,

Line 132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE

128: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
133: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
134: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
135: PERSON_ID NUMBER,
136: ATTRIBUTE_CATEGORY VARCHAR2(30),

Line 133: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,

129: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
133: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
134: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
135: PERSON_ID NUMBER,
136: ATTRIBUTE_CATEGORY VARCHAR2(30),
137: ATTRIBUTE1 VARCHAR2(150),

Line 134: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,

130: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
131: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
132: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
133: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
134: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
135: PERSON_ID NUMBER,
136: ATTRIBUTE_CATEGORY VARCHAR2(30),
137: ATTRIBUTE1 VARCHAR2(150),
138: ATTRIBUTE2 VARCHAR2(150),

Line 185: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,

181:
182:
183: TYPE TerrResource_out_rec_type IS RECORD
184: (
185: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
186: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
187: );
188:
189: G_MISS_TERRRESOURCE_OUT_REC TerrResource_out_rec_type;

Line 186: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR

182:
183: TYPE TerrResource_out_rec_type IS RECORD
184: (
185: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
186: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
187: );
188:
189: G_MISS_TERRRESOURCE_OUT_REC TerrResource_out_rec_type;
190:

Line 214: -- ORG_ID NUMBER := FND_API.G_MISS_NUM

210: -- CREATED_BY Part of std who columns
211: -- LAST_UPDATE_LOGIN Part of std who columns
212: -- TERR_RSC_ID Territory resource id
213: -- ACCESS_TYPE Resource acces eg: ACCOUNT/LEADS
214: -- ORG_ID NUMBER := FND_API.G_MISS_NUM
215: -- TRANS_ACCESS_CODE access type
216: -- Defaults:
217: -- Note:
218: --

Line 224: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,

220:
221:
222: TYPE TerrRsc_Access_Rec_type IS RECORD
223: (
224: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
225: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,

Line 225: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,

221:
222: TYPE TerrRsc_Access_Rec_type IS RECORD
223: (
224: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
225: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,

Line 226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,

222: TYPE TerrRsc_Access_Rec_type IS RECORD
223: (
224: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
225: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,

Line 227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,

223: (
224: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
225: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,

Line 228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,

224: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
225: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,

Line 229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,

225: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
233: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM

Line 230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,

226: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
233: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
234: TRANS_ACCESS_CODE VARCHAR2(15)

Line 231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,

227: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
233: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
234: TRANS_ACCESS_CODE VARCHAR2(15)
235: );

Line 232: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,

228: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
233: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
234: TRANS_ACCESS_CODE VARCHAR2(15)
235: );
236:

Line 233: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM

229: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
230: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
231: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
232: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
233: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
234: TRANS_ACCESS_CODE VARCHAR2(15)
235: );
236:
237:

Line 265: TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,

261:
262:
263: TYPE TerrRsc_Access_Out_rec_type IS RECORD
264: (
265: TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
266: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
267: );
268:
269: G_MISS_TERRRSC_ACCESS_OUT_REC TerrRsc_Access_Out_rec_type;

Line 266: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR

262:
263: TYPE TerrRsc_Access_Out_rec_type IS RECORD
264: (
265: TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
266: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
267: );
268:
269: G_MISS_TERRRSC_ACCESS_OUT_REC TerrRsc_Access_Out_rec_type;
270:

Line 298: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,

294: -- Parameter Name Data Type Default
295: -- p_Api_Version_Number NUMBER
296: -- p_TerrRsc_Tbl TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL
297: -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
298: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: --
300: -- Optional
301: -- Parameter Name Data Type Default
302: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

Line 302: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

298: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: --
300: -- Optional
301: -- Parameter Name Data Type Default
302: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
303: -- p_Commit VARCHAR2 := FND_API.G_FALSE
304: --
305: -- OUT :
306: -- Parameter Name Data Type

Line 303: -- p_Commit VARCHAR2 := FND_API.G_FALSE

299: --
300: -- Optional
301: -- Parameter Name Data Type Default
302: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
303: -- p_Commit VARCHAR2 := FND_API.G_FALSE
304: --
305: -- OUT :
306: -- Parameter Name Data Type
307: -- x_Return_Status VARCHAR2(1)

Line 323: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

319:
320: PROCEDURE Create_TerrResource
321: (
322: p_Api_Version_Number IN NUMBER,
323: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
324: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326: x_Return_Status OUT NOCOPY VARCHAR2,
327: x_Msg_Count OUT NOCOPY NUMBER,

Line 324: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

320: PROCEDURE Create_TerrResource
321: (
322: p_Api_Version_Number IN NUMBER,
323: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
324: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326: x_Return_Status OUT NOCOPY VARCHAR2,
327: x_Msg_Count OUT NOCOPY NUMBER,
328: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

321: (
322: p_Api_Version_Number IN NUMBER,
323: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
324: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326: x_Return_Status OUT NOCOPY VARCHAR2,
327: x_Msg_Count OUT NOCOPY NUMBER,
328: x_Msg_Data OUT NOCOPY VARCHAR2,
329: p_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,

Line 338: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

334:
335: PROCEDURE Create_TerrResource
336: (
337: p_Api_Version_Number IN NUMBER,
338: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
339: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: x_Return_Status OUT NOCOPY VARCHAR2,
342: x_Msg_Count OUT NOCOPY NUMBER,

Line 339: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

335: PROCEDURE Create_TerrResource
336: (
337: p_Api_Version_Number IN NUMBER,
338: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
339: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: x_Return_Status OUT NOCOPY VARCHAR2,
342: x_Msg_Count OUT NOCOPY NUMBER,
343: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

336: (
337: p_Api_Version_Number IN NUMBER,
338: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
339: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: x_Return_Status OUT NOCOPY VARCHAR2,
342: x_Msg_Count OUT NOCOPY NUMBER,
343: x_Msg_Data OUT NOCOPY VARCHAR2,
344: p_TerrRsc_Tbl IN TerrResource_tbl_type_wflex := G_MISS_TERRRESOURCE_TBL_WFLEX,

Line 372: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE

368: -- p_TerrRsc_Id NUMBER
369: --
370: -- Optional
371: -- Parameter Name Data Type Default
372: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
373: -- p_Commit VARCHAR2 FND_API.G_FALSE
374: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,
375: --
376: -- OUT :

Line 373: -- p_Commit VARCHAR2 FND_API.G_FALSE

369: --
370: -- Optional
371: -- Parameter Name Data Type Default
372: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
373: -- p_Commit VARCHAR2 FND_API.G_FALSE
374: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,
375: --
376: -- OUT :
377: -- Parameter Name Data Type

Line 374: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,

370: -- Optional
371: -- Parameter Name Data Type Default
372: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
373: -- p_Commit VARCHAR2 FND_API.G_FALSE
374: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,
375: --
376: -- OUT :
377: -- Parameter Name Data Type
378: -- X_Return_Status VARCHAR2(1)

Line 392: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

388:
389: PROCEDURE Delete_Terr_Resource
390: (
391: p_Api_Version_Number IN NUMBER,
392: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: X_Return_Status OUT NOCOPY VARCHAR2,
396: X_Msg_Count OUT NOCOPY NUMBER,

Line 393: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

389: PROCEDURE Delete_Terr_Resource
390: (
391: p_Api_Version_Number IN NUMBER,
392: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: X_Return_Status OUT NOCOPY VARCHAR2,
396: X_Msg_Count OUT NOCOPY NUMBER,
397: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 394: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

390: (
391: p_Api_Version_Number IN NUMBER,
392: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: X_Return_Status OUT NOCOPY VARCHAR2,
396: X_Msg_Count OUT NOCOPY NUMBER,
397: X_Msg_Data OUT NOCOPY VARCHAR2,
398: p_TerrRsc_Id IN NUMBER

Line 424: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

420: -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
421: --
422: -- Optional
423: -- Parameter Name Data Type Default
424: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
425: -- p_Commit VARCHAR2 := FND_API.G_FALSE
426: --
427: -- OUT :
428: -- Parameter Name Data Type

Line 425: -- p_Commit VARCHAR2 := FND_API.G_FALSE

421: --
422: -- Optional
423: -- Parameter Name Data Type Default
424: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
425: -- p_Commit VARCHAR2 := FND_API.G_FALSE
426: --
427: -- OUT :
428: -- Parameter Name Data Type
429: -- x_Return_Status VARCHAR2(1)

Line 445: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

441:
442: PROCEDURE Update_TerrResource
443: (
444: p_Api_Version_Number IN NUMBER,
445: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
446: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: x_Return_Status OUT NOCOPY VARCHAR2,
449: x_Msg_Count OUT NOCOPY NUMBER,

Line 446: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

442: PROCEDURE Update_TerrResource
443: (
444: p_Api_Version_Number IN NUMBER,
445: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
446: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: x_Return_Status OUT NOCOPY VARCHAR2,
449: x_Msg_Count OUT NOCOPY NUMBER,
450: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

443: (
444: p_Api_Version_Number IN NUMBER,
445: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
446: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: x_Return_Status OUT NOCOPY VARCHAR2,
449: x_Msg_Count OUT NOCOPY NUMBER,
450: x_Msg_Data OUT NOCOPY VARCHAR2,
451: p_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,

Line 489: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

485: PROCEDURE Create_Terr_Resource
486: (
487: P_TerrRsc_Rec IN TerrResource_Rec_type,
488: p_Api_Version_Number IN NUMBER,
489: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
490: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492: x_Return_Status OUT NOCOPY VARCHAR2,
493: x_Msg_Count OUT NOCOPY NUMBER,

Line 490: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

486: (
487: P_TerrRsc_Rec IN TerrResource_Rec_type,
488: p_Api_Version_Number IN NUMBER,
489: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
490: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492: x_Return_Status OUT NOCOPY VARCHAR2,
493: x_Msg_Count OUT NOCOPY NUMBER,
494: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

487: P_TerrRsc_Rec IN TerrResource_Rec_type,
488: p_Api_Version_Number IN NUMBER,
489: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
490: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492: x_Return_Status OUT NOCOPY VARCHAR2,
493: x_Msg_Count OUT NOCOPY NUMBER,
494: x_Msg_Data OUT NOCOPY VARCHAR2,
495: X_TerrRsc_Out_Rec OUT NOCOPY TerrResource_out_Rec_type

Line 527: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

523: PROCEDURE Create_Terr_Resource
524: (
525: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
526: p_Api_Version_Number IN NUMBER,
527: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
528: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
529: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
530: x_Return_Status OUT NOCOPY VARCHAR2,
531: x_Msg_Count OUT NOCOPY NUMBER,

Line 528: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

524: (
525: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
526: p_Api_Version_Number IN NUMBER,
527: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
528: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
529: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
530: x_Return_Status OUT NOCOPY VARCHAR2,
531: x_Msg_Count OUT NOCOPY NUMBER,
532: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 529: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

525: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
526: p_Api_Version_Number IN NUMBER,
527: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
528: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
529: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
530: x_Return_Status OUT NOCOPY VARCHAR2,
531: x_Msg_Count OUT NOCOPY NUMBER,
532: x_Msg_Data OUT NOCOPY VARCHAR2,
533: X_TerrRsc_Out_Tbl OUT NOCOPY TerrResource_out_tbl_type

Line 566: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

562: (
563: p_TerrRsc_Id NUMBER,
564: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
565: p_Api_Version_Number IN NUMBER,
566: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
567: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
568: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
569: x_Return_Status OUT NOCOPY VARCHAR2,
570: x_Msg_Count OUT NOCOPY NUMBER,

Line 567: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

563: p_TerrRsc_Id NUMBER,
564: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
565: p_Api_Version_Number IN NUMBER,
566: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
567: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
568: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
569: x_Return_Status OUT NOCOPY VARCHAR2,
570: x_Msg_Count OUT NOCOPY NUMBER,
571: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 568: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

564: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
565: p_Api_Version_Number IN NUMBER,
566: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
567: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
568: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
569: x_Return_Status OUT NOCOPY VARCHAR2,
570: x_Msg_Count OUT NOCOPY NUMBER,
571: x_Msg_Data OUT NOCOPY VARCHAR2,
572: X_TerrRsc_Access_Out_Rec OUT NOCOPY TerrRsc_Access_out_rec_type

Line 611: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

607: (
608: p_TerrRsc_Id NUMBER,
609: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
610: p_Api_Version_Number IN NUMBER,
611: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
612: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_Return_Status OUT NOCOPY VARCHAR2,
615: x_Msg_Count OUT NOCOPY NUMBER,

Line 612: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

608: p_TerrRsc_Id NUMBER,
609: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
610: p_Api_Version_Number IN NUMBER,
611: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
612: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_Return_Status OUT NOCOPY VARCHAR2,
615: x_Msg_Count OUT NOCOPY NUMBER,
616: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

609: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
610: p_Api_Version_Number IN NUMBER,
611: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
612: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_Return_Status OUT NOCOPY VARCHAR2,
615: x_Msg_Count OUT NOCOPY NUMBER,
616: x_Msg_Data OUT NOCOPY VARCHAR2,
617: X_TerrRsc_Access_Out_Tbl OUT NOCOPY TerrRsc_Access_out_Tbl_type

Line 635: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

631: -- IN
632: -- Required:
633: -- Parameter Name Data Type Default
634: -- P_Api_Version_Number IN NUMBER,
635: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
636: -- P_Commit IN VARCHAR2 := FND_API.G_FALSE
637: -- P_TerrRsc_Id IN NUMBER
638: --
639: -- Optional:

Line 636: -- P_Commit IN VARCHAR2 := FND_API.G_FALSE

632: -- Required:
633: -- Parameter Name Data Type Default
634: -- P_Api_Version_Number IN NUMBER,
635: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
636: -- P_Commit IN VARCHAR2 := FND_API.G_FALSE
637: -- P_TerrRsc_Id IN NUMBER
638: --
639: -- Optional:
640: -- OUT:

Line 652: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

648:
649: PROCEDURE Delete_TerrResource
650: (
651: P_Api_Version_Number IN NUMBER,
652: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
653: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
654: P_TerrRsc_Id IN NUMBER,
655: X_Return_Status OUT NOCOPY VARCHAR2,
656: X_Msg_Count OUT NOCOPY VARCHAR2,

Line 653: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

649: PROCEDURE Delete_TerrResource
650: (
651: P_Api_Version_Number IN NUMBER,
652: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
653: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
654: P_TerrRsc_Id IN NUMBER,
655: X_Return_Status OUT NOCOPY VARCHAR2,
656: X_Msg_Count OUT NOCOPY VARCHAR2,
657: X_Msg_Data OUT NOCOPY VARCHAR2

Line 674: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

670: -- Parameters:
671: -- IN
672: -- Parameter Name Data Type Default
673: -- P_Api_Version_Number NUMBER,
674: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
675: -- P_Commit VARCHAR2 := FND_API.G_FALSE
676: -- P_TerrRsc_Access_Id NUMBER
677: --
678: -- Optional:

Line 675: -- P_Commit VARCHAR2 := FND_API.G_FALSE

671: -- IN
672: -- Parameter Name Data Type Default
673: -- P_Api_Version_Number NUMBER,
674: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
675: -- P_Commit VARCHAR2 := FND_API.G_FALSE
676: -- P_TerrRsc_Access_Id NUMBER
677: --
678: -- Optional:
679: --

Line 692: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

688:
689: PROCEDURE Delete_TerrRsc_Access
690: (
691: P_Api_Version_Number IN NUMBER,
692: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
693: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
694: P_TerrRsc_Access_Id IN NUMBER,
695: X_Return_Status OUT NOCOPY VARCHAR2,
696: X_Msg_Count OUT NOCOPY VARCHAR2,

Line 693: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

689: PROCEDURE Delete_TerrRsc_Access
690: (
691: P_Api_Version_Number IN NUMBER,
692: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
693: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
694: P_TerrRsc_Access_Id IN NUMBER,
695: X_Return_Status OUT NOCOPY VARCHAR2,
696: X_Msg_Count OUT NOCOPY VARCHAR2,
697: X_Msg_Data OUT NOCOPY VARCHAR2

Line 734: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

730: PROCEDURE Update_Terr_Resource
731: (
732: P_TerrRsc_Rec IN TerrResource_Rec_type,
733: p_Api_Version_Number IN NUMBER,
734: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
735: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
736: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
737: x_Return_Status OUT NOCOPY VARCHAR2,
738: x_Msg_Count OUT NOCOPY NUMBER,

Line 735: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

731: (
732: P_TerrRsc_Rec IN TerrResource_Rec_type,
733: p_Api_Version_Number IN NUMBER,
734: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
735: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
736: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
737: x_Return_Status OUT NOCOPY VARCHAR2,
738: x_Msg_Count OUT NOCOPY NUMBER,
739: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 736: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

732: P_TerrRsc_Rec IN TerrResource_Rec_type,
733: p_Api_Version_Number IN NUMBER,
734: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
735: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
736: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
737: x_Return_Status OUT NOCOPY VARCHAR2,
738: x_Msg_Count OUT NOCOPY NUMBER,
739: x_Msg_Data OUT NOCOPY VARCHAR2,
740: X_TerrRsc_Out_Rec OUT NOCOPY TerrResource_out_Rec_type

Line 774: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

770: PROCEDURE Update_Terr_Resource
771: (
772: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
773: p_Api_Version_Number IN NUMBER,
774: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
775: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
776: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
777: x_Return_Status OUT NOCOPY VARCHAR2,
778: x_Msg_Count OUT NOCOPY NUMBER,

Line 775: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

771: (
772: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
773: p_Api_Version_Number IN NUMBER,
774: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
775: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
776: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
777: x_Return_Status OUT NOCOPY VARCHAR2,
778: x_Msg_Count OUT NOCOPY NUMBER,
779: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 776: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

772: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
773: p_Api_Version_Number IN NUMBER,
774: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
775: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
776: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
777: x_Return_Status OUT NOCOPY VARCHAR2,
778: x_Msg_Count OUT NOCOPY NUMBER,
779: x_Msg_Data OUT NOCOPY VARCHAR2,
780: X_TerrRsc_Out_Tbl OUT NOCOPY TerrResource_out_tbl_type

Line 818: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

814: PROCEDURE Update_Resource_Access
815: (
816: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
817: p_Api_Version_Number IN NUMBER,
818: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
819: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
820: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
821: x_Return_Status OUT NOCOPY VARCHAR2,
822: x_Msg_Count OUT NOCOPY NUMBER,

Line 819: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

815: (
816: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
817: p_Api_Version_Number IN NUMBER,
818: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
819: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
820: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
821: x_Return_Status OUT NOCOPY VARCHAR2,
822: x_Msg_Count OUT NOCOPY NUMBER,
823: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 820: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

816: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
817: p_Api_Version_Number IN NUMBER,
818: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
819: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
820: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
821: x_Return_Status OUT NOCOPY VARCHAR2,
822: x_Msg_Count OUT NOCOPY NUMBER,
823: x_Msg_Data OUT NOCOPY VARCHAR2,
824: X_TerrRsc_Access_Out_Rec OUT NOCOPY TerrRsc_Access_out_rec_type

Line 864: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

860: PROCEDURE Update_Resource_Access
861: (
862: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
863: p_Api_Version_Number IN NUMBER,
864: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
865: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: x_Return_Status OUT NOCOPY VARCHAR2,
868: x_Msg_Count OUT NOCOPY NUMBER,

Line 865: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

861: (
862: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
863: p_Api_Version_Number IN NUMBER,
864: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
865: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: x_Return_Status OUT NOCOPY VARCHAR2,
868: x_Msg_Count OUT NOCOPY NUMBER,
869: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

862: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
863: p_Api_Version_Number IN NUMBER,
864: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
865: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: x_Return_Status OUT NOCOPY VARCHAR2,
868: x_Msg_Count OUT NOCOPY NUMBER,
869: x_Msg_Data OUT NOCOPY VARCHAR2,
870: X_TerrRsc_Access_Out_Tbl OUT NOCOPY TerrRsc_Access_out_Tbl_type

Line 923: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

919: -- Make sure the Territory Id is valid
920: ---------------------------------------------------------------------
921: PROCEDURE Validate_Terr_Rsc
922: (
923: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
924: x_Return_Status OUT NOCOPY VARCHAR2,
925: x_msg_count OUT NOCOPY NUMBER,
926: x_msg_data OUT NOCOPY VARCHAR2,
927: p_TerrRsc_Rec IN TerrResource_Rec_type

Line 940: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

936: -- Make sure the ACCESS_TYPE is valid
937: ---------------------------------------------------------------------
938: PROCEDURE Validate_Terr_Rsc_Access
939: (
940: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
941: x_Return_Status OUT NOCOPY VARCHAR2,
942: x_msg_count OUT NOCOPY NUMBER,
943: x_msg_data OUT NOCOPY VARCHAR2,
944: p_TerrRsc_Id IN NUMBER,

Line 1018: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1014: */
1015: PROCEDURE validate_terr_rsc_access_UK(
1016: p_Terr_Rsc_Id IN NUMBER,
1017: p_Access_Type IN VARCHAR2,
1018: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1019: x_Return_Status OUT NOCOPY VARCHAR2,
1020: x_msg_count OUT NOCOPY NUMBER,
1021: x_msg_data OUT NOCOPY VARCHAR2 );
1022:

Line 1038: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1034: -- IN :
1035: -- Required
1036: -- Parameter Name Data Type Default
1037: -- p_Api_Version_Number IN NUMBER,
1038: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1039: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1040: -- p_source_terr_id NUMBER
1041: -- p_dest_terr_id NUMBER
1042: --

Line 1039: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1035: -- Required
1036: -- Parameter Name Data Type Default
1037: -- p_Api_Version_Number IN NUMBER,
1038: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1039: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1040: -- p_source_terr_id NUMBER
1041: -- p_dest_terr_id NUMBER
1042: --
1043: -- Optional

Line 1058: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1054: -- End of Comments
1055: --
1056: PROCEDURE Copy_Terr_Resources (
1057: p_Api_Version_Number IN NUMBER,
1058: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1059: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1061: p_source_terr_id IN NUMBER,
1062: p_dest_terr_id IN NUMBER,

Line 1059: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1055: --
1056: PROCEDURE Copy_Terr_Resources (
1057: p_Api_Version_Number IN NUMBER,
1058: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1059: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1061: p_source_terr_id IN NUMBER,
1062: p_dest_terr_id IN NUMBER,
1063: x_msg_count OUT NOCOPY NUMBER,

Line 1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1056: PROCEDURE Copy_Terr_Resources (
1057: p_Api_Version_Number IN NUMBER,
1058: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1059: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1061: p_source_terr_id IN NUMBER,
1062: p_dest_terr_id IN NUMBER,
1063: x_msg_count OUT NOCOPY NUMBER,
1064: x_msg_data OUT NOCOPY VARCHAR2,

Line 1087: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1083: -- IN :
1084: -- Required
1085: -- Parameter Name Data Type Default
1086: -- p_Api_Version_Number IN NUMBER,
1087: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1088: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1089: -- p_source_resource_rec TerrResource_Rec_type
1090: -- p_p_dest_resource_recd TerrResource_Rec_type
1091: --

Line 1088: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1084: -- Required
1085: -- Parameter Name Data Type Default
1086: -- p_Api_Version_Number IN NUMBER,
1087: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1088: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1089: -- p_source_resource_rec TerrResource_Rec_type
1090: -- p_p_dest_resource_recd TerrResource_Rec_type
1091: --
1092: -- Optional

Line 1108: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1104: --
1105: PROCEDURE Transfer_Resource_Territories
1106: (
1107: p_Api_Version_Number IN NUMBER,
1108: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1109: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1111: p_source_resource_rec IN TerrResource_Rec_type,
1112: p_dest_resource_rec IN TerrResource_Rec_type,

Line 1109: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1105: PROCEDURE Transfer_Resource_Territories
1106: (
1107: p_Api_Version_Number IN NUMBER,
1108: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1109: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1111: p_source_resource_rec IN TerrResource_Rec_type,
1112: p_dest_resource_rec IN TerrResource_Rec_type,
1113: p_all_terr_flag IN VARCHAR2 := 'Y',

Line 1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1106: (
1107: p_Api_Version_Number IN NUMBER,
1108: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1109: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1111: p_source_resource_rec IN TerrResource_Rec_type,
1112: p_dest_resource_rec IN TerrResource_Rec_type,
1113: p_all_terr_flag IN VARCHAR2 := 'Y',
1114: p_terr_ids_tbl IN Terr_Ids_Tbl_Type := G_MISS_TERRID_TBL,