APPS.JTF_SOURCES_PKG dependencies on FND_API

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

73: DENORM_DEA_VALUE_TABLE_NAME,
74: ORG_ID
75: ) VALUES (
76: x_SOURCE_ID,
77: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
78: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
79: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

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

74: ORG_ID
75: ) VALUES (
76: x_SOURCE_ID,
77: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
78: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
79: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),

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

75: ) VALUES (
76: x_SOURCE_ID,
77: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
78: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
79: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),

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

76: x_SOURCE_ID,
77: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
78: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
79: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),

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

77: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
78: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
79: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),

Line 82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),

78: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
79: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),

Line 83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),

79: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),

Line 84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),

80: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),

Line 85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),

81: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),

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

82: decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_CODE),
83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),

Line 87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),

83: decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR, NULL,x_LOOKUP_TYPE),
84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),

Line 88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),

84: decode( x_MEANING, FND_API.G_MISS_CHAR, NULL,x_MEANING),
85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),

Line 89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),

85: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),

Line 90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),

86: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),

Line 91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),

87: decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_START_DATE_ACTIVE),
88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),

Line 92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),

88: decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,x_END_DATE_ACTIVE),
89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),

Line 93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),

89: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),

Line 94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),

90: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),

Line 95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),

91: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),
99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),

Line 96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),

92: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),
99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),
100: decode( X_DENORM_DEA_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_DEA_VALUE_TABLE_NAME),

Line 97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),

93: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),
99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),
100: decode( X_DENORM_DEA_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_DEA_VALUE_TABLE_NAME),
101: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID) );

Line 98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),

94: decode( X_RSC_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_RSC_COL_NAME),
95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),
99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),
100: decode( X_DENORM_DEA_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_DEA_VALUE_TABLE_NAME),
101: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID) );
102: OPEN C;

Line 99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),

95: decode( X_ROLE_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_ROLE_COL_NAME),
96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),
99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),
100: decode( X_DENORM_DEA_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_DEA_VALUE_TABLE_NAME),
101: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID) );
102: OPEN C;
103: FETCH C INTO x_Rowid;

Line 100: decode( X_DENORM_DEA_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_DEA_VALUE_TABLE_NAME),

96: decode( X_GROUP_COL_NAME, FND_API.G_MISS_CHAR, NULL,X_GROUP_COL_NAME),
97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),
99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),
100: decode( X_DENORM_DEA_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_DEA_VALUE_TABLE_NAME),
101: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID) );
102: OPEN C;
103: FETCH C INTO x_Rowid;
104: If (C%NOTFOUND) then

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

97: decode( X_RSC_LOV_SQL, FND_API.G_MISS_CHAR, NULL,X_RSC_LOV_SQL),
98: decode( X_RSC_ACCESS_LKUP, FND_API.G_MISS_CHAR, NULL,X_RSC_ACCESS_LKUP),
99: decode( X_DENORM_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_VALUE_TABLE_NAME),
100: decode( X_DENORM_DEA_VALUE_TABLE_NAME, FND_API.G_MISS_CHAR, NULL,X_DENORM_DEA_VALUE_TABLE_NAME),
101: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID) );
102: OPEN C;
103: FETCH C INTO x_Rowid;
104: If (C%NOTFOUND) then
105: CLOSE C;

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

145: ) IS
146: BEGIN
147: Update JTF_SOURCES_ALL
148: SET
149: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
150: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

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

146: BEGIN
147: Update JTF_SOURCES_ALL
148: SET
149: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
150: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

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

147: Update JTF_SOURCES_ALL
148: SET
149: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
150: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),

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

148: SET
149: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
150: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),

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

149: SOURCE_ID = decode( x_SOURCE_ID, FND_API.G_MISS_NUM,SOURCE_ID,x_SOURCE_ID),
150: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),

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

150: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),

Line 155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),

151: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),

Line 156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),

152: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),

Line 157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),

153: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),

Line 158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),

154: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),

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

155: LOOKUP_CODE = decode( x_LOOKUP_CODE, FND_API.G_MISS_CHAR,LOOKUP_CODE,x_LOOKUP_CODE),
156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),

Line 160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),

156: LOOKUP_TYPE = decode( x_LOOKUP_TYPE, FND_API.G_MISS_CHAR,LOOKUP_TYPE,x_LOOKUP_TYPE),
157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),

Line 161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),

157: MEANING = decode( x_MEANING, FND_API.G_MISS_CHAR,MEANING,x_MEANING),
158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),
165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),

Line 162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),

158: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),
165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),
166: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM, RELATED_ID5,x_RELATED_ID5),

Line 163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),

159: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),
165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),
166: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM, RELATED_ID5,x_RELATED_ID5),
167: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

Line 164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),

160: START_DATE_ACTIVE = decode( x_START_DATE_ACTIVE, FND_API.G_MISS_DATE,START_DATE_ACTIVE,x_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),
165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),
166: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM, RELATED_ID5,x_RELATED_ID5),
167: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
168: where SOURCE_ID = X_SOURCE_ID and

Line 165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),

161: END_DATE_ACTIVE = decode( x_END_DATE_ACTIVE, FND_API.G_MISS_DATE,END_DATE_ACTIVE,x_END_DATE_ACTIVE),
162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),
165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),
166: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM, RELATED_ID5,x_RELATED_ID5),
167: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
168: where SOURCE_ID = X_SOURCE_ID and
169: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;

Line 166: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM, RELATED_ID5,x_RELATED_ID5),

162: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM, RELATED_ID1,x_RELATED_ID1),
163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),
165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),
166: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM, RELATED_ID5,x_RELATED_ID5),
167: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
168: where SOURCE_ID = X_SOURCE_ID and
169: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
170:

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

163: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM, RELATED_ID2,x_RELATED_ID2),
164: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM, RELATED_ID3,x_RELATED_ID3),
165: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM, RELATED_ID4,x_RELATED_ID4),
166: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM, RELATED_ID5,x_RELATED_ID5),
167: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
168: where SOURCE_ID = X_SOURCE_ID and
169: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
170:
171: If (SQL%NOTFOUND) then