APPS.JTF_TERRITORY_TYPE_PUB dependencies on FND_API

Line 50: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

46: -- End of Comments
47:
48: TYPE TerrType_rec_type IS RECORD
49: (
50: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
52: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 51: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

47:
48: TYPE TerrType_rec_type IS RECORD
49: (
50: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
52: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 52: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

48: TYPE TerrType_rec_type IS RECORD
49: (
50: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
52: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
56: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 53: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

Line 54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

51: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
52: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
56: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,

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

52: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
56: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,

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

53: CREATION_DATE DATE := FND_API.G_MISS_DATE,
54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
56: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
61: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

54: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
56: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
61: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ORG_ID NUMBER := FND_API.G_MISS_NUM,

Line 59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,

55: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
56: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
61: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ORG_ID NUMBER := FND_API.G_MISS_NUM,
63: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,

56: APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
61: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ORG_ID NUMBER := FND_API.G_MISS_NUM,
63: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

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

Line 62: ORG_ID NUMBER := FND_API.G_MISS_NUM,

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

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

59: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
61: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ORG_ID NUMBER := FND_API.G_MISS_NUM,
63: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

60: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
61: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ORG_ID NUMBER := FND_API.G_MISS_NUM,
63: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

61: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
62: ORG_ID NUMBER := FND_API.G_MISS_NUM,
63: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

62: ORG_ID NUMBER := FND_API.G_MISS_NUM,
63: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

63: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

64: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

65: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

66: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

67: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

68: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

69: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

70: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

71: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: );

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

72: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: );
80:

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

73: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: );
80:
81: G_MISS_TerrType_REC TerrType_rec_type;

Line 78: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

74: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: );
80:
81: G_MISS_TerrType_REC TerrType_rec_type;
82:

Line 104: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

100: -- End of Comments
101:
102: TYPE TerrType_Out_rec_type IS RECORD
103: (
104: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
105: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
106: );
107:
108: G_MISS_TerrType_OUT_REC TerrType_Out_rec_type;

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

101:
102: TYPE TerrType_Out_rec_type IS RECORD
103: (
104: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
105: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
106: );
107:
108: G_MISS_TerrType_OUT_REC TerrType_Out_rec_type;
109:

Line 140: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,

136: -- End of Comments
137:
138: TYPE TerrTypeUsgs_rec_type IS RECORD
139: (
140: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
141: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 141: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,

137:
138: TYPE TerrTypeUsgs_rec_type IS RECORD
139: (
140: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
141: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

138: TYPE TerrTypeUsgs_rec_type IS RECORD
139: (
140: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
141: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,
146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

139: (
140: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
141: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,
146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
147: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

140: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
141: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,
146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
147: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
148: ORG_ID NUMBER := FND_API.G_MISS_NUM

Line 145: CREATION_DATE DATE := FND_API.G_MISS_DATE,

141: SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,
146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
147: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
148: ORG_ID NUMBER := FND_API.G_MISS_NUM
149: );

Line 146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

142: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,
146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
147: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
148: ORG_ID NUMBER := FND_API.G_MISS_NUM
149: );
150:

Line 147: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

143: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,
146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
147: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
148: ORG_ID NUMBER := FND_API.G_MISS_NUM
149: );
150:
151: G_MISS_TerrTypeUSGS_REC TerrTypeusgs_rec_type;

Line 148: ORG_ID NUMBER := FND_API.G_MISS_NUM

144: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
145: CREATION_DATE DATE := FND_API.G_MISS_DATE,
146: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
147: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
148: ORG_ID NUMBER := FND_API.G_MISS_NUM
149: );
150:
151: G_MISS_TerrTypeUSGS_REC TerrTypeusgs_rec_type;
152:

Line 176: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,

172: -- End of Comments
173:
174: TYPE TerrTypeusgs_out_rec_type IS RECORD
175: (
176: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
177: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
178: );
179:
180: G_MISS_TerrTypeUSGS_OUT_REC TerrTypeusgs_out_rec_type;

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

173:
174: TYPE TerrTypeusgs_out_rec_type IS RECORD
175: (
176: TERR_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
177: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
178: );
179:
180: G_MISS_TerrTypeUSGS_OUT_REC TerrTypeusgs_out_rec_type;
181:

Line 212: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,

