APPS.JTF_QUAL_TYPE_USGS_PKG dependencies on FND_API

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

40: PACKAGE_SPOOL_FILENAME,
41: ORG_ID
42: ) VALUES (
43: x_QUAL_TYPE_USG_ID,
44: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
45: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
46: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

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

41: ORG_ID
42: ) VALUES (
43: x_QUAL_TYPE_USG_ID,
44: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
45: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
46: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),

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

42: ) VALUES (
43: x_QUAL_TYPE_USG_ID,
44: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
45: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
46: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),

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

43: x_QUAL_TYPE_USG_ID,
44: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
45: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
46: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),

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

44: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
45: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
46: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),
52: decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_NAME),

Line 49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),

45: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
46: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),
52: decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_NAME),
53: decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_SPOOL_FILENAME),

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

46: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),
52: decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_NAME),
53: decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_SPOOL_FILENAME),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));

Line 51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),

47: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),
52: decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_NAME),
53: decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_SPOOL_FILENAME),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
55: OPEN C;

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

48: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),
52: decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_NAME),
53: decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_SPOOL_FILENAME),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
55: OPEN C;
56: FETCH C INTO x_Rowid;

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

49: decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_ID),
50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),
52: decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_NAME),
53: decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_SPOOL_FILENAME),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
55: OPEN C;
56: FETCH C INTO x_Rowid;
57: If (C%NOTFOUND) then

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

50: decode( x_SOURCE_ID, FND_API.G_MISS_NUM, NULL,x_SOURCE_ID),
51: -- decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_FILENAME),
52: decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_NAME),
53: decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_PACKAGE_SPOOL_FILENAME),
54: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
55: OPEN C;
56: FETCH C INTO x_Rowid;
57: If (C%NOTFOUND) then
58: CLOSE C;

Line 95: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),

91: ) IS
92: BEGIN
93: Update JTF_QUAL_TYPE_USGS
94: SET
95: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
96: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
97: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

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

92: BEGIN
93: Update JTF_QUAL_TYPE_USGS
94: SET
95: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
96: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
97: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

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

93: Update JTF_QUAL_TYPE_USGS
94: SET
95: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
96: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
97: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),

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

94: SET
95: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
96: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
97: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),

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

95: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
96: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
97: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),

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

96: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
97: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),
104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),

Line 101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),

97: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),
104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),
105: PACKAGE_SPOOL_FILENAME = decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_SPOOL_FILENAME,x_PACKAGE_SPOOL_FILENAME),

Line 102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),

98: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),
104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),
105: PACKAGE_SPOOL_FILENAME = decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_SPOOL_FILENAME,x_PACKAGE_SPOOL_FILENAME),
106: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

Line 103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),

99: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),
104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),
105: PACKAGE_SPOOL_FILENAME = decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_SPOOL_FILENAME,x_PACKAGE_SPOOL_FILENAME),
106: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
107: where QUAL_TYPE_USG_ID = X_QUAL_TYPE_USG_ID and

Line 104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),

100: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),
104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),
105: PACKAGE_SPOOL_FILENAME = decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_SPOOL_FILENAME,x_PACKAGE_SPOOL_FILENAME),
106: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
107: where QUAL_TYPE_USG_ID = X_QUAL_TYPE_USG_ID and
108: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;

Line 105: PACKAGE_SPOOL_FILENAME = decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_SPOOL_FILENAME,x_PACKAGE_SPOOL_FILENAME),

101: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),
104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),
105: PACKAGE_SPOOL_FILENAME = decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_SPOOL_FILENAME,x_PACKAGE_SPOOL_FILENAME),
106: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
107: where QUAL_TYPE_USG_ID = X_QUAL_TYPE_USG_ID and
108: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
109:

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

102: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
103: -- PACKAGE_FILENAME = decode( x_PACKAGE_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_FILENAME,x_PACKAGE_FILENAME),
104: PACKAGE_NAME = decode( x_PACKAGE_NAME, FND_API.G_MISS_CHAR,PACKAGE_NAME,x_PACKAGE_NAME),
105: PACKAGE_SPOOL_FILENAME = decode( x_PACKAGE_SPOOL_FILENAME, FND_API.G_MISS_CHAR,PACKAGE_SPOOL_FILENAME,x_PACKAGE_SPOOL_FILENAME),
106: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
107: where QUAL_TYPE_USG_ID = X_QUAL_TYPE_USG_ID and
108: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
109:
110: If (SQL%NOTFOUND) then