DBA Data[Home] [Help]

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on OZF_PROCESS_SETUP_PVT

Line 1769: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,

1765: p_supp_trade_profile_rec IN supp_trade_profile_rec_type ,
1766: p_code_conversion_rec_tbl IN code_conversion_tbl_type,
1767: p_price_protection_set_tbl IN process_setup_tbl_type,
1768: x_supp_trade_profile_id OUT NOCOPY NUMBER,
1769: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
1770: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
1771: )
1772: IS
1773:

Line 1828: l_pro_ver_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type ;

1824: l_supp_site_comb_count NUMBER := 0 ;
1825:
1826: l_ref_cust_dtl_rec c_get_cust_dtl%ROWTYPE ;
1827:
1828: l_pro_ver_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type ;
1829:
1830: l_code_conversion_rec supp_code_conversion_rec_type ;
1831: l_code_conversion_rec_tbl code_conversion_tbl_type := code_conversion_tbl_type() ;
1832:

Line 2315: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,

2311: x_msg_data OUT NOCOPY VARCHAR2,
2312: p_supp_trade_profile_rec IN supp_trade_profile_rec_type ,
2313: p_code_conversion_rec_tbl IN code_conversion_tbl_type,
2314: p_price_protection_set_tbl IN process_setup_tbl_type,
2315: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2316: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2317: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2318: X_updated_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2319: X_deleted_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type

Line 2316: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,

2312: p_supp_trade_profile_rec IN supp_trade_profile_rec_type ,
2313: p_code_conversion_rec_tbl IN code_conversion_tbl_type,
2314: p_price_protection_set_tbl IN process_setup_tbl_type,
2315: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2316: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2317: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2318: X_updated_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2319: X_deleted_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
2320: )

Line 3136: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,

3132: X_Msg_Count OUT NOCOPY NUMBER,
3133: X_Msg_Data OUT NOCOPY VARCHAR2,
3134: p_trade_prf_id IN NUMBER,
3135: p_process_setup_tbl IN process_setup_tbl_type ,
3136: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
3137: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type)
3138: IS
3139: L_API_NAME CONSTANT VARCHAR2(30) := 'Process_price_protection';
3140:

Line 3137: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type)

3133: X_Msg_Data OUT NOCOPY VARCHAR2,
3134: p_trade_prf_id IN NUMBER,
3135: p_process_setup_tbl IN process_setup_tbl_type ,
3136: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
3137: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type)
3138: IS
3139: L_API_NAME CONSTANT VARCHAR2(30) := 'Process_price_protection';
3140:
3141: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 3179: l_process_rec OZF_PROCESS_SETUP_PVT.process_setup_rec_type ;

3175: ORDER BY fl.lookup_code ;
3176:
3177: l_process_exists VARCHAR2(1) := 'N' ;
3178:
3179: l_process_rec OZF_PROCESS_SETUP_PVT.process_setup_rec_type ;
3180: l_process_crt_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;
3181: l_crt_count NUMBER := 0 ;
3182:
3183: l_process_upd_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;

Line 3180: l_process_crt_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;

3176:
3177: l_process_exists VARCHAR2(1) := 'N' ;
3178:
3179: l_process_rec OZF_PROCESS_SETUP_PVT.process_setup_rec_type ;
3180: l_process_crt_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;
3181: l_crt_count NUMBER := 0 ;
3182:
3183: l_process_upd_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;
3184: l_upd_count NUMBER := 0 ;

Line 3183: l_process_upd_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;

3179: l_process_rec OZF_PROCESS_SETUP_PVT.process_setup_rec_type ;
3180: l_process_crt_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;
3181: l_crt_count NUMBER := 0 ;
3182:
3183: l_process_upd_tbl OZF_PROCESS_SETUP_PVT.process_setup_tbl_type := OZF_PROCESS_SETUP_PVT.process_setup_tbl_type() ;
3184: l_upd_count NUMBER := 0 ;
3185:
3186: l_org_id NUMBER := 0 ;
3187:

Line 3581: OZF_PROCESS_SETUP_PVT.create_process_setup( p_api_version_number => P_Api_Version_Number ,

3577: ----------------------------------------------------
3578: IF (l_process_crt_tbl.COUNT >0) THEN
3579:
3580:
3581: OZF_PROCESS_SETUP_PVT.create_process_setup( p_api_version_number => P_Api_Version_Number ,
3582: x_return_status => X_Return_Status ,
3583: x_msg_count => X_Msg_Count ,
3584: x_msg_data => X_Msg_Data ,
3585: p_process_setup_tbl => l_process_crt_tbl,

Line 3610: OZF_PROCESS_SETUP_PVT.Update_Process_Setup_Tbl(

3606:
3607: IF (l_process_upd_tbl.COUNT >0) THEN
3608:
3609:
3610: OZF_PROCESS_SETUP_PVT.Update_Process_Setup_Tbl(
3611: P_Api_Version_Number => P_Api_Version_Number ,
3612: P_Init_Msg_List => P_Init_Msg_List ,
3613: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
3614: X_Return_Status => X_Return_Status ,