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.HZ_CONTACT_PREFERENCES_PKG dependencies on FND_API

Line 70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),

66: CREATED_BY_MODULE,
67: APPLICATION_ID
68: )
69: VALUES (
70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),
71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),

Line 71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),

67: APPLICATION_ID
68: )
69: VALUES (
70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),
71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),

Line 72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),

68: )
69: VALUES (
70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),
71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),

Line 73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),

69: VALUES (
70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),
71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),

Line 74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),

70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),
71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),

Line 75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),

71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),

Line 76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),

72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),

Line 77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),

73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),

Line 78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),

74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),

Line 79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),

75: DECODE( X_PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),

Line 80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),

76: DECODE( X_PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM , NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),

Line 81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),

77: DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR , NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),

Line 82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),

78: DECODE( X_PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE),
79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
86: DECODE( X_REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),

Line 83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),

79: DECODE( X_PREFERENCE_END_DATE, FND_API.G_MISS_DATE,to_date(NULL), X_PREFERENCE_END_DATE),
80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
86: DECODE( X_REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
87: DECODE( X_REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),

Line 84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),

80: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR),
81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
86: DECODE( X_REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
87: DECODE( X_REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
88: HZ_UTILITY_V2PUB.CREATED_BY,

Line 85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),

81: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR),
82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
86: DECODE( X_REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
87: DECODE( X_REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
88: HZ_UTILITY_V2PUB.CREATED_BY,
89: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 86: DECODE( X_REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),

82: DECODE( X_PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI),
83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
86: DECODE( X_REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
87: DECODE( X_REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
88: HZ_UTILITY_V2PUB.CREATED_BY,
89: HZ_UTILITY_V2PUB.CREATION_DATE,
90: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 87: DECODE( X_REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),

83: DECODE( X_PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI),
84: DECODE( X_MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
85: DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
86: DECODE( X_REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
87: DECODE( X_REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
88: HZ_UTILITY_V2PUB.CREATED_BY,
89: HZ_UTILITY_V2PUB.CREATION_DATE,
90: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
91: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 97: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

93: HZ_UTILITY_V2PUB.REQUEST_ID,
94: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
95: HZ_UTILITY_V2PUB.PROGRAM_ID,
96: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
97: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
98: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
99: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
100: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
101: ) RETURNING

Line 98: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

94: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
95: HZ_UTILITY_V2PUB.PROGRAM_ID,
96: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
97: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
98: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
99: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
100: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
101: ) RETURNING
102: ROWID,

Line 99: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

95: HZ_UTILITY_V2PUB.PROGRAM_ID,
96: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
97: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
98: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
99: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
100: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
101: ) RETURNING
102: ROWID,
103: CONTACT_PREFERENCE_ID

Line 100: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

96: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
97: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
98: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
99: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
100: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
101: ) RETURNING
102: ROWID,
103: CONTACT_PREFERENCE_ID
104: INTO

Line 171: CONTACT_PREFERENCE_ID = DECODE( X_CONTACT_PREFERENCE_ID, NULL, CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_PREFERENCE_ID ),

167:
168: BEGIN
169:
170: UPDATE HZ_CONTACT_PREFERENCES SET
171: CONTACT_PREFERENCE_ID = DECODE( X_CONTACT_PREFERENCE_ID, NULL, CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_PREFERENCE_ID ),
172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),

Line 172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),

168: BEGIN
169:
170: UPDATE HZ_CONTACT_PREFERENCES SET
171: CONTACT_PREFERENCE_ID = DECODE( X_CONTACT_PREFERENCE_ID, NULL, CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_PREFERENCE_ID ),
172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),

Line 173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),

169:
170: UPDATE HZ_CONTACT_PREFERENCES SET
171: CONTACT_PREFERENCE_ID = DECODE( X_CONTACT_PREFERENCE_ID, NULL, CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_PREFERENCE_ID ),
172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),

Line 174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),

170: UPDATE HZ_CONTACT_PREFERENCES SET
171: CONTACT_PREFERENCE_ID = DECODE( X_CONTACT_PREFERENCE_ID, NULL, CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_PREFERENCE_ID ),
172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),

