APPS.JTF_SEEDED_QUAL_PKG dependencies on FND_API

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

43: DESCRIPTION,
44: ORG_ID
45: ) VALUES (
46: x_SEEDED_QUAL_ID,
47: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
48: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

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

44: ORG_ID
45: ) VALUES (
46: x_SEEDED_QUAL_ID,
47: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
48: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),

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

45: ) VALUES (
46: x_SEEDED_QUAL_ID,
47: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
48: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),

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

46: x_SEEDED_QUAL_ID,
47: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
48: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );

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

47: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
48: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
55:

Line 52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),

48: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
55:
56: insert into JTF_SEEDED_QUAL_ALL_TL (

Line 53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),

49: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
55:
56: insert into JTF_SEEDED_QUAL_ALL_TL (
57: SEEDED_QUAL_ID,

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

50: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
51: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
52: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
53: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, x_ORG_ID) );
55:
56: insert into JTF_SEEDED_QUAL_ALL_TL (
57: SEEDED_QUAL_ID,
58: NAME,

Line 132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),

128: x_ORG_ID IN NUMBER
129: ) IS
130: BEGIN
131: Update JTF_SEEDED_QUAL_ALL_B
132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

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

129: ) IS
130: BEGIN
131: Update JTF_SEEDED_QUAL_ALL_B
132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

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

130: BEGIN
131: Update JTF_SEEDED_QUAL_ALL_B
132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),

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

131: Update JTF_SEEDED_QUAL_ALL_B
132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
139: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),

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

132: SET SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
139: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
140: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, X_ORG_ID)

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

133: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
139: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
140: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, X_ORG_ID)
141: where SEEDED_QUAL_ID = X_SEEDED_QUAL_ID and

Line 138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),

134: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
139: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
140: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, X_ORG_ID)
141: where SEEDED_QUAL_ID = X_SEEDED_QUAL_ID and
142: NVL(ORG_ID, -99) = NVL(X_ORG_ID, -99) /* 1331579 BUG FIX */ ;

Line 139: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),

135: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
139: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
140: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, X_ORG_ID)
141: where SEEDED_QUAL_ID = X_SEEDED_QUAL_ID and
142: NVL(ORG_ID, -99) = NVL(X_ORG_ID, -99) /* 1331579 BUG FIX */ ;
143:

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

136: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
137: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
138: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
139: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
140: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, X_ORG_ID)
141: where SEEDED_QUAL_ID = X_SEEDED_QUAL_ID and
142: NVL(ORG_ID, -99) = NVL(X_ORG_ID, -99) /* 1331579 BUG FIX */ ;
143:
144: If (SQL%NOTFOUND) then