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_TYPE_PVT dependencies on FND_API

Line 54: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,

50: -- End of Comments
51:
52: TYPE TerrType_rec_type IS RECORD
53: (
54: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
56: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

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

51:
52: TYPE TerrType_rec_type IS RECORD
53: (
54: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
56: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

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

52: TYPE TerrType_rec_type IS RECORD
53: (
54: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
56: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,

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

53: (
54: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
56: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

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

54: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
55: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
56: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

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

55: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
56: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

Line 60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,

56: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

Line 61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

57: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,

Line 62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

58: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,

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

59: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,

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

60: APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,

61: NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

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

62: ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,

63: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

64: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

65: DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

66: ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

67: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

68: ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

69: ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

70: ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

71: ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

72: ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

73: ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

74: ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR

Line 79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

75: ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
83: );

Line 80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

76: ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
83: );
84:

Line 81: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

77: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
83: );
84:
85: G_MISS_TerrType_REC TerrType_rec_type;

Line 82: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR

78: ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
83: );
84:
85: G_MISS_TerrType_REC TerrType_rec_type;
86:

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

104: -- End of Comments
105:
106: TYPE TerrType_Out_rec_type IS RECORD
107: (
108: TERR_TYPE_ID NUMBER , --:= FND_API.G_MISS_NUM,
109: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
110: );
111:
112: G_MISS_TerrType_OUT_REC TerrType_Out_rec_type;

Line 109: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR

105:
106: TYPE TerrType_Out_rec_type IS RECORD
107: (
108: TERR_TYPE_ID NUMBER , --:= FND_API.G_MISS_NUM,
109: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
110: );
111:
112: G_MISS_TerrType_OUT_REC TerrType_Out_rec_type;
113:

Line 145: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,

141: -- End of Comments
142:
143: TYPE TerrTypeUsgs_rec_type IS RECORD
144: (
145: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
146: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

Line 146: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,

142:
143: TYPE TerrTypeUsgs_rec_type IS RECORD
144: (
145: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
146: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,

Line 147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,

143: TYPE TerrTypeUsgs_rec_type IS RECORD
144: (
145: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
146: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

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

144: (
145: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
146: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
152: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

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

145: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
146: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
152: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
153: ORG_ID NUMBER -- := FND_API.G_MISS_NUM

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

146: SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
152: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
153: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
154: );

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

147: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
152: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
153: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
154: );
155:

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

148: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
152: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
153: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
154: );
155:
156: G_MISS_TerrTypeUSGS_REC TerrTypeusgs_rec_type;

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

149: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
152: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
153: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
154: );
155:
156: G_MISS_TerrTypeUSGS_REC TerrTypeusgs_rec_type;
157:

Line 181: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,

177: -- End of Comments
178:
179: TYPE TerrTypeusgs_out_rec_type IS RECORD
180: (
181: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
183: );
184:
185: G_MISS_TerrTypeUSGS_OUT_REC TerrTypeusgs_out_rec_type;

Line 182: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR

178:
179: TYPE TerrTypeusgs_out_rec_type IS RECORD
180: (
181: TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
183: );
184:
185: G_MISS_TerrTypeUSGS_OUT_REC TerrTypeusgs_out_rec_type;
186:

Line 218: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,

214: -- End of Comments
215:
216: TYPE typequaltypeusgs_rec_type IS RECORD
217: (
218: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
219: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

Line 219: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,

215:
216: TYPE typequaltypeusgs_rec_type IS RECORD
217: (
218: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
219: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,

Line 220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,

216: TYPE typequaltypeusgs_rec_type IS RECORD
217: (
218: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
219: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

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

217: (
218: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
219: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

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

218: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
219: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: ORG_ID NUMBER -- := FND_API.G_MISS_NUM

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

219: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
227: );

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

220: QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
227: );
228:

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

221: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
227: );
228:
229: G_MISS_TYPEQUALTYPEUSGS_REC typequaltypeusgs_rec_type;

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

222: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
227: );
228:
229: G_MISS_TYPEQUALTYPEUSGS_REC typequaltypeusgs_rec_type;
230:

Line 253: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,

249: -- End of Comments
250:
251: TYPE typequaltypeusgs_out_rec_type IS RECORD
252: (
253: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
254: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
255: );
256:
257: G_MISS_TYPEQUALTYPUSGS_OUT_REC typequaltypeusgs_out_rec_type;

Line 254: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR

250:
251: TYPE typequaltypeusgs_out_rec_type IS RECORD
252: (
253: TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
254: RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
255: );
256:
257: G_MISS_TYPEQUALTYPUSGS_OUT_REC typequaltypeusgs_out_rec_type;
258:

Line 288: ( TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,

284: -- Note:
285: -- End of Comments
286:
287: TYPE TerrTypequal_rec_type IS RECORD
288: ( TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
289: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
290: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

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

285: -- End of Comments
286:
287: TYPE TerrTypequal_rec_type IS RECORD
288: ( TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
289: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
290: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

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

286:
287: TYPE TerrTypequal_rec_type IS RECORD
288: ( TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
289: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
290: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,

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

287: TYPE TerrTypequal_rec_type IS RECORD
288: ( TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
289: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
290: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,

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

288: ( TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
289: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
290: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

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

289: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
290: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

Line 294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,

290: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

Line 295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,

291: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
299: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,

Line 296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

292: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
299: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
300: ORG_ID NUMBER -- := FND_API.G_MISS_NUM

Line 297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

293: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
299: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
300: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
301: );

Line 298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

294: QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
299: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
300: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
301: );
302:

Line 299: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,

295: TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
299: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
300: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
301: );
302:
303: G_MISS_TerrTypeQUAL_REC TerrTypequal_rec_type;

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

296: EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297: OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298: IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
299: QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
300: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
301: );
302:
303: G_MISS_TerrTypeQUAL_REC TerrTypequal_rec_type;
304:

Line 326: TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,

322: -- End of Comments
323:
324: TYPE TerrTypequal_out_rec_type IS RECORD
325: (
326: TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
327: return_status VARCHAR2(1) -- := FND_API.G_MISS_CHAR
328: );
329:
330: G_MISS_TerrTypeQUAL_OUT_REC TerrTypequal_out_rec_type;

Line 327: return_status VARCHAR2(1) -- := FND_API.G_MISS_CHAR

323:
324: TYPE TerrTypequal_out_rec_type IS RECORD
325: (
326: TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
327: return_status VARCHAR2(1) -- := FND_API.G_MISS_CHAR
328: );
329:
330: G_MISS_TerrTypeQUAL_OUT_REC TerrTypequal_out_rec_type;
331:

Line 348: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false

344: -- parameters :
345:
346: -- in:
347: -- p_api_version_number in number required
348: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
349: -- p_commit in varchar2 optional --default = fnd_api.g_false
350: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
351: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
352: -- p_TerrTypeusgs_tbl in TerrTypeusgs_rec_type required --default = g_miss_tersrc_rec

Line 349: -- p_commit in varchar2 optional --default = fnd_api.g_false

345:
346: -- in:
347: -- p_api_version_number in number required
348: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
349: -- p_commit in varchar2 optional --default = fnd_api.g_false
350: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
351: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
352: -- p_TerrTypeusgs_tbl in TerrTypeusgs_rec_type required --default = g_miss_tersrc_rec
353: -- p_TypequalTypeusgs_tbl in TypeQualTypeUsgs_tbl_type required --default = g_miss_tersrc_tbl,

Line 376: p_init_msg_list in varchar2 := fnd_api.g_false,

372: -- end of comments
373:
374: procedure create_terrtype
375: ( p_api_version_number in number,
376: p_init_msg_list in varchar2 := fnd_api.g_false,
377: p_commit in varchar2 := fnd_api.g_false,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
380: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,

Line 377: p_commit in varchar2 := fnd_api.g_false,

373:
374: procedure create_terrtype
375: ( p_api_version_number in number,
376: p_init_msg_list in varchar2 := fnd_api.g_false,
377: p_commit in varchar2 := fnd_api.g_false,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
380: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
381: p_TerrTypeusgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,

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

374: procedure create_terrtype
375: ( p_api_version_number in number,
376: p_init_msg_list in varchar2 := fnd_api.g_false,
377: p_commit in varchar2 := fnd_api.g_false,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
380: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
381: p_TerrTypeusgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,
382: p_TypeQualTypeUsgs_tbl in TypeQualTypeUsgs_tbl_type := g_miss_typeQualTypeUsgs_tbl,

Line 404: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false

400: -- parameters :
401:
402: -- in:
403: -- p_api_version_number in number required
404: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
405: -- p_commit in varchar2 optional --default = fnd_api.g_false
406: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
407: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
408: -- p_TerrTypesrc_tbl in TerrTypesrc_rec_type required --default = g_miss_tersrc_rec

Line 405: -- p_commit in varchar2 optional --default = fnd_api.g_false

401:
402: -- in:
403: -- p_api_version_number in number required
404: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
405: -- p_commit in varchar2 optional --default = fnd_api.g_false
406: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
407: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
408: -- p_TerrTypesrc_tbl in TerrTypesrc_rec_type required --default = g_miss_tersrc_rec
409: -- p_TerrTypeSrcType_tbl in TerrTypeSrcType_tbl_type required --default = g_miss_tersrc_tbl,

Line 430: p_init_msg_list in varchar2 := fnd_api.g_false,

426: -- end of comments
427:
428: procedure Update_Terrtype
429: ( p_api_version_number in number,
430: p_init_msg_list in varchar2 := fnd_api.g_false,
431: p_commit in varchar2 := fnd_api.g_false,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
434: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,

Line 431: p_commit in varchar2 := fnd_api.g_false,

427:
428: procedure Update_Terrtype
429: ( p_api_version_number in number,
430: p_init_msg_list in varchar2 := fnd_api.g_false,
431: p_commit in varchar2 := fnd_api.g_false,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
434: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
435: p_TerrTypeUsgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,

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

428: procedure Update_Terrtype
429: ( p_api_version_number in number,
430: p_init_msg_list in varchar2 := fnd_api.g_false,
431: p_commit in varchar2 := fnd_api.g_false,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
434: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
435: p_TerrTypeUsgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,
436: p_TypeQualTypeUsgs_tbl in TypeQualTypeUsgs_tbl_type := g_miss_TypeQualTypeUsgs_tbl,

Line 457: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false

453: -- parameters :
454: --
455: -- in:
456: -- p_api_version_number in number required
457: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
458: -- p_commit in varchar2 optional --default = fnd_api.g_false
459: -- p_TerrType_id in number
460: --
461: -- out:

Line 458: -- p_commit in varchar2 optional --default = fnd_api.g_false

454: --
455: -- in:
456: -- p_api_version_number in number required
457: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
458: -- p_commit in varchar2 optional --default = fnd_api.g_false
459: -- p_TerrType_id in number
460: --
461: -- out:
462: -- p_return_status OUT NOCOPY varchar2(1)

Line 478: p_init_msg_list in varchar2 := fnd_api.g_false,

474: -- end of comments
475:
476: procedure Delete_TerrType
477: ( p_api_version_number in number,
478: p_init_msg_list in varchar2 := fnd_api.g_false,
479: p_commit in varchar2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
481: p_TerrType_id in number,
482: x_return_status OUT NOCOPY varchar2,

Line 479: p_commit in varchar2 := fnd_api.g_false,

475:
476: procedure Delete_TerrType
477: ( p_api_version_number in number,
478: p_init_msg_list in varchar2 := fnd_api.g_false,
479: p_commit in varchar2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
481: p_TerrType_id in number,
482: x_return_status OUT NOCOPY varchar2,
483: x_msg_count OUT NOCOPY number,

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

476: procedure Delete_TerrType
477: ( p_api_version_number in number,
478: p_init_msg_list in varchar2 := fnd_api.g_false,
479: p_commit in varchar2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
481: p_TerrType_id in number,
482: x_return_status OUT NOCOPY varchar2,
483: x_msg_count OUT NOCOPY number,
484: X_msg_data OUT NOCOPY varchar2

Line 501: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false

497: -- parameters :
498: --
499: -- in:
500: -- p_api_version_number in number required
501: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
502: -- p_commit in varchar2 optional --default = fnd_api.g_false
503: -- p_TerrType_id in number
504: --
505: -- out:

Line 502: -- p_commit in varchar2 optional --default = fnd_api.g_false

498: --
499: -- in:
500: -- p_api_version_number in number required
501: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
502: -- p_commit in varchar2 optional --default = fnd_api.g_false
503: -- p_TerrType_id in number
504: --
505: -- out:
506: -- p_return_status OUT NOCOPY varchar2(1)

Line 522: p_init_msg_list in varchar2 := fnd_api.g_false,

518: -- end of comments
519:
520: procedure Deactivate_TerrType
521: ( p_api_version_number in number,
522: p_init_msg_list in varchar2 := fnd_api.g_false,
523: p_commit in varchar2 := fnd_api.g_false,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: p_TerrType_id in number,
526: x_return_status OUT NOCOPY varchar2,

Line 523: p_commit in varchar2 := fnd_api.g_false,

519:
520: procedure Deactivate_TerrType
521: ( p_api_version_number in number,
522: p_init_msg_list in varchar2 := fnd_api.g_false,
523: p_commit in varchar2 := fnd_api.g_false,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: p_TerrType_id in number,
526: x_return_status OUT NOCOPY varchar2,
527: x_msg_count OUT NOCOPY number,

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

520: procedure Deactivate_TerrType
521: ( p_api_version_number in number,
522: p_init_msg_list in varchar2 := fnd_api.g_false,
523: p_commit in varchar2 := fnd_api.g_false,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: p_TerrType_id in number,
526: x_return_status OUT NOCOPY varchar2,
527: x_msg_count OUT NOCOPY number,
528: x_msg_data OUT NOCOPY varchar2

Line 544: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false

540: -- parameters :
541: --
542: -- in:
543: -- p_api_version_number in number required
544: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
545: -- p_commit in varchar2 optional --default = fnd_api.g_false
546: -- p_TerrType_id in number
547: -- p_TerrType_Name in varchar2
548: -- p_TerrType_Description in varchar2

Line 545: -- p_commit in varchar2 optional --default = fnd_api.g_false

541: --
542: -- in:
543: -- p_api_version_number in number required
544: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
545: -- p_commit in varchar2 optional --default = fnd_api.g_false
546: -- p_TerrType_id in number
547: -- p_TerrType_Name in varchar2
548: -- p_TerrType_Description in varchar2
549: -- p_Enabled_Flag in varchar2

Line 570: p_init_msg_list in varchar2 := fnd_api.g_false,

566: -- end of comments
567:
568: procedure Copy_TerrType
569: ( p_api_version_number in number,
570: p_init_msg_list in varchar2 := fnd_api.g_false,
571: p_commit in varchar2 := fnd_api.g_false,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: p_TerrType_id in number,
574: p_TerrType_Name in varchar2,

Line 571: p_commit in varchar2 := fnd_api.g_false,

567:
568: procedure Copy_TerrType
569: ( p_api_version_number in number,
570: p_init_msg_list in varchar2 := fnd_api.g_false,
571: p_commit in varchar2 := fnd_api.g_false,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: p_TerrType_id in number,
574: p_TerrType_Name in varchar2,
575: p_TerrType_Description in varchar2,

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

568: procedure Copy_TerrType
569: ( p_api_version_number in number,
570: p_init_msg_list in varchar2 := fnd_api.g_false,
571: p_commit in varchar2 := fnd_api.g_false,
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: p_TerrType_id in number,
574: p_TerrType_Name in varchar2,
575: p_TerrType_Description in varchar2,
576: p_Enabled_Flag in varchar2,

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

604: -- P_TypeQualTypeUsgs_Tbl TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl
605: --
606: -- Optional
607: -- Parameter Name Data Type Default
608: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
609: -- P_Commit VARCHAR2 := FND_API.G_FALSE
610: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
611: --
612: -- OUT NOCOPY :

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

605: --
606: -- Optional
607: -- Parameter Name Data Type Default
608: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
609: -- P_Commit VARCHAR2 := FND_API.G_FALSE
610: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
611: --
612: -- OUT NOCOPY :
613: -- Parameter Name Data Type

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

606: -- Optional
607: -- Parameter Name Data Type Default
608: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
609: -- P_Commit VARCHAR2 := FND_API.G_FALSE
610: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
611: --
612: -- OUT NOCOPY :
613: -- Parameter Name Data Type
614: -- X_Return_Status VARCHAR2(1)

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

625: -- End of Comments
626: --
627: PROCEDURE Create_TerrType_Header
628: (P_Api_Version_Number IN NUMBER,
629: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
630: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632: P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
633: P_TerrTypeUsgs_Tbl IN TerrTypeusgs_Tbl_Type := G_MISS_TerrTypeusgs_Tbl,

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

626: --
627: PROCEDURE Create_TerrType_Header
628: (P_Api_Version_Number IN NUMBER,
629: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
630: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632: P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
633: P_TerrTypeUsgs_Tbl IN TerrTypeusgs_Tbl_Type := G_MISS_TerrTypeusgs_Tbl,
634: P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,

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

627: PROCEDURE Create_TerrType_Header
628: (P_Api_Version_Number IN NUMBER,
629: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
630: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632: P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
633: P_TerrTypeUsgs_Tbl IN TerrTypeusgs_Tbl_Type := G_MISS_TerrTypeusgs_Tbl,
634: P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
635: X_Return_Status OUT NOCOPY VARCHAR2,

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

667: -- End of Comments
668: --
669: PROCEDURE Create_TerrType_Record
670: ( P_Api_Version_Number IN NUMBER,
671: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
672: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
673: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
674: P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
675: X_Return_Status OUT NOCOPY VARCHAR2,

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

668: --
669: PROCEDURE Create_TerrType_Record
670: ( P_Api_Version_Number IN NUMBER,
671: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
672: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
673: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
674: P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
675: X_Return_Status OUT NOCOPY VARCHAR2,
676: X_Msg_Count OUT NOCOPY NUMBER,

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

669: PROCEDURE Create_TerrType_Record
670: ( P_Api_Version_Number IN NUMBER,
671: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
672: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
673: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
674: P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
675: X_Return_Status OUT NOCOPY VARCHAR2,
676: X_Msg_Count OUT NOCOPY NUMBER,
677: X_Msg_Data OUT NOCOPY VARCHAR2,

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

707: -- End of Comments
708: --
709: PROCEDURE Create_TerrType_Usages
710: ( P_Api_Version_Number IN NUMBER,
711: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
712: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
713: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714: P_TerrType_Id IN NUMBER,
715: P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TerrTypeUsgs_Tbl,

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

708: --
709: PROCEDURE Create_TerrType_Usages
710: ( P_Api_Version_Number IN NUMBER,
711: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
712: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
713: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714: P_TerrType_Id IN NUMBER,
715: P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TerrTypeUsgs_Tbl,
716: X_Return_Status OUT NOCOPY VARCHAR2,

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

709: PROCEDURE Create_TerrType_Usages
710: ( P_Api_Version_Number IN NUMBER,
711: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
712: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
713: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714: P_TerrType_Id IN NUMBER,
715: P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TerrTypeUsgs_Tbl,
716: X_Return_Status OUT NOCOPY VARCHAR2,
717: X_Msg_Count OUT NOCOPY NUMBER,

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

747: -- End of Comments
748: --
749: PROCEDURE Create_TerrTypeQualType_Usage
750: (P_Api_Version_Number IN NUMBER,
751: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
752: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
753: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
754: P_TerrType_Id IN NUMBER,
755: P_TerrTypeUsg_Id IN NUMBER,

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

748: --
749: PROCEDURE Create_TerrTypeQualType_Usage
750: (P_Api_Version_Number IN NUMBER,
751: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
752: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
753: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
754: P_TerrType_Id IN NUMBER,
755: P_TerrTypeUsg_Id IN NUMBER,
756: P_TypeQualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_Miss_TypeQualTypeUsgs_Rec,

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

749: PROCEDURE Create_TerrTypeQualType_Usage
750: (P_Api_Version_Number IN NUMBER,
751: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
752: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
753: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
754: P_TerrType_Id IN NUMBER,
755: P_TerrTypeUsg_Id IN NUMBER,
756: P_TypeQualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_Miss_TypeQualTypeUsgs_Rec,
757: X_Return_Status OUT NOCOPY VARCHAR2,

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

790: -- End of Comments
791: --
792: PROCEDURE Create_TerrTypeQualType_Usage
793: (P_Api_Version_Number IN NUMBER,
794: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
795: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
796: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
797: P_TerrType_Id IN NUMBER,
798: P_TerrTypeUsg_Id IN NUMBER,

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

791: --
792: PROCEDURE Create_TerrTypeQualType_Usage
793: (P_Api_Version_Number IN NUMBER,
794: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
795: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
796: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
797: P_TerrType_Id IN NUMBER,
798: P_TerrTypeUsg_Id IN NUMBER,
799: P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,

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

792: PROCEDURE Create_TerrTypeQualType_Usage
793: (P_Api_Version_Number IN NUMBER,
794: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
795: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
796: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
797: P_TerrType_Id IN NUMBER,
798: P_TerrTypeUsg_Id IN NUMBER,
799: P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
800: X_Return_Status OUT NOCOPY VARCHAR2,

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

831: -- End of Comments
832: --
833: PROCEDURE Create_TerrType_Qualifier
834: (P_Api_Version_Number IN NUMBER,
835: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
836: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838: P_TerrType_Id IN NUMBER,
839: P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,

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

832: --
833: PROCEDURE Create_TerrType_Qualifier
834: (P_Api_Version_Number IN NUMBER,
835: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
836: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838: P_TerrType_Id IN NUMBER,
839: P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,
840: X_Return_Status OUT NOCOPY VARCHAR2,

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

833: PROCEDURE Create_TerrType_Qualifier
834: (P_Api_Version_Number IN NUMBER,
835: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
836: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838: P_TerrType_Id IN NUMBER,
839: P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,
840: X_Return_Status OUT NOCOPY VARCHAR2,
841: X_Msg_Count OUT NOCOPY NUMBER,

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

873: -- End of Comments
874: --
875: PROCEDURE Create_TerrType_Qualifier
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: P_TerrType_Id IN NUMBER,
881: P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,

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

874: --
875: PROCEDURE Create_TerrType_Qualifier
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: P_TerrType_Id IN NUMBER,
881: P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,
882: X_Return_Status OUT NOCOPY VARCHAR2,

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

875: PROCEDURE Create_TerrType_Qualifier
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: P_TerrType_Id IN NUMBER,
881: P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,
882: X_Return_Status OUT NOCOPY VARCHAR2,
883: X_Msg_Count OUT NOCOPY NUMBER,

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

908: -- End of Comments
909: --
910: PROCEDURE Update_TerrType_Record
911: (P_Api_Version_Number IN NUMBER,
912: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
913: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
914: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
915: P_TerrType_Rec IN TerrType_Rec_Type := G_MISS_TERRTYPE_REC,
916: X_Return_Status OUT NOCOPY VARCHAR2,

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

909: --
910: PROCEDURE Update_TerrType_Record
911: (P_Api_Version_Number IN NUMBER,
912: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
913: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
914: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
915: P_TerrType_Rec IN TerrType_Rec_Type := G_MISS_TERRTYPE_REC,
916: X_Return_Status OUT NOCOPY VARCHAR2,
917: X_Msg_Count OUT NOCOPY NUMBER,

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

910: PROCEDURE Update_TerrType_Record
911: (P_Api_Version_Number IN NUMBER,
912: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
913: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
914: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
915: P_TerrType_Rec IN TerrType_Rec_Type := G_MISS_TERRTYPE_REC,
916: X_Return_Status OUT NOCOPY VARCHAR2,
917: X_Msg_Count OUT NOCOPY NUMBER,
918: X_Msg_Data OUT NOCOPY VARCHAR2,

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

943: -- End of Comments
944: --
945: PROCEDURE Update_TerrType_Usages
946: (P_Api_Version_Number IN NUMBER,
947: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
948: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
949: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
950: P_TerrTypeUsgs_Rec IN TerrTypeUsgs_Rec_Type := G_MISS_TERRTYPEUSGS_REC,
951: X_Return_Status OUT NOCOPY VARCHAR2,

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

944: --
945: PROCEDURE Update_TerrType_Usages
946: (P_Api_Version_Number IN NUMBER,
947: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
948: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
949: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
950: P_TerrTypeUsgs_Rec IN TerrTypeUsgs_Rec_Type := G_MISS_TERRTYPEUSGS_REC,
951: X_Return_Status OUT NOCOPY VARCHAR2,
952: X_Msg_Count OUT NOCOPY NUMBER,

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

945: PROCEDURE Update_TerrType_Usages
946: (P_Api_Version_Number IN NUMBER,
947: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
948: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
949: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
950: P_TerrTypeUsgs_Rec IN TerrTypeUsgs_Rec_Type := G_MISS_TERRTYPEUSGS_REC,
951: X_Return_Status OUT NOCOPY VARCHAR2,
952: X_Msg_Count OUT NOCOPY NUMBER,
953: X_Msg_Data OUT NOCOPY VARCHAR2,

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

980: -- End of Comments
981: --
982: PROCEDURE Update_TerrType_Usages
983: (P_Api_Version_Number IN NUMBER,
984: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
985: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TERRTYPEUSGS_TBL,
988: X_Return_Status OUT NOCOPY VARCHAR2,

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

981: --
982: PROCEDURE Update_TerrType_Usages
983: (P_Api_Version_Number IN NUMBER,
984: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
985: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TERRTYPEUSGS_TBL,
988: X_Return_Status OUT NOCOPY VARCHAR2,
989: X_Msg_Count OUT NOCOPY NUMBER,

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

982: PROCEDURE Update_TerrType_Usages
983: (P_Api_Version_Number IN NUMBER,
984: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
985: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TERRTYPEUSGS_TBL,
988: X_Return_Status OUT NOCOPY VARCHAR2,
989: X_Msg_Count OUT NOCOPY NUMBER,
990: X_Msg_Data OUT NOCOPY VARCHAR2,

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

1012: -- End of Comments
1013: --
1014: PROCEDURE Update_TerrTypeQualType_Usage
1015: (P_Api_Version_Number IN NUMBER,
1016: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1017: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1018: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1019: P_TypeQualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_Miss_TypeQualTypeUsgs_Rec,
1020: X_Return_Status OUT NOCOPY VARCHAR2,

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

1013: --
1014: PROCEDURE Update_TerrTypeQualType_Usage
1015: (P_Api_Version_Number IN NUMBER,
1016: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1017: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1018: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1019: P_TypeQualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_Miss_TypeQualTypeUsgs_Rec,
1020: X_Return_Status OUT NOCOPY VARCHAR2,
1021: X_Msg_Count OUT NOCOPY NUMBER,

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

1014: PROCEDURE Update_TerrTypeQualType_Usage
1015: (P_Api_Version_Number IN NUMBER,
1016: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1017: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1018: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1019: P_TypeQualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_Miss_TypeQualTypeUsgs_Rec,
1020: X_Return_Status OUT NOCOPY VARCHAR2,
1021: X_Msg_Count OUT NOCOPY NUMBER,
1022: X_Msg_Data OUT NOCOPY VARCHAR2,

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

1044: -- End of Comments
1045: --
1046: PROCEDURE Update_TerrTypeQualType_Usage
1047: (P_Api_Version_Number IN NUMBER,
1048: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1049: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1051: P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
1052: X_Return_Status OUT NOCOPY VARCHAR2,

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

1045: --
1046: PROCEDURE Update_TerrTypeQualType_Usage
1047: (P_Api_Version_Number IN NUMBER,
1048: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1049: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1051: P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
1052: X_Return_Status OUT NOCOPY VARCHAR2,
1053: X_Msg_Count OUT NOCOPY NUMBER,

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

1046: PROCEDURE Update_TerrTypeQualType_Usage
1047: (P_Api_Version_Number IN NUMBER,
1048: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1049: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1051: P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
1052: X_Return_Status OUT NOCOPY VARCHAR2,
1053: X_Msg_Count OUT NOCOPY NUMBER,
1054: X_Msg_Data OUT NOCOPY VARCHAR2,

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

1077: -- End of Comments
1078: --
1079: PROCEDURE Update_TerrType_Qualifier
1080: (P_Api_Version_Number IN NUMBER,
1081: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1082: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,
1085: X_Return_Status OUT NOCOPY VARCHAR2,

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

1078: --
1079: PROCEDURE Update_TerrType_Qualifier
1080: (P_Api_Version_Number IN NUMBER,
1081: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1082: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,
1085: X_Return_Status OUT NOCOPY VARCHAR2,
1086: X_Msg_Count OUT NOCOPY NUMBER,

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

1079: PROCEDURE Update_TerrType_Qualifier
1080: (P_Api_Version_Number IN NUMBER,
1081: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1082: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,
1085: X_Return_Status OUT NOCOPY VARCHAR2,
1086: X_Msg_Count OUT NOCOPY NUMBER,
1087: X_Msg_Data OUT NOCOPY VARCHAR2,

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

1110: -- End of Comments
1111: --
1112: PROCEDURE Update_TerrType_Qualifier
1113: (P_Api_Version_Number IN NUMBER,
1114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1117: P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,
1118: X_Return_Status OUT NOCOPY VARCHAR2,

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

1111: --
1112: PROCEDURE Update_TerrType_Qualifier
1113: (P_Api_Version_Number IN NUMBER,
1114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1117: P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,
1118: X_Return_Status OUT NOCOPY VARCHAR2,
1119: X_Msg_Count OUT NOCOPY NUMBER,

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

1112: PROCEDURE Update_TerrType_Qualifier
1113: (P_Api_Version_Number IN NUMBER,
1114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1117: P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,
1118: X_Return_Status OUT NOCOPY VARCHAR2,
1119: X_Msg_Count OUT NOCOPY NUMBER,
1120: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 1135: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1131: -- IN
1132: -- Required:
1133: -- Parameter Name Data Type Default
1134: -- P_Api_Version_Number NUMBER,
1135: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1136: -- P_Commit VARCHAR2
1137: -- P_TerrTypeQual_Id NUMBER
1138: --
1139: -- Optional:

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

1146: -- End of Comments
1147: --
1148: PROCEDURE Delete_TerrType_Qualifier
1149: (P_Api_Version_Number IN NUMBER,
1150: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1151: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1152: P_TerrTypeQual_Id IN NUMBER,
1153: X_Return_Status OUT NOCOPY VARCHAR2,
1154: X_Msg_Count OUT NOCOPY VARCHAR2,

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

1147: --
1148: PROCEDURE Delete_TerrType_Qualifier
1149: (P_Api_Version_Number IN NUMBER,
1150: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1151: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1152: P_TerrTypeQual_Id IN NUMBER,
1153: X_Return_Status OUT NOCOPY VARCHAR2,
1154: X_Msg_Count OUT NOCOPY VARCHAR2,
1155: X_Msg_Data OUT NOCOPY VARCHAR2);

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

1165: -- IN
1166: -- Required:
1167: -- Parameter Name Data Type Default
1168: -- P_Api_Version_Number NUMBER,
1169: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1170: -- P_Commit VARCHAR2 := FND_API.G_FALSE
1171: -- P_Terr_Qual_Type_Usg_Id NUMBER
1172: --
1173: -- Optional:

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

1166: -- Required:
1167: -- Parameter Name Data Type Default
1168: -- P_Api_Version_Number NUMBER,
1169: -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1170: -- P_Commit VARCHAR2 := FND_API.G_FALSE
1171: -- P_Terr_Qual_Type_Usg_Id NUMBER
1172: --
1173: -- Optional:
1174: -- OUT:

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

1180: -- End of Comments
1181: --
1182: PROCEDURE Delete_TerrTypeQualType_Usage
1183: (P_Api_Version_Number IN NUMBER,
1184: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1185: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1186: P_TerrTypeQualType_Usg_Id IN NUMBER,
1187: X_Return_Status OUT NOCOPY VARCHAR2,
1188: X_Msg_Count OUT NOCOPY VARCHAR2,

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

1181: --
1182: PROCEDURE Delete_TerrTypeQualType_Usage
1183: (P_Api_Version_Number IN NUMBER,
1184: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1185: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1186: P_TerrTypeQualType_Usg_Id IN NUMBER,
1187: X_Return_Status OUT NOCOPY VARCHAR2,
1188: X_Msg_Count OUT NOCOPY VARCHAR2,
1189: X_Msg_Data OUT NOCOPY VARCHAR2);

Line 1203: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1199: -- IN
1200: -- Required:
1201: -- Parameter Name Data Type Default
1202: -- P_Api_Version_Number NUMBER,
1203: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1204: -- P_Commit VARCHAR2
1205: -- P_TerrTypeUsg_Id NUMBER
1206: --
1207: -- Optional:

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

1214: -- End of Comments
1215: --
1216: PROCEDURE Delete_TerrType_Usages
1217: (P_Api_Version_Number IN NUMBER,
1218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1219: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1220: P_TerrTypeUsg_Id IN NUMBER,
1221: X_Return_Status OUT NOCOPY VARCHAR2,
1222: X_Msg_Count OUT NOCOPY VARCHAR2,

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

1215: --
1216: PROCEDURE Delete_TerrType_Usages
1217: (P_Api_Version_Number IN NUMBER,
1218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1219: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1220: P_TerrTypeUsg_Id IN NUMBER,
1221: X_Return_Status OUT NOCOPY VARCHAR2,
1222: X_Msg_Count OUT NOCOPY VARCHAR2,
1223: X_Msg_Data OUT NOCOPY VARCHAR2);

Line 1237: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1233: -- IN
1234: -- Required:
1235: -- Parameter Name Data Type Default
1236: -- P_Api_Version_Number NUMBER,
1237: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1238: -- P_Commit VARCHAR2
1239: -- P_TerrType_Id NUMBER
1240: --
1241: -- Optional:

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

1248: -- End of Comments
1249: --
1250: PROCEDURE Delete_TerrType_Record
1251: (P_Api_Version_Number IN NUMBER,
1252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1254: P_TerrType_Id IN NUMBER,
1255: X_Return_Status OUT NOCOPY VARCHAR2,
1256: X_Msg_Count OUT NOCOPY VARCHAR2,

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

1249: --
1250: PROCEDURE Delete_TerrType_Record
1251: (P_Api_Version_Number IN NUMBER,
1252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1254: P_TerrType_Id IN NUMBER,
1255: X_Return_Status OUT NOCOPY VARCHAR2,
1256: X_Msg_Count OUT NOCOPY VARCHAR2,
1257: X_Msg_Data OUT NOCOPY VARCHAR2);

Line 1263: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1259: --
1260: -- Validate the Territory Type RECORD
1261: -- Validate Territory Type Name and other not null columns
1262: PROCEDURE Validate_TerrType_Record
1263: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1264: p_Terr_Type_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
1265: x_Return_Status OUT NOCOPY VARCHAR2,
1266: x_msg_count OUT NOCOPY NUMBER,
1267: x_msg_data OUT NOCOPY VARCHAR2 );

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

1272: --
1273: PROCEDURE Validate_Qualifier
1274: (P_TerrTypequal_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypequal_Rec,
1275: p_Terr_Type_Id IN NUMBER,
1276: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1277: x_Return_Status OUT NOCOPY VARCHAR2,
1278: x_msg_count OUT NOCOPY NUMBER,
1279: x_msg_data OUT NOCOPY VARCHAR2 );
1280:

Line 1290: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1286: -- Make sure the Territory Type Id is valid
1287: -- Make sure the territory Type usage Id is Valid
1288: ---------------------------------------------------------------------
1289: PROCEDURE Validate_TerrType_Usage
1290: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1291: x_Return_Status OUT NOCOPY VARCHAR2,
1292: x_msg_count OUT NOCOPY NUMBER,
1293: x_msg_data OUT NOCOPY VARCHAR2,
1294: p_TerrTypeusgs_Rec IN TerrTypeusgs_Rec_Type := G_MISS_TerrTypeusgs_Rec,

Line 1306: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1302: -- Make sure the Territory Id is valid
1303: -- Make sure the QUAL_TYPE_USG_ID is valid
1304: ---------------------------------------------------------------------
1305: PROCEDURE Validate_Type_Qtype_Usage
1306: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1307: x_Return_Status OUT NOCOPY VARCHAR2,
1308: x_msg_count OUT NOCOPY NUMBER,
1309: x_msg_data OUT NOCOPY VARCHAR2,
1310: p_Type_QualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_MISS_TYPEQUALTYPEUSGS_REC,

Line 1317: (P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1313: --
1314: -- Checks whether a Terr Type is used by any territories
1315: --
1316: PROCEDURE Is_TerrType_Deletable
1317: (P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1318: P_TerrType_Id IN NUMBER,
1319: X_Return_Status OUT NOCOPY VARCHAR2,
1320: X_Msg_Count OUT NOCOPY VARCHAR2,
1321: X_Msg_Data OUT NOCOPY VARCHAR2 );