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

Line 32: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

28: --
29:
30: TYPE Terr_cnr_group_rec_type IS RECORD
31: (
32: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
33: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
34: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

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

29:
30: TYPE Terr_cnr_group_rec_type IS RECORD
31: (
32: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
33: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
34: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

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

30: TYPE Terr_cnr_group_rec_type IS RECORD
31: (
32: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
33: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
34: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,

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

31: (
32: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
33: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
34: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

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

32: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
33: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
34: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,

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

33: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
34: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,

34: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

35: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

36: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

37: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

38: NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

39: DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

40: ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

41: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

42: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

43: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

44: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

45: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

46: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
54: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

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

47: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
54: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
55: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR

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

48: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
54: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
55: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
56: );

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

49: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
54: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
55: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
56: );
57:

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

50: ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
54: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
55: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
56: );
57:
58: G_MISS_TERR_CNR_GROUP_REC Terr_cnr_group_rec_type;

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

51: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
54: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
55: ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
56: );
57:
58: G_MISS_TERR_CNR_GROUP_REC Terr_cnr_group_rec_type;
59:

Line 78: CNR_GROUP_ID NUMBER, --:= FND_API.G_MISS_NUM,

74:
75:
76: TYPE Terr_cnr_group_out_rec_type IS RECORD
77: (
78: CNR_GROUP_ID NUMBER, --:= FND_API.G_MISS_NUM,
79: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
80: );
81:
82: G_MISS_TERR_CNR_GROUP_OUT_REC Terr_cnr_group_out_rec_type;

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

75:
76: TYPE Terr_cnr_group_out_rec_type IS RECORD
77: (
78: CNR_GROUP_ID NUMBER, --:= FND_API.G_MISS_NUM,
79: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
80: );
81:
82: G_MISS_TERR_CNR_GROUP_OUT_REC Terr_cnr_group_out_rec_type;
83:

Line 94: CNR_GROUP_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,

90: -- End of Comments
91:
92: TYPE Terr_cnr_values_rec_type IS RECORD
93: (
94: CNR_GROUP_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,

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

91:
92: TYPE Terr_cnr_values_rec_type IS RECORD
93: (
94: CNR_GROUP_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,

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

92: TYPE Terr_cnr_values_rec_type IS RECORD
93: (
94: CNR_GROUP_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

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

93: (
94: CNR_GROUP_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,

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

94: CNR_GROUP_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

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

95: LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

Line 100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,

96: LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

Line 101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,

97: CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
105: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,

Line 102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

98: CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
105: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
106: ORG_ID NUMBER -- := FND_API.G_MISS_NUM

Line 103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,

99: LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
105: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
106: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
107: );

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

100: CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
105: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
106: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
107: );
108:

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

101: COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
105: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
106: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
107: );
108:
109: G_MISS_TERR_CNR_VALUES_REC Terr_cnr_values_rec_type;

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

102: LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103: HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104: START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
105: END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
106: ORG_ID NUMBER -- := FND_API.G_MISS_NUM
107: );
108:
109: G_MISS_TERR_CNR_VALUES_REC Terr_cnr_values_rec_type;
110:

Line 129: CNR_GROUP_VALUE_ID NUMBER, --:= FND_API.G_MISS_NUM,

125:
126:
127: TYPE Terr_cnr_values_out_rec_type IS RECORD
128: (
129: CNR_GROUP_VALUE_ID NUMBER, --:= FND_API.G_MISS_NUM,
130: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
131: );
132:
133: G_MISS_TERR_CNR_VALUES_OUT_REC Terr_cnr_values_out_rec_type;

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

126:
127: TYPE Terr_cnr_values_out_rec_type IS RECORD
128: (
129: CNR_GROUP_VALUE_ID NUMBER, --:= FND_API.G_MISS_NUM,
130: RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
131: );
132:
133: G_MISS_TERR_CNR_VALUES_OUT_REC Terr_cnr_values_out_rec_type;
134:

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