208: -- End of Comments
209:
210: TYPE typequaltypeusgs_rec_type IS RECORD
211: (
212: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
213: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 213: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

209:
210: TYPE typequaltypeusgs_rec_type IS RECORD
211: (
212: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
213: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,

210: TYPE typequaltypeusgs_rec_type IS RECORD
211: (
212: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
213: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,
218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

211: (
212: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
213: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,
218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
219: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

212: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
213: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,
218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
219: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
220: ORG_ID NUMBER := FND_API.G_MISS_NUM

Line 217: CREATION_DATE DATE := FND_API.G_MISS_DATE,

213: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,
218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
219: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
220: ORG_ID NUMBER := FND_API.G_MISS_NUM
221: );

Line 218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

214: QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,
218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
219: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
220: ORG_ID NUMBER := FND_API.G_MISS_NUM
221: );
222:

Line 219: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

215: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,
218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
219: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
220: ORG_ID NUMBER := FND_API.G_MISS_NUM
221: );
222:
223: G_MISS_TYPEQUALTYPEUSGS_REC typequaltypeusgs_rec_type;

Line 220: ORG_ID NUMBER := FND_API.G_MISS_NUM

216: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
217: CREATION_DATE DATE := FND_API.G_MISS_DATE,
218: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
219: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
220: ORG_ID NUMBER := FND_API.G_MISS_NUM
221: );
222:
223: G_MISS_TYPEQUALTYPEUSGS_REC typequaltypeusgs_rec_type;
224:

Line 247: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,

243: -- End of Comments
244:
245: TYPE typequaltypeusgs_out_rec_type IS RECORD
246: (
247: TYPE_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
248: RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
249: );
250:
251: G_MISS_TYPEQUALTYPUSGS_OUT_REC typequaltypeusgs_out_rec_type;

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

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

Line 282: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,

278: -- End of Comments
279:
280: TYPE TerrTypequal_rec_type IS RECORD
281: (
282: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
283: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 283: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,

279:
280: TYPE TerrTypequal_rec_type IS RECORD
281: (
282: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
283: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

280: TYPE TerrTypequal_rec_type IS RECORD
281: (
282: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
283: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

281: (
282: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
283: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

282: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
283: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

283: QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 288: CREATION_DATE DATE := FND_API.G_MISS_DATE,

284: TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: IN_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

285: EXCLUSIVE_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: IN_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
293: QUALIFIER_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

286: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: IN_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
293: QUALIFIER_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: ORG_ID NUMBER := FND_API.G_MISS_NUM

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

287: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: IN_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
293: QUALIFIER_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: ORG_ID NUMBER := FND_API.G_MISS_NUM
295: );

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

288: CREATION_DATE DATE := FND_API.G_MISS_DATE,
289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: IN_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
293: QUALIFIER_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: ORG_ID NUMBER := FND_API.G_MISS_NUM
295: );
296:

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

289: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: IN_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
293: QUALIFIER_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: ORG_ID NUMBER := FND_API.G_MISS_NUM
295: );
296:
297: G_MISS_TerrTypeQUAL_REC TerrTypequal_rec_type;

Line 294: ORG_ID NUMBER := FND_API.G_MISS_NUM

290: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
291: OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
292: IN_USE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
293: QUALIFIER_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: ORG_ID NUMBER := FND_API.G_MISS_NUM
295: );
296:
297: G_MISS_TerrTypeQUAL_REC TerrTypequal_rec_type;
298:

Line 320: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,

316: -- End of Comments
317:
318: TYPE TerrTypequal_out_rec_type IS RECORD
319: (
320: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
321: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
322: );
323:
324: G_MISS_TerrTypeQUAL_OUT_REC TerrTypequal_out_rec_type;

Line 321: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

317:
318: TYPE TerrTypequal_out_rec_type IS RECORD
319: (
320: TERR_TYPE_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
321: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
322: );
323:
324: G_MISS_TerrTypeQUAL_OUT_REC TerrTypequal_out_rec_type;
325:

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

338: -- parameters :
339:
340: -- in:
341: -- p_api_version_number in number required
342: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
343: -- p_commit in varchar2 optional --default = fnd_api.g_false
344: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
345: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
346: -- p_TerrTypeusgs_tbl in TerrTypeusgs_rec_type required --default = g_miss_tersrc_rec

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

339:
340: -- in:
341: -- p_api_version_number in number required
342: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
343: -- p_commit in varchar2 optional --default = fnd_api.g_false
344: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
345: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
346: -- p_TerrTypeusgs_tbl in TerrTypeusgs_rec_type required --default = g_miss_tersrc_rec
347: -- p_TypequalTypeusgs_tbl in TypeQualTypeUsgs_tbl_type required --default = g_miss_tersrc_tbl,

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

