100:
101:
102: BEGIN
103: IF g_debug THEN
104: OZF_UTILITY_PVT.debug_message( 'Into begin 1');
105: END IF;
106:
107: -- R12 Enhancements
108: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
110: END IF;
111:
112: px_object_version_number := 1;
113: IF g_debug THEN
114: OZF_UTILITY_PVT.debug_message( 'before insert 2');
115: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
116: OZF_UTILITY_PVT.debug_message( 'vendor id is'||p_vendor_id );
117: OZF_UTILITY_PVT.debug_message( 'vendor site id is'||p_vendor_site_id );
118: END IF;
111:
112: px_object_version_number := 1;
113: IF g_debug THEN
114: OZF_UTILITY_PVT.debug_message( 'before insert 2');
115: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
116: OZF_UTILITY_PVT.debug_message( 'vendor id is'||p_vendor_id );
117: OZF_UTILITY_PVT.debug_message( 'vendor site id is'||p_vendor_site_id );
118: END IF;
119:
112: px_object_version_number := 1;
113: IF g_debug THEN
114: OZF_UTILITY_PVT.debug_message( 'before insert 2');
115: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
116: OZF_UTILITY_PVT.debug_message( 'vendor id is'||p_vendor_id );
117: OZF_UTILITY_PVT.debug_message( 'vendor site id is'||p_vendor_site_id );
118: END IF;
119:
120: INSERT INTO ozf_cust_trd_prfls_all(
113: IF g_debug THEN
114: OZF_UTILITY_PVT.debug_message( 'before insert 2');
115: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
116: OZF_UTILITY_PVT.debug_message( 'vendor id is'||p_vendor_id );
117: OZF_UTILITY_PVT.debug_message( 'vendor site id is'||p_vendor_site_id );
118: END IF;
119:
120: INSERT INTO ozf_cust_trd_prfls_all(
121: trade_profile_id,
236: p_line_tolerance_calc_code,
237: p_line_tolerance_operand
238: );
239: IF g_debug THEN
240: OZF_UTILITY_PVT.debug_message( 'after insert 2');
241: END IF;
242:
243: END Insert_Row;
244:
320: IS
321: BEGIN
322:
323: IF g_debug THEN
324: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
325: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_trade_profile_id);
326: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
327: END IF;
328:
321: BEGIN
322:
323: IF g_debug THEN
324: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
325: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_trade_profile_id);
326: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
327: END IF;
328:
329: Update ozf_cust_trd_prfls_all
322:
323: IF g_debug THEN
324: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
325: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_trade_profile_id);
326: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
327: END IF;
328:
329: Update ozf_cust_trd_prfls_all
330: SET