147:
148: PROCEDURE Create_Terr_Cnr_Group
149: (
150: p_Api_Version_Number IN NUMBER,
151: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
152: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: x_Return_Status OUT NOCOPY VARCHAR2,
155: x_Msg_Count OUT NOCOPY NUMBER,

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

148: PROCEDURE Create_Terr_Cnr_Group
149: (
150: p_Api_Version_Number IN NUMBER,
151: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
152: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: x_Return_Status OUT NOCOPY VARCHAR2,
155: x_Msg_Count OUT NOCOPY NUMBER,
156: x_Msg_Data OUT NOCOPY VARCHAR2,

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

149: (
150: p_Api_Version_Number IN NUMBER,
151: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
152: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: x_Return_Status OUT NOCOPY VARCHAR2,
155: x_Msg_Count OUT NOCOPY NUMBER,
156: x_Msg_Data OUT NOCOPY VARCHAR2,
157: p_Terr_cnr_group_rec IN Terr_cnr_group_rec_type := G_MISS_TERR_CNR_GROUP_REC,

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

160:
161: PROCEDURE Create_Terr_Cnr_Value
162: (
163: p_Api_Version_Number IN NUMBER,
164: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: x_Return_Status OUT NOCOPY VARCHAR2,
168: x_Msg_Count OUT NOCOPY NUMBER,

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

161: PROCEDURE Create_Terr_Cnr_Value
162: (
163: p_Api_Version_Number IN NUMBER,
164: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: x_Return_Status OUT NOCOPY VARCHAR2,
168: x_Msg_Count OUT NOCOPY NUMBER,
169: x_Msg_Data OUT NOCOPY VARCHAR2,

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

162: (
163: p_Api_Version_Number IN NUMBER,
164: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: x_Return_Status OUT NOCOPY VARCHAR2,
168: x_Msg_Count OUT NOCOPY NUMBER,
169: x_Msg_Data OUT NOCOPY VARCHAR2,
170: p_Terr_cnr_values_rec IN Terr_cnr_values_rec_type := G_MISS_TERR_CNR_VALUES_REC,

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

191:
192: PROCEDURE Delete_Terr_Cnr_Group
193: (
194: p_Api_Version_Number IN NUMBER,
195: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,

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

192: PROCEDURE Delete_Terr_Cnr_Group
193: (
194: p_Api_Version_Number IN NUMBER,
195: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,
200: X_Msg_Data OUT NOCOPY VARCHAR2,

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

193: (
194: p_Api_Version_Number IN NUMBER,
195: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,
200: X_Msg_Data OUT NOCOPY VARCHAR2,
201: p_Terr_cnr_group_rec IN Terr_cnr_group_rec_type := G_MISS_TERR_CNR_GROUP_REC

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

203:
204: PROCEDURE Delete_Terr_Cnr_Value
205: (
206: p_Api_Version_Number IN NUMBER,
207: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,

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

204: PROCEDURE Delete_Terr_Cnr_Value
205: (
206: p_Api_Version_Number IN NUMBER,
207: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,
212: X_Msg_Data OUT NOCOPY VARCHAR2,

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

205: (
206: p_Api_Version_Number IN NUMBER,
207: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,
212: X_Msg_Data OUT NOCOPY VARCHAR2,
213: p_Terr_cnr_values_rec IN Terr_cnr_values_rec_type := G_MISS_TERR_CNR_VALUES_REC

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

229:
230: PROCEDURE Update_Terr_Cnr_Group
231: (
232: p_Api_Version_Number IN NUMBER,
233: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: x_Return_Status OUT NOCOPY VARCHAR2,
237: x_Msg_Count OUT NOCOPY NUMBER,

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

230: PROCEDURE Update_Terr_Cnr_Group
231: (
232: p_Api_Version_Number IN NUMBER,
233: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: x_Return_Status OUT NOCOPY VARCHAR2,
237: x_Msg_Count OUT NOCOPY NUMBER,
238: x_Msg_Data OUT NOCOPY VARCHAR2,

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

231: (
232: p_Api_Version_Number IN NUMBER,
233: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: x_Return_Status OUT NOCOPY VARCHAR2,
237: x_Msg_Count OUT NOCOPY NUMBER,
238: x_Msg_Data OUT NOCOPY VARCHAR2,
239: p_Terr_cnr_group_rec IN Terr_cnr_group_rec_type := G_MISS_TERR_CNR_GROUP_REC,

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

242:
243: PROCEDURE Update_Terr_Cnr_Value
244: (
245: p_Api_Version_Number IN NUMBER,
246: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_Return_Status OUT NOCOPY VARCHAR2,
250: x_Msg_Count OUT NOCOPY NUMBER,

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

243: PROCEDURE Update_Terr_Cnr_Value
244: (
245: p_Api_Version_Number IN NUMBER,
246: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_Return_Status OUT NOCOPY VARCHAR2,
250: x_Msg_Count OUT NOCOPY NUMBER,
251: x_Msg_Data OUT NOCOPY VARCHAR2,

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

244: (
245: p_Api_Version_Number IN NUMBER,
246: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_Return_Status OUT NOCOPY VARCHAR2,
250: x_Msg_Count OUT NOCOPY NUMBER,
251: x_Msg_Data OUT NOCOPY VARCHAR2,
252: p_Terr_cnr_values_rec IN Terr_cnr_values_rec_type := G_MISS_TERR_CNR_VALUES_REC,

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

267: --
268:
269: PROCEDURE Validate_Cnr_Group_Value_Rec
270: (
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: x_Return_Status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_DML_Operation IN VARCHAR2,