Line 175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),

171: CONTACT_PREFERENCE_ID = DECODE( X_CONTACT_PREFERENCE_ID, NULL, CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_PREFERENCE_ID ),
172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
179:

Line 176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),

172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
179:
180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),

Line 177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),

173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
179:
180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),
181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),

Line 178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),

174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
175: PREFERENCE_CODE = DECODE( X_PREFERENCE_CODE, NULL, PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),
176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
179:
180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),
181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),
182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),

Line 180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),

176: PREFERENCE_TOPIC_TYPE = DECODE( X_PREFERENCE_TOPIC_TYPE, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE ),
177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
179:
180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),
181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),
182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),
183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),

Line 181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),

177: PREFERENCE_TOPIC_TYPE_ID = DECODE( X_PREFERENCE_TOPIC_TYPE_ID, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_TOPIC_TYPE_ID ),
178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
179:
180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),
181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),
182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),
183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),

Line 182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),

178: PREFERENCE_TOPIC_TYPE_CODE = DECODE( X_PREFERENCE_TOPIC_TYPE_CODE, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_TOPIC_TYPE_CODE ),
179:
180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),
181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),
182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),
183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),

Line 183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),

179:
180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),
181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),
182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),
183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),

Line 184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),

180: PREFERENCE_START_DATE = DECODE( X_PREFERENCE_START_DATE, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_START_DATE ),
181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),
182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),
183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
188: REQUESTED_BY = DECODE( X_REQUESTED_BY, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),

Line 185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),

181: PREFERENCE_END_DATE = DECODE( X_PREFERENCE_END_DATE, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, to_date(NULL), X_PREFERENCE_END_DATE ),
182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),
183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
188: REQUESTED_BY = DECODE( X_REQUESTED_BY, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
189: REASON_CODE = DECODE( X_REASON_CODE, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),

Line 186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),

182: PREFERENCE_START_TIME_HR = DECODE( X_PREFERENCE_START_TIME_HR, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_HR ),
183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
188: REQUESTED_BY = DECODE( X_REQUESTED_BY, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
189: REASON_CODE = DECODE( X_REASON_CODE, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
190: CREATION_DATE = CREATION_DATE,

Line 187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),

183: PREFERENCE_END_TIME_HR = DECODE( X_PREFERENCE_END_TIME_HR, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_HR ),
184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
188: REQUESTED_BY = DECODE( X_REQUESTED_BY, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
189: REASON_CODE = DECODE( X_REASON_CODE, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
190: CREATION_DATE = CREATION_DATE,
191: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 188: REQUESTED_BY = DECODE( X_REQUESTED_BY, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),

184: PREFERENCE_START_TIME_MI = DECODE( X_PREFERENCE_START_TIME_MI, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_START_TIME_MI ),
185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
188: REQUESTED_BY = DECODE( X_REQUESTED_BY, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
189: REASON_CODE = DECODE( X_REASON_CODE, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
190: CREATION_DATE = CREATION_DATE,
191: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 189: REASON_CODE = DECODE( X_REASON_CODE, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),

185: PREFERENCE_END_TIME_MI = DECODE( X_PREFERENCE_END_TIME_MI, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, X_PREFERENCE_END_TIME_MI ),
186: MAX_NO_OF_INTERACTIONS = DECODE( X_MAX_NO_OF_INTERACTIONS, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, X_MAX_NO_OF_INTERACTIONS),
187: MAX_NO_OF_INTERACT_UOM_CODE = DECODE( X_MAX_NO_OF_INTERACT_UOM_CODE, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, X_MAX_NO_OF_INTERACT_UOM_CODE ),
188: REQUESTED_BY = DECODE( X_REQUESTED_BY, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, X_REQUESTED_BY ),
189: REASON_CODE = DECODE( X_REASON_CODE, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, X_REASON_CODE ),
190: CREATION_DATE = CREATION_DATE,
191: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
193: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 198: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

194: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
195: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
196: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
197: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
198: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
199: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
200: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
201: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
202: WHERE ROWID = X_RowId;

Line 199: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

195: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
196: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
197: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
198: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
199: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
200: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
201: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
202: WHERE ROWID = X_RowId;
203:

Line 200: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

196: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
197: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
198: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
199: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
200: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
201: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
202: WHERE ROWID = X_RowId;
203:
204: IF ( SQL%NOTFOUND ) THEN

Line 201: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

197: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
198: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
199: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
200: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
201: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
202: WHERE ROWID = X_RowId;
203:
204: IF ( SQL%NOTFOUND ) THEN
205: RAISE NO_DATA_FOUND;

Line 392: NVL( CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM ),

388:
389: BEGIN
390:
391: SELECT
392: NVL( CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM ),
393: NVL( CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR ),
394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),
395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),

Line 393: NVL( CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR ),

389: BEGIN
390:
391: SELECT
392: NVL( CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM ),
393: NVL( CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR ),
394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),
395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),

Line 394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),