366: -- end of comments
367:
368: procedure create_terrtype
369: ( p_api_version_number in number,
370: p_init_msg_list in varchar2 := fnd_api.g_false,
371: p_commit in varchar2 := fnd_api.g_false,
372: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
373: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
374: p_TerrTypeusgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,

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

367:
368: procedure create_terrtype
369: ( p_api_version_number in number,
370: p_init_msg_list in varchar2 := fnd_api.g_false,
371: p_commit in varchar2 := fnd_api.g_false,
372: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
373: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
374: p_TerrTypeusgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,
375: p_TypeQualTypeUsgs_tbl in TypeQualTypeUsgs_tbl_type := g_miss_typeQualTypeUsgs_tbl,

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

393: -- parameters :
394:
395: -- in:
396: -- p_api_version_number in number required
397: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
398: -- p_commit in varchar2 optional --default = fnd_api.g_false
399: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
400: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
401: -- p_TerrTypesrc_tbl in TerrTypesrc_rec_type required --default = g_miss_tersrc_rec

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

394:
395: -- in:
396: -- p_api_version_number in number required
397: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
398: -- p_commit in varchar2 optional --default = fnd_api.g_false
399: -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
400: -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
401: -- p_TerrTypesrc_tbl in TerrTypesrc_rec_type required --default = g_miss_tersrc_rec
402: -- p_TerrTypeSrcType_tbl in TerrTypeSrcType_tbl_type required --default = g_miss_tersrc_tbl,

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

419: -- end of comments
420:
421: procedure Update_Terrtype
422: ( p_api_version_number in number,
423: p_init_msg_list in varchar2 := fnd_api.g_false,
424: p_commit in varchar2 := fnd_api.g_false,
425: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
426: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
427: p_TerrTypeUsgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,

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

420:
421: procedure Update_Terrtype
422: ( p_api_version_number in number,
423: p_init_msg_list in varchar2 := fnd_api.g_false,
424: p_commit in varchar2 := fnd_api.g_false,
425: p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
426: p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
427: p_TerrTypeUsgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,
428: p_TypeQualTypeUsgs_tbl in TypeQualTypeUsgs_tbl_type := g_miss_TypeQualTypeUsgs_tbl,

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

445: -- parameters :
446: --
447: -- in:
448: -- p_api_version_number in number required
449: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
450: -- p_commit in varchar2 optional --default = fnd_api.g_false
451: -- p_TerrType_id in number
452: --
453: -- out:

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

446: --
447: -- in:
448: -- p_api_version_number in number required
449: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
450: -- p_commit in varchar2 optional --default = fnd_api.g_false
451: -- p_TerrType_id in number
452: --
453: -- out:
454: -- p_return_status out varchar2(1)

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

466: -- end of comments
467:
468: procedure Delete_TerrType
469: ( p_api_version_number in number,
470: p_init_msg_list in varchar2 := fnd_api.g_false,
471: p_commit in varchar2 := fnd_api.g_false,
472: p_TerrType_id in number,
473: x_return_status OUT NOCOPY varchar2,
474: x_msg_count OUT NOCOPY number,

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

467:
468: procedure Delete_TerrType
469: ( p_api_version_number in number,
470: p_init_msg_list in varchar2 := fnd_api.g_false,
471: p_commit in varchar2 := fnd_api.g_false,
472: p_TerrType_id in number,
473: x_return_status OUT NOCOPY varchar2,
474: x_msg_count OUT NOCOPY number,
475: x_msg_data OUT NOCOPY varchar2

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

488: -- parameters :
489: --
490: -- in:
491: -- p_api_version_number in number required
492: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
493: -- p_commit in varchar2 optional --default = fnd_api.g_false
494: -- p_TerrType_id in number
495: --
496: -- out:

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

489: --
490: -- in:
491: -- p_api_version_number in number required
492: -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
493: -- p_commit in varchar2 optional --default = fnd_api.g_false
494: -- p_TerrType_id in number
495: --
496: -- out:
497: -- p_return_status out varchar2(1)

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

509: -- end of comments
510:
511: procedure Deactivate_TerrType
512: ( p_api_version_number in number,
513: p_init_msg_list in varchar2 := fnd_api.g_false,
514: p_commit in varchar2 := fnd_api.g_false,
515: p_TerrType_id in number,
516: x_return_status OUT NOCOPY varchar2,
517: x_msg_count OUT NOCOPY number,

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

510:
511: procedure Deactivate_TerrType
512: ( p_api_version_number in number,
513: p_init_msg_list in varchar2 := fnd_api.g_false,
514: p_commit in varchar2 := fnd_api.g_false,
515: p_TerrType_id in number,
516: x_return_status OUT NOCOPY varchar2,
517: x_msg_count OUT NOCOPY number,
518: x_msg_data OUT NOCOPY varchar2