APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 640: select code_conversion_id from ozf_supp_code_conversions_all where external_code = cv_external_code

636: , cv_start_date_active DATE
637: , cv_end_date_active DATE
638: , cv_conv_id NUMBER := -1)
639: IS
640: select code_conversion_id from ozf_supp_code_conversions_all where external_code = cv_external_code
641: and code_conversion_id <> cv_conv_id
642: and supp_trade_profile_id = cv_supp_trade_profile_id
643: and ( to_date(cv_start_date_active,'dd-mm-yyyy') between
644: to_date(start_date_active,'dd-mm-yyyy') and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))

Line 648: select code_conversion_id from ozf_supp_code_conversions_all where internal_code = cv_internal_code

644: to_date(start_date_active,'dd-mm-yyyy') and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))
645: or nvl(to_date(cv_end_date_active,'dd-mm-yyyy'),to_Date('31-12-9999','dd-mm-yyyy')) between
646: to_date(start_date_Active,'dd-mm-yyyy') and nvl(to_date(end_date_active,'dd-mm-yyyy'),to_Date('31-12-9999','dd-mm-yyyy')))
647: union
648: select code_conversion_id from ozf_supp_code_conversions_all where internal_code = cv_internal_code
649: and code_conversion_id <> cv_conv_id
650: and supp_trade_profile_id = cv_supp_trade_profile_id
651: and ( to_date(cv_start_date_active,'dd-mm-yyyy') between to_date(start_date_active,'dd-mm-yyyy')
652: and nvl(end_date_active,to_Date('31-12-9999','dd-mm-yyyy'))

Line 859: FROM ozf_supp_code_conversions_all

855: DECODE( p_code_con_rec.attribute12, FND_API.g_miss_char, attribute12, p_code_con_rec.attribute12),
856: DECODE( p_code_con_rec.attribute13, FND_API.g_miss_char, attribute13, p_code_con_rec.attribute13),
857: DECODE( p_code_con_rec.attribute14, FND_API.g_miss_char, attribute14, p_code_con_rec.attribute14),
858: DECODE( p_code_con_rec.attribute15, FND_API.g_miss_char, attribute15, p_code_con_rec.attribute15)
859: FROM ozf_supp_code_conversions_all
860: WHERE supp_trade_profile_id = p_code_con_rec.supp_trade_profile_id
861: AND code_conversion_id = p_code_con_rec.code_conversion_id;
862:
863:

Line 2880: FROM ozf_supp_code_conversions_all

2876:
2877: -- Validate the code conversion Id
2878:
2879: SELECT COUNT(1) INTO l_int_cc_count
2880: FROM ozf_supp_code_conversions_all
2881: WHERE code_conversion_id = l_pvt_code_con_rec.CODE_CONVERSION_ID ;
2882:
2883: IF (l_int_cc_count > 0) THEN
2884: l_del_code_conv.extend ;

Line 2907: INSERT INTO ozf_supp_code_conversions_all(

2903:
2904: -- Mass insertion
2905:
2906: FORALL indx IN 1..l_crt_code_conv.count
2907: INSERT INTO ozf_supp_code_conversions_all(
2908: code_conversion_id,
2909: object_version_number,
2910: last_update_date,
2911: last_updated_by,

Line 2992: Update ozf_supp_code_conversions_all

2988:
2989: -- Mass update
2990: FORALL indx IN 1..l_upd_code_conv.count
2991:
2992: Update ozf_supp_code_conversions_all
2993: SET
2994: object_version_number = l_upd_code_conv(indx).object_version_number +1 ,
2995: last_update_date = sysdate,
2996: last_updated_by = FND_GLOBAL.USER_ID,

Line 3040: DELETE FROM ozf_supp_code_conversions_all

3036: IF (l_del_code_conv.COUNT >0 ) THEN
3037:
3038: -- Mass delete
3039: FORALL indx IN 1..l_del_code_conv.count
3040: DELETE FROM ozf_supp_code_conversions_all
3041: WHERE
3042: code_conversion_id = l_del_code_conv(indx).code_conversion_id ;
3043:
3044: IF (P_Commit = FND_API.G_TRUE) THEN