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.

[Home] [Help]

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: );

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: );
98:

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: );
98:
99: TYPE TerrResource_rec_type_wflex IS RECORD

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

97: );
98:
99: TYPE TerrResource_rec_type_wflex IS RECORD
100: (
101: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
102: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
103: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

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

98:
99: TYPE TerrResource_rec_type_wflex IS RECORD
100: (
101: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
102: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
103: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

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

99: TYPE TerrResource_rec_type_wflex IS RECORD
100: (
101: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
102: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
103: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,

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

100: (
101: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
102: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
103: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,

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

101: TERR_RSC_ID NUMBER , -- := FND_API.G_MISS_NUM,
102: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
103: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

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

102: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
103: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

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

103: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

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

104: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,

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

105: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

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

106: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
114: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE

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

107: TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
114: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
115: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,

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

108: RESOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
114: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
115: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
116: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,

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

109: GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
114: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
115: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
116: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
117: PERSON_ID NUMBER,

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

110: RESOURCE_TYPE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
114: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
115: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
116: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
117: PERSON_ID NUMBER,
118: ATTRIBUTE_CATEGORY VARCHAR2(30),

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

111: ROLE VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
114: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
115: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
116: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
117: PERSON_ID NUMBER,
118: ATTRIBUTE_CATEGORY VARCHAR2(30),
119: ATTRIBUTE1 VARCHAR2(150),

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

112: PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
113: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
114: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE
115: FULL_ACCESS_FLAG VARCHAR2(01) := 'N', -- := FND_API.G_MISS_CHAR,
116: ORG_ID NUMBER, -- := FND_API.G_MISS_NUM,
117: PERSON_ID NUMBER,
118: ATTRIBUTE_CATEGORY VARCHAR2(30),
119: ATTRIBUTE1 VARCHAR2(150),
120: ATTRIBUTE2 VARCHAR2(150),

Line 167: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,

163:
164:
165: TYPE TerrResource_out_rec_type IS RECORD
166: (
167: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
168: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
169: );
170:
171: G_MISS_TERRRESOURCE_OUT_REC TerrResource_out_rec_type;

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

164:
165: TYPE TerrResource_out_rec_type IS RECORD
166: (
167: TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
168: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
169: );
170:
171: G_MISS_TERRRESOURCE_OUT_REC TerrResource_out_rec_type;
172:

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

192: -- CREATED_BY Part of std who columns
193: -- LAST_UPDATE_LOGIN Part of std who columns
194: -- TERR_RSC_ID Territory resource id
195: -- ACCESS_TYPE Resource acces eg: ACCOUNT/LEADS
196: -- ORG_ID NUMBER := FND_API.G_MISS_NUM
197: -- TRANS_ACCESS_CODE access type
198: -- Defaults:
199: -- Note:
200: --

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

202:
203:
204: TYPE TerrRsc_Access_Rec_type IS RECORD
205: (
206: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
207: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
208: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,

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

203:
204: TYPE TerrRsc_Access_Rec_type IS RECORD
205: (
206: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
207: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
208: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,

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

204: TYPE TerrRsc_Access_Rec_type IS RECORD
205: (
206: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
207: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
208: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,

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

205: (
206: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
207: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
208: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
213: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,

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

206: TERR_RSC_ACCESS_ID NUMBER , --:= FND_API.G_MISS_NUM,
207: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
208: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
213: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
214: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,

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

207: LAST_UPDATE_DATE DATE , --:= FND_API.G_MISS_DATE,
208: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
213: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
214: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
215: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM

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

208: LAST_UPDATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
213: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
214: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
215: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
216: TRANS_ACCESS_CODE VARCHAR2(15)

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

209: CREATION_DATE DATE , --:= FND_API.G_MISS_DATE,
210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
213: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
214: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
215: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
216: TRANS_ACCESS_CODE VARCHAR2(15)
217: );

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

210: CREATED_BY NUMBER , --:= FND_API.G_MISS_NUM,
211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
213: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
214: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
215: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
216: TRANS_ACCESS_CODE VARCHAR2(15)
217: );
218:

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

211: LAST_UPDATE_LOGIN NUMBER , --:= FND_API.G_MISS_NUM,
212: TERR_RSC_ID NUMBER , --:= FND_API.G_MISS_NUM,
213: ACCESS_TYPE VARCHAR2(30) , --:= FND_API.G_MISS_CHAR,
214: ORG_ID NUMBER , --:= FND_API.G_MISS_NUM,
215: QUALIFIER_TBL_INDEX NUMBER , --:= FND_API.G_MISS_NUM
216: TRANS_ACCESS_CODE VARCHAR2(15)
217: );
218:
219:

Line 247: TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,

243:
244:
245: TYPE TerrRsc_Access_Out_rec_type IS RECORD
246: (
247: TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
248: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
249: );
250:
251: G_MISS_TERRRSC_ACCESS_OUT_REC TerrRsc_Access_Out_rec_type;

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

244:
245: TYPE TerrRsc_Access_Out_rec_type IS RECORD
246: (
247: TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
248: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
249: );
250:
251: G_MISS_TERRRSC_ACCESS_OUT_REC TerrRsc_Access_Out_rec_type;
252:

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

276: -- Parameter Name Data Type Default
277: -- p_Api_Version_Number NUMBER
278: -- p_TerrRsc_Tbl TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL
279: -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
280: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: --
282: -- Optional
283: -- Parameter Name Data Type Default
284: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

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

280: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: --
282: -- Optional
283: -- Parameter Name Data Type Default
284: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
285: -- p_Commit VARCHAR2 := FND_API.G_FALSE
286: --
287: -- OUT :
288: -- Parameter Name Data Type

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

281: --
282: -- Optional
283: -- Parameter Name Data Type Default
284: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
285: -- p_Commit VARCHAR2 := FND_API.G_FALSE
286: --
287: -- OUT :
288: -- Parameter Name Data Type
289: -- x_Return_Status VARCHAR2(1)

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

301:
302: PROCEDURE Create_TerrResource
303: (
304: p_Api_Version_Number IN NUMBER,
305: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_Return_Status OUT NOCOPY VARCHAR2,
309: x_Msg_Count OUT NOCOPY NUMBER,

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

302: PROCEDURE Create_TerrResource
303: (
304: p_Api_Version_Number IN NUMBER,
305: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_Return_Status OUT NOCOPY VARCHAR2,
309: x_Msg_Count OUT NOCOPY NUMBER,
310: x_Msg_Data OUT NOCOPY VARCHAR2,

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

303: (
304: p_Api_Version_Number IN NUMBER,
305: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_Return_Status OUT NOCOPY VARCHAR2,
309: x_Msg_Count OUT NOCOPY NUMBER,
310: x_Msg_Data OUT NOCOPY VARCHAR2,
311: p_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,

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

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

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

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

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

318: (
319: p_Api_Version_Number IN NUMBER,
320: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
321: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: x_Return_Status OUT NOCOPY VARCHAR2,
324: x_Msg_Count OUT NOCOPY NUMBER,
325: x_Msg_Data OUT NOCOPY VARCHAR2,
326: p_TerrRsc_Tbl IN TerrResource_tbl_type_wflex := G_MISS_TERRRESOURCE_TBL_WFLEX,

Line 354: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE

350: -- p_TerrRsc_Id NUMBER
351: --
352: -- Optional
353: -- Parameter Name Data Type Default
354: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
355: -- p_Commit VARCHAR2 FND_API.G_FALSE
356: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,
357: --
358: -- OUT :

Line 355: -- p_Commit VARCHAR2 FND_API.G_FALSE

351: --
352: -- Optional
353: -- Parameter Name Data Type Default
354: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
355: -- p_Commit VARCHAR2 FND_API.G_FALSE
356: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,
357: --
358: -- OUT :
359: -- Parameter Name Data Type

Line 356: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,

352: -- Optional
353: -- Parameter Name Data Type Default
354: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
355: -- p_Commit VARCHAR2 FND_API.G_FALSE
356: -- p_validation_level NUMBER FND_API.G_VALID_LEVEL_FULL,
357: --
358: -- OUT :
359: -- Parameter Name Data Type
360: -- X_Return_Status VARCHAR2(1)

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

370:
371: PROCEDURE Delete_Terr_Resource
372: (
373: p_Api_Version_Number IN NUMBER,
374: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
375: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
377: X_Return_Status OUT NOCOPY VARCHAR2,
378: X_Msg_Count OUT NOCOPY NUMBER,

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

371: PROCEDURE Delete_Terr_Resource
372: (
373: p_Api_Version_Number IN NUMBER,
374: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
375: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
377: X_Return_Status OUT NOCOPY VARCHAR2,
378: X_Msg_Count OUT NOCOPY NUMBER,
379: X_Msg_Data OUT NOCOPY VARCHAR2,

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

372: (
373: p_Api_Version_Number IN NUMBER,
374: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
375: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
377: X_Return_Status OUT NOCOPY VARCHAR2,
378: X_Msg_Count OUT NOCOPY NUMBER,
379: X_Msg_Data OUT NOCOPY VARCHAR2,
380: p_TerrRsc_Id IN NUMBER

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

402: -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
403: --
404: -- Optional
405: -- Parameter Name Data Type Default
406: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
407: -- p_Commit VARCHAR2 := FND_API.G_FALSE
408: --
409: -- OUT :
410: -- Parameter Name Data Type

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

403: --
404: -- Optional
405: -- Parameter Name Data Type Default
406: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
407: -- p_Commit VARCHAR2 := FND_API.G_FALSE
408: --
409: -- OUT :
410: -- Parameter Name Data Type
411: -- x_Return_Status VARCHAR2(1)

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

423:
424: PROCEDURE Update_TerrResource
425: (
426: p_Api_Version_Number IN NUMBER,
427: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
428: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
429: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
430: x_Return_Status OUT NOCOPY VARCHAR2,
431: x_Msg_Count OUT NOCOPY NUMBER,

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

424: PROCEDURE Update_TerrResource
425: (
426: p_Api_Version_Number IN NUMBER,
427: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
428: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
429: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
430: x_Return_Status OUT NOCOPY VARCHAR2,
431: x_Msg_Count OUT NOCOPY NUMBER,
432: x_Msg_Data OUT NOCOPY VARCHAR2,

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

425: (
426: p_Api_Version_Number IN NUMBER,
427: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
428: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
429: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
430: x_Return_Status OUT NOCOPY VARCHAR2,
431: x_Msg_Count OUT NOCOPY NUMBER,
432: x_Msg_Data OUT NOCOPY VARCHAR2,
433: p_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,

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

467: PROCEDURE Create_Terr_Resource
468: (
469: P_TerrRsc_Rec IN TerrResource_Rec_type,
470: p_Api_Version_Number IN NUMBER,
471: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
472: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
473: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
474: x_Return_Status OUT NOCOPY VARCHAR2,
475: x_Msg_Count OUT NOCOPY NUMBER,

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

468: (
469: P_TerrRsc_Rec IN TerrResource_Rec_type,
470: p_Api_Version_Number IN NUMBER,
471: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
472: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
473: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
474: x_Return_Status OUT NOCOPY VARCHAR2,
475: x_Msg_Count OUT NOCOPY NUMBER,
476: x_Msg_Data OUT NOCOPY VARCHAR2,

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

469: P_TerrRsc_Rec IN TerrResource_Rec_type,
470: p_Api_Version_Number IN NUMBER,
471: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
472: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
473: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
474: x_Return_Status OUT NOCOPY VARCHAR2,
475: x_Msg_Count OUT NOCOPY NUMBER,
476: x_Msg_Data OUT NOCOPY VARCHAR2,
477: X_TerrRsc_Out_Rec OUT NOCOPY TerrResource_out_Rec_type

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

480: PROCEDURE Create_Terr_Resource
481: (
482: P_TerrRsc_Rec IN TerrResource_Rec_type_wflex,
483: p_Api_Version_Number IN NUMBER,
484: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
485: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
487: x_Return_Status OUT NOCOPY VARCHAR2,
488: x_Msg_Count OUT NOCOPY NUMBER,

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

481: (
482: P_TerrRsc_Rec IN TerrResource_Rec_type_wflex,
483: p_Api_Version_Number IN NUMBER,
484: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
485: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
487: x_Return_Status OUT NOCOPY VARCHAR2,
488: x_Msg_Count OUT NOCOPY NUMBER,
489: x_Msg_Data OUT NOCOPY VARCHAR2,

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

482: P_TerrRsc_Rec IN TerrResource_Rec_type_wflex,
483: p_Api_Version_Number IN NUMBER,
484: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
485: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
486: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
487: x_Return_Status OUT NOCOPY VARCHAR2,
488: x_Msg_Count OUT NOCOPY NUMBER,
489: x_Msg_Data OUT NOCOPY VARCHAR2,
490: X_TerrRsc_Out_Rec OUT NOCOPY TerrResource_out_Rec_type

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

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

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

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

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

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

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

533: PROCEDURE Create_Terr_Resource
534: (
535: P_TerrRsc_Tbl IN TerrResource_tbl_type_wflex := G_MISS_TERRRESOURCE_TBL_WFLEX,
536: p_Api_Version_Number IN NUMBER,
537: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
538: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
540: x_Return_Status OUT NOCOPY VARCHAR2,
541: x_Msg_Count OUT NOCOPY NUMBER,

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

534: (
535: P_TerrRsc_Tbl IN TerrResource_tbl_type_wflex := G_MISS_TERRRESOURCE_TBL_WFLEX,
536: p_Api_Version_Number IN NUMBER,
537: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
538: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
540: x_Return_Status OUT NOCOPY VARCHAR2,
541: x_Msg_Count OUT NOCOPY NUMBER,
542: x_Msg_Data OUT NOCOPY VARCHAR2,

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

535: P_TerrRsc_Tbl IN TerrResource_tbl_type_wflex := G_MISS_TERRRESOURCE_TBL_WFLEX,
536: p_Api_Version_Number IN NUMBER,
537: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
538: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
540: x_Return_Status OUT NOCOPY VARCHAR2,
541: x_Msg_Count OUT NOCOPY NUMBER,
542: x_Msg_Data OUT NOCOPY VARCHAR2,
543: X_TerrRsc_Out_Tbl OUT NOCOPY TerrResource_out_tbl_type

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

575: (
576: p_TerrRsc_Id NUMBER,
577: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
578: p_Api_Version_Number IN NUMBER,
579: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
580: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
581: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
582: x_Return_Status OUT NOCOPY VARCHAR2,
583: x_Msg_Count OUT NOCOPY NUMBER,

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

576: p_TerrRsc_Id NUMBER,
577: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
578: p_Api_Version_Number IN NUMBER,
579: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
580: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
581: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
582: x_Return_Status OUT NOCOPY VARCHAR2,
583: x_Msg_Count OUT NOCOPY NUMBER,
584: x_Msg_Data OUT NOCOPY VARCHAR2,

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

577: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
578: p_Api_Version_Number IN NUMBER,
579: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
580: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
581: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
582: x_Return_Status OUT NOCOPY VARCHAR2,
583: x_Msg_Count OUT NOCOPY NUMBER,
584: x_Msg_Data OUT NOCOPY VARCHAR2,
585: X_TerrRsc_Access_Out_Rec OUT NOCOPY TerrRsc_Access_out_rec_type

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

620: (
621: p_TerrRsc_Id NUMBER,
622: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
623: p_Api_Version_Number IN NUMBER,
624: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
625: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
626: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
627: x_Return_Status OUT NOCOPY VARCHAR2,
628: x_Msg_Count OUT NOCOPY NUMBER,

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

621: p_TerrRsc_Id NUMBER,
622: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
623: p_Api_Version_Number IN NUMBER,
624: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
625: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
626: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
627: x_Return_Status OUT NOCOPY VARCHAR2,
628: x_Msg_Count OUT NOCOPY NUMBER,
629: x_Msg_Data OUT NOCOPY VARCHAR2,

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

622: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
623: p_Api_Version_Number IN NUMBER,
624: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
625: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
626: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
627: x_Return_Status OUT NOCOPY VARCHAR2,
628: x_Msg_Count OUT NOCOPY NUMBER,
629: x_Msg_Data OUT NOCOPY VARCHAR2,
630: X_TerrRsc_Access_Out_Tbl OUT NOCOPY TerrRsc_Access_out_Tbl_type

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

644: -- IN
645: -- Required:
646: -- Parameter Name Data Type Default
647: -- P_Api_Version_Number IN NUMBER,
648: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
649: -- P_Commit IN VARCHAR2 := FND_API.G_FALSE
650: -- P_TerrRsc_Id IN NUMBER
651: --
652: -- Optional:

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

645: -- Required:
646: -- Parameter Name Data Type Default
647: -- P_Api_Version_Number IN NUMBER,
648: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
649: -- P_Commit IN VARCHAR2 := FND_API.G_FALSE
650: -- P_TerrRsc_Id IN NUMBER
651: --
652: -- Optional:
653: -- OUT:

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

661:
662: PROCEDURE Delete_TerrResource
663: (
664: P_Api_Version_Number IN NUMBER,
665: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
666: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
667: P_TerrRsc_Id IN NUMBER,
668: X_Return_Status OUT NOCOPY VARCHAR2,
669: X_Msg_Count OUT NOCOPY VARCHAR2,

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

662: PROCEDURE Delete_TerrResource
663: (
664: P_Api_Version_Number IN NUMBER,
665: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
666: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
667: P_TerrRsc_Id IN NUMBER,
668: X_Return_Status OUT NOCOPY VARCHAR2,
669: X_Msg_Count OUT NOCOPY VARCHAR2,
670: X_Msg_Data OUT NOCOPY VARCHAR2

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

683: -- Parameters:
684: -- IN
685: -- Parameter Name Data Type Default
686: -- P_Api_Version_Number NUMBER,
687: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
688: -- P_Commit VARCHAR2 := FND_API.G_FALSE
689: -- P_TerrRsc_Access_Id NUMBER
690: --
691: -- Optional:

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

684: -- IN
685: -- Parameter Name Data Type Default
686: -- P_Api_Version_Number NUMBER,
687: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
688: -- P_Commit VARCHAR2 := FND_API.G_FALSE
689: -- P_TerrRsc_Access_Id NUMBER
690: --
691: -- Optional:
692: --

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

701:
702: PROCEDURE Delete_TerrRsc_Access
703: (
704: P_Api_Version_Number IN NUMBER,
705: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
706: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
707: P_TerrRsc_Access_Id IN NUMBER,
708: X_Return_Status OUT NOCOPY VARCHAR2,
709: X_Msg_Count OUT NOCOPY VARCHAR2,

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

702: PROCEDURE Delete_TerrRsc_Access
703: (
704: P_Api_Version_Number IN NUMBER,
705: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
706: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
707: P_TerrRsc_Access_Id IN NUMBER,
708: X_Return_Status OUT NOCOPY VARCHAR2,
709: X_Msg_Count OUT NOCOPY VARCHAR2,
710: X_Msg_Data OUT NOCOPY VARCHAR2

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

743: PROCEDURE Update_Terr_Resource
744: (
745: P_TerrRsc_Rec IN TerrResource_Rec_type,
746: p_Api_Version_Number IN NUMBER,
747: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
748: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
749: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
750: x_Return_Status OUT NOCOPY VARCHAR2,
751: x_Msg_Count OUT NOCOPY NUMBER,

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

744: (
745: P_TerrRsc_Rec IN TerrResource_Rec_type,
746: p_Api_Version_Number IN NUMBER,
747: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
748: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
749: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
750: x_Return_Status OUT NOCOPY VARCHAR2,
751: x_Msg_Count OUT NOCOPY NUMBER,
752: x_Msg_Data OUT NOCOPY VARCHAR2,

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

745: P_TerrRsc_Rec IN TerrResource_Rec_type,
746: p_Api_Version_Number IN NUMBER,
747: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
748: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
749: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
750: x_Return_Status OUT NOCOPY VARCHAR2,
751: x_Msg_Count OUT NOCOPY NUMBER,
752: x_Msg_Data OUT NOCOPY VARCHAR2,
753: X_TerrRsc_Out_Rec OUT NOCOPY TerrResource_out_Rec_type

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

783: PROCEDURE Update_Terr_Resource
784: (
785: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
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: x_Return_Status OUT NOCOPY VARCHAR2,
791: x_Msg_Count OUT NOCOPY NUMBER,

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

784: (
785: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
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: x_Return_Status OUT NOCOPY VARCHAR2,
791: x_Msg_Count OUT NOCOPY NUMBER,
792: x_Msg_Data OUT NOCOPY VARCHAR2,

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

785: P_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
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: x_Return_Status OUT NOCOPY VARCHAR2,
791: x_Msg_Count OUT NOCOPY NUMBER,
792: x_Msg_Data OUT NOCOPY VARCHAR2,
793: X_TerrRsc_Out_Tbl OUT NOCOPY TerrResource_out_tbl_type

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

827: PROCEDURE Update_Resource_Access
828: (
829: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
830: p_Api_Version_Number IN NUMBER,
831: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
832: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: x_Return_Status OUT NOCOPY VARCHAR2,
835: x_Msg_Count OUT NOCOPY NUMBER,

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

828: (
829: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
830: p_Api_Version_Number IN NUMBER,
831: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
832: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: x_Return_Status OUT NOCOPY VARCHAR2,
835: x_Msg_Count OUT NOCOPY NUMBER,
836: x_Msg_Data OUT NOCOPY VARCHAR2,

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

829: P_TerrRsc_Access_Rec TerrRsc_Access_rec_type := G_MISS_TERRRSC_ACCESS_REC,
830: p_Api_Version_Number IN NUMBER,
831: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
832: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: x_Return_Status OUT NOCOPY VARCHAR2,
835: x_Msg_Count OUT NOCOPY NUMBER,
836: x_Msg_Data OUT NOCOPY VARCHAR2,
837: X_TerrRsc_Access_Out_Rec OUT NOCOPY TerrRsc_Access_out_rec_type

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

873: PROCEDURE Update_Resource_Access
874: (
875: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
876: p_Api_Version_Number IN NUMBER,
877: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
878: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: x_Return_Status OUT NOCOPY VARCHAR2,
881: x_Msg_Count OUT NOCOPY NUMBER,

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

874: (
875: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
876: p_Api_Version_Number IN NUMBER,
877: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
878: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: x_Return_Status OUT NOCOPY VARCHAR2,
881: x_Msg_Count OUT NOCOPY NUMBER,
882: x_Msg_Data OUT NOCOPY VARCHAR2,

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

875: P_TerrRsc_Access_Tbl TerrRsc_Access_Tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
876: p_Api_Version_Number IN NUMBER,
877: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
878: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
879: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880: x_Return_Status OUT NOCOPY VARCHAR2,
881: x_Msg_Count OUT NOCOPY NUMBER,
882: x_Msg_Data OUT NOCOPY VARCHAR2,
883: X_TerrRsc_Access_Out_Tbl OUT NOCOPY TerrRsc_Access_out_Tbl_type

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

943: -- Make sure the Territory Id is valid
944: ---------------------------------------------------------------------
945: PROCEDURE Validate_Terr_Rsc
946: (
947: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
948: x_Return_Status OUT NOCOPY VARCHAR2,
949: x_msg_count OUT NOCOPY NUMBER,
950: x_msg_data OUT NOCOPY VARCHAR2,
951: p_TerrRsc_Rec IN TerrResource_Rec_type

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

952: );
953:
954: PROCEDURE Validate_Terr_Rsc
955: (
956: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
957: x_Return_Status OUT NOCOPY VARCHAR2,
958: x_msg_count OUT NOCOPY NUMBER,
959: x_msg_data OUT NOCOPY VARCHAR2,
960: p_TerrRsc_Rec IN TerrResource_Rec_type_wflex

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

971: -- Make sure the ACCESS_TYPE is valid
972: ---------------------------------------------------------------------
973: PROCEDURE Validate_Terr_Rsc_Access
974: (
975: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
976: x_Return_Status OUT NOCOPY VARCHAR2,
977: x_msg_count OUT NOCOPY NUMBER,
978: x_msg_data OUT NOCOPY VARCHAR2,
979: p_TerrRsc_Id IN NUMBER,

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

1049: */
1050: PROCEDURE validate_terr_rsc_access_UK(
1051: p_Terr_Rsc_Id IN NUMBER,
1052: p_Access_Type IN VARCHAR2,
1053: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1054: x_Return_Status OUT NOCOPY VARCHAR2,
1055: x_msg_count OUT NOCOPY NUMBER,
1056: x_msg_data OUT NOCOPY VARCHAR2 );
1057:

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

1069: -- IN :
1070: -- Required
1071: -- Parameter Name Data Type Default
1072: -- p_Api_Version_Number IN NUMBER,
1073: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1074: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1075: -- p_source_terr_id NUMBER
1076: -- p_dest_terr_id NUMBER
1077: --

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

1070: -- Required
1071: -- Parameter Name Data Type Default
1072: -- p_Api_Version_Number IN NUMBER,
1073: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1074: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1075: -- p_source_terr_id NUMBER
1076: -- p_dest_terr_id NUMBER
1077: --
1078: -- Optional

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

1089: -- End of Comments
1090: --
1091: PROCEDURE Copy_Terr_Resources (
1092: p_Api_Version_Number IN NUMBER,
1093: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1094: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1095: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1096: p_source_terr_id IN NUMBER,
1097: p_dest_terr_id IN NUMBER,

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

1090: --
1091: PROCEDURE Copy_Terr_Resources (
1092: p_Api_Version_Number IN NUMBER,
1093: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1094: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1095: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1096: p_source_terr_id IN NUMBER,
1097: p_dest_terr_id IN NUMBER,
1098: x_msg_count OUT NOCOPY NUMBER,

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

1091: PROCEDURE Copy_Terr_Resources (
1092: p_Api_Version_Number IN NUMBER,
1093: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1094: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1095: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1096: p_source_terr_id IN NUMBER,
1097: p_dest_terr_id IN NUMBER,
1098: x_msg_count OUT NOCOPY NUMBER,
1099: x_msg_data OUT NOCOPY VARCHAR2,

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

1118: -- IN :
1119: -- Required
1120: -- Parameter Name Data Type Default
1121: -- p_Api_Version_Number IN NUMBER,
1122: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1123: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1124: -- p_source_resource_rec TerrResource_Rec_type
1125: -- p_p_dest_resource_recd TerrResource_Rec_type
1126: --

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

1119: -- Required
1120: -- Parameter Name Data Type Default
1121: -- p_Api_Version_Number IN NUMBER,
1122: -- p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1123: -- p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1124: -- p_source_resource_rec TerrResource_Rec_type
1125: -- p_p_dest_resource_recd TerrResource_Rec_type
1126: --
1127: -- Optional

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

1139: --
1140: PROCEDURE Transfer_Resource_Territories
1141: (
1142: p_Api_Version_Number IN NUMBER,
1143: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1144: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1146: p_source_resource_rec IN TerrResource_Rec_type,
1147: p_dest_resource_rec IN TerrResource_Rec_type,

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

1140: PROCEDURE Transfer_Resource_Territories
1141: (
1142: p_Api_Version_Number IN NUMBER,
1143: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1144: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1146: p_source_resource_rec IN TerrResource_Rec_type,
1147: p_dest_resource_rec IN TerrResource_Rec_type,
1148: p_all_terr_flag IN VARCHAR2 := 'Y',

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

1141: (
1142: p_Api_Version_Number IN NUMBER,
1143: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1144: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1146: p_source_resource_rec IN TerrResource_Rec_type,
1147: p_dest_resource_rec IN TerrResource_Rec_type,
1148: p_all_terr_flag IN VARCHAR2 := 'Y',
1149: p_terr_ids_tbl IN Terr_Ids_Tbl_Type := G_MISS_TERRID_TBL,