APPS.JTF_TERR_TYPE_QUAL_PKG dependencies on FND_API

Line 60: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

56: QUALIFIER_MODE,
57: ORG_ID
58: ) VALUES (
59: x_TERR_TYPE_QUAL_ID,
60: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
61: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

Line 61: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

57: ORG_ID
58: ) VALUES (
59: x_TERR_TYPE_QUAL_ID,
60: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
61: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),

Line 62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

58: ) VALUES (
59: x_TERR_TYPE_QUAL_ID,
60: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
61: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),

Line 63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

59: x_TERR_TYPE_QUAL_ID,
60: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
61: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),

Line 64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

60: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
61: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),

Line 65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),

61: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),
69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),

Line 66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),

62: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),
69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),
70: decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR, NULL,x_QUALIFIER_MODE),

Line 67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),

63: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),
69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),
70: decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR, NULL,x_QUALIFIER_MODE),
71: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );

Line 68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),

64: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),
69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),
70: decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR, NULL,x_QUALIFIER_MODE),
71: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
72: OPEN C;

Line 69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),

65: decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_USG_ID),
66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),
69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),
70: decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR, NULL,x_QUALIFIER_MODE),
71: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
72: OPEN C;
73: FETCH C INTO x_Rowid;

Line 70: decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR, NULL,x_QUALIFIER_MODE),

66: decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_TERR_TYPE_ID),
67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),
69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),
70: decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR, NULL,x_QUALIFIER_MODE),
71: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
72: OPEN C;
73: FETCH C INTO x_Rowid;
74: If (C%NOTFOUND) then

Line 71: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );

67: decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_EXCLUSIVE_USE_FLAG),
68: decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL,x_OVERLAP_ALLOWED_FLAG),
69: decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR, NULL,x_IN_USE_FLAG),
70: decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR, NULL,x_QUALIFIER_MODE),
71: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
72: OPEN C;
73: FETCH C INTO x_Rowid;
74: If (C%NOTFOUND) then
75: CLOSE C;

Line 113: TERR_TYPE_QUAL_ID = decode( x_TERR_TYPE_QUAL_ID, FND_API.G_MISS_NUM,TERR_TYPE_QUAL_ID,x_TERR_TYPE_QUAL_ID),

109: ) IS
110: BEGIN
111: Update JTF_TERR_TYPE_QUAL
112: SET
113: TERR_TYPE_QUAL_ID = decode( x_TERR_TYPE_QUAL_ID, FND_API.G_MISS_NUM,TERR_TYPE_QUAL_ID,x_TERR_TYPE_QUAL_ID),
114: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

Line 114: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

110: BEGIN
111: Update JTF_TERR_TYPE_QUAL
112: SET
113: TERR_TYPE_QUAL_ID = decode( x_TERR_TYPE_QUAL_ID, FND_API.G_MISS_NUM,TERR_TYPE_QUAL_ID,x_TERR_TYPE_QUAL_ID),
114: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

Line 115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

111: Update JTF_TERR_TYPE_QUAL
112: SET
113: TERR_TYPE_QUAL_ID = decode( x_TERR_TYPE_QUAL_ID, FND_API.G_MISS_NUM,TERR_TYPE_QUAL_ID,x_TERR_TYPE_QUAL_ID),
114: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),

Line 116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

112: SET
113: TERR_TYPE_QUAL_ID = decode( x_TERR_TYPE_QUAL_ID, FND_API.G_MISS_NUM,TERR_TYPE_QUAL_ID,x_TERR_TYPE_QUAL_ID),
114: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),

Line 117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

113: TERR_TYPE_QUAL_ID = decode( x_TERR_TYPE_QUAL_ID, FND_API.G_MISS_NUM,TERR_TYPE_QUAL_ID,x_TERR_TYPE_QUAL_ID),
114: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),

Line 118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

114: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),

Line 119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),

115: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),
123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),

Line 120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),

116: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),
123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),
124: QUALIFIER_MODE = decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR,QUALIFIER_MODE,x_QUALIFIER_MODE),

Line 121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),

117: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),
123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),
124: QUALIFIER_MODE = decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR,QUALIFIER_MODE,x_QUALIFIER_MODE),
125: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID)

Line 122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),

118: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),
123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),
124: QUALIFIER_MODE = decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR,QUALIFIER_MODE,x_QUALIFIER_MODE),
125: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID)
126: where TERR_TYPE_QUAL_ID = X_TERR_TYPE_QUAL_ID;

Line 123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),

119: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),
123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),
124: QUALIFIER_MODE = decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR,QUALIFIER_MODE,x_QUALIFIER_MODE),
125: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID)
126: where TERR_TYPE_QUAL_ID = X_TERR_TYPE_QUAL_ID;
127:

Line 124: QUALIFIER_MODE = decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR,QUALIFIER_MODE,x_QUALIFIER_MODE),

120: TERR_TYPE_ID = decode( x_TERR_TYPE_ID, FND_API.G_MISS_NUM,TERR_TYPE_ID,x_TERR_TYPE_ID),
121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),
123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),
124: QUALIFIER_MODE = decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR,QUALIFIER_MODE,x_QUALIFIER_MODE),
125: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID)
126: where TERR_TYPE_QUAL_ID = X_TERR_TYPE_QUAL_ID;
127:
128: If (SQL%NOTFOUND) then

Line 125: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID)

121: EXCLUSIVE_USE_FLAG = decode( x_EXCLUSIVE_USE_FLAG, FND_API.G_MISS_CHAR,EXCLUSIVE_USE_FLAG,x_EXCLUSIVE_USE_FLAG),
122: OVERLAP_ALLOWED_FLAG = decode( x_OVERLAP_ALLOWED_FLAG, FND_API.G_MISS_CHAR,OVERLAP_ALLOWED_FLAG,x_OVERLAP_ALLOWED_FLAG),
123: IN_USE_FLAG = decode( x_IN_USE_FLAG, FND_API.G_MISS_CHAR,IN_USE_FLAG,x_IN_USE_FLAG),
124: QUALIFIER_MODE = decode( x_QUALIFIER_MODE, FND_API.G_MISS_CHAR,QUALIFIER_MODE,x_QUALIFIER_MODE),
125: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID)
126: where TERR_TYPE_QUAL_ID = X_TERR_TYPE_QUAL_ID;
127:
128: If (SQL%NOTFOUND) then
129: RAISE NO_DATA_FOUND;