390:
391: SELECT
392: NVL( CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM ),
393: NVL( CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR ),
394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),
395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),

Line 395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),

391: SELECT
392: NVL( CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM ),
393: NVL( CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR ),
394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),
395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),

Line 396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),

392: NVL( CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM ),
393: NVL( CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR ),
394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),
395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),

Line 397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),

393: NVL( CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR ),
394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),
395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),

Line 398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),

394: NVL( CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM ),
395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),

Line 399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),

395: NVL( CONTACT_TYPE, FND_API.G_MISS_CHAR ),
396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),

Line 400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),

396: NVL( PREFERENCE_CODE, FND_API.G_MISS_CHAR ),
397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),

Line 401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),

397: NVL( PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR ),
398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),

Line 402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),

398: NVL( PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM ),
399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),

Line 403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),

399: NVL( PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR ),
400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),

Line 404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),

400: NVL( PREFERENCE_START_DATE, FND_API.G_MISS_DATE ),
401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),

Line 405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),

401: NVL( PREFERENCE_END_DATE, FND_API.G_MISS_DATE ),
402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),

Line 406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),

402: NVL( PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM ),
403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),
410: NVL( STATUS, FND_API.G_MISS_CHAR ),

Line 407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),

403: NVL( PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM ),
404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),
410: NVL( STATUS, FND_API.G_MISS_CHAR ),
411: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),

404: NVL( PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM ),
405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),
410: NVL( STATUS, FND_API.G_MISS_CHAR ),
411: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
412: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),

405: NVL( PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM ),
406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),
410: NVL( STATUS, FND_API.G_MISS_CHAR ),
411: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
412: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
413: INTO

Line 410: NVL( STATUS, FND_API.G_MISS_CHAR ),

406: NVL( MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM ),
407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),
410: NVL( STATUS, FND_API.G_MISS_CHAR ),
411: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
412: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
413: INTO
414: X_CONTACT_PREFERENCE_ID,

Line 411: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

407: NVL( MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR ),
408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),
410: NVL( STATUS, FND_API.G_MISS_CHAR ),
411: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
412: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
413: INTO
414: X_CONTACT_PREFERENCE_ID,
415: X_CONTACT_LEVEL_TABLE,

Line 412: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

408: NVL( REQUESTED_BY, FND_API.G_MISS_CHAR ),
409: NVL( REASON_CODE, FND_API.G_MISS_CHAR ),
410: NVL( STATUS, FND_API.G_MISS_CHAR ),
411: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
412: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
413: INTO
414: X_CONTACT_PREFERENCE_ID,
415: X_CONTACT_LEVEL_TABLE,
416: X_CONTACT_LEVEL_TABLE_ID,

Line 444: RAISE FND_API.G_EXC_ERROR;

440: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
441: FND_MESSAGE.SET_TOKEN( 'RECORD', 'contact_preference_rec');
442: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CONTACT_PREFERENCE_ID ) );
443: FND_MSG_PUB.ADD;
444: RAISE FND_API.G_EXC_ERROR;
445:
446: END Select_Row;
447:
448: PROCEDURE Delete_